<form class="navbar-form navbar-left" role="search" action="" method="get" >
<div class="form-group">
<input type="search" class="form-control" name="arama" placeholder="Ara">
</div>
<button type="submit" class="btn btn-default">Ara</button>
</form>

<?php

include("config.php");

if(@$_GET['arama']){

$sayfa = @$_GET['id'] ? $_GET['id']:0;

$say = $veri -> query("SELECT * FROM arac");
$toplamveri = $say -> rowCount();

$bireksigi = $toplamveri-1;;

$limit =1;

$sayfa_sayisi = ceil($toplamveri / $limit);

$goster = $limit * $limit - $limit;
$gorunensayfa = 3;
$makale = $veri -> query("SELECT * FROM arac WHERE baslik LIKE '%{$_GET['arama']}%' ORDER BY id DESC LIMIT $goster ,$limit");

$row = $makale -> rowCount();


$hep = $makale -> fetchAll(PDO::FETCH_ASSOC);

foreach($hep as $makalebas){


?>

<table class="table table-condensed">

<tr><td class="success">
<span class="glyphicon glyphicon-envelope" aria-hidden="true"><a href="goster.php?goster=<?php echo $makalebas['id']?>">
<?php echo $makalebas['baslik'] ?></a></span></td>

</tr>

</table>

<?php

}


?>

<nav>
<ul class="pagination">

<?php 
if($sayfa > 1){
?>
<li>
<a href='?id=<?=$sayfa - 1?>' aria-label="Previous">
<span aria-hidden="true">&laquo;</span>
</a>
</li>

<?php 
}

for($i =$row-$gorunensayfa; $i < $row + $gorunensayfa+1; $i++){


if($i > 0 && $i <= $sayfa_sayisi){

if($i != $sayfa){

echo"<li><a href='?arama={$_GET['arama']}&id=$i'>$i</a></li>
"; 
}
}


?>

<?php

}

if($sayfa != $sayfa_sayisi){
?>
<li>
<a href="?id=<?=$sayfa + 1?>" aria-label="Next">
<span aria-hidden="true">&raquo;</span>
</a>
</li>

<?php

}

}

?>
</ul>
</nav>

<h4>Üye girişi</h4>
<form class="form-horizontal" method="post" action="">
  <div class="form-group">
    <label for="inputEmail3" class="col-sm-2 control-label">Email</label>
    <div class="col-sm-10">
      <input type="email" class="form-control" id="inputEmail3" placeholder="Email" name="posta">
    </div>
  </div>
  <div class="form-group">
    <label for="inputPassword3" class="col-sm-2 control-label">Password</label>
    <div class="col-sm-10">
      <input type="password" class="form-control" id="inputPassword3" placeholder="Password" name="password">
    </div>
  </div>
  
  
  
  <div class="form-group">
    <label for="inputText3" class="col-sm-2 control-label">kullanıcı adı:</label>
    <div class="col-sm-10">
      <input type="text" class="form-control" id="inputText3" placeholder="kullanıcı adı" name="kullanici">
    </div>
  </div>
  
  
  
  
  <div class="form-group">
    <div class="col-sm-offset-2 col-sm-10">
      <button type="submit" class="btn btn-danger">üye girişi</button>
    </div>
  </div>
</form>

//admin kullanıcı:

	$yuvarlak = new MySQLi('localhost','root','','amerika');

            $tr= $yuvarlak -> set_charset("utf8");
			$vipkul= $yuvarlak -> real_escape_string($_POST['kullanici']);    $vippass= $yuvarlak -> real_escape_string($_POST['password']);
			$vippost= $yuvarlak -> real_escape_string($_POST['posta']);
			$q = $yuvarlak -> query("SELECT * FROM uyeler WHERE kullanici_adi='{$vipkul}' AND sifre='{$vippass}' AND email='{$vippost}'");
			
		if($q -> num_rows){
			
		$_SESSION['oturum']=1;	
			
			
			
			}	
			
		else{
		$_SESSION['oturum']=0;	
			}	


if(!empty($_SESSION['oturum']) == 1){
	
	
	

          
			echo "<li><a href='gitardersleri.html'>Gitar dersleri</a></li> "; 
}
?>