<?php
 connect();
 $limit="300";
 $sayfa = $_GET["nu"];
 echo "Son Aranan Kelimeler<hr>";
 if( empty($sayfa) or !is_numeric($sayfa) ){$sayfa ="1";}
 $query = mysql_query("SELECT * FROM `arananlar_tablom` ORDER BY `zaman` DESC");
 $queryint = mysql_num_rows($query);
 $rowint = ceil($queryint / $limit);
 $last = ($sayfa-1)*$limit;
 $query2 = mysql_query("SELECT * FROM `arananlar_tablom` ORDER BY `zaman` DESC LIMIT $last,$limit");
 while($ab = mysql_fetch_assoc($query2)){
 $progadi = $ab["kelime"];
 $hit = $ab["hit"];
 
  if(!preg_match("/[a-z]:\/\//si",$progadi) && !preg_match("/www/si",$progadi) && 
  !preg_match("/viagra/si",$progadi) && !preg_match("/@/si",$progadi) && !preg_match("/virus/si",$progadi)
  && !preg_match("/*****/si",$progadi) && !preg_match("/*****/si",$progadi) && !preg_match("/******/si",$progadi)
  && !preg_match("/***/si",$progadi) && !preg_match("/erotic/si",$progadi) && !preg_match("/lezbiyen/si",$progadi)
  && !preg_match("/lesbian/si",$progadi) && !preg_match("/gay/si",$progadi) && !preg_match("/%20/si",$progadi)
  && !preg_match("/ö/si",$progadi) && !preg_match("/Ã?Æ?Ã?¼/si",$progadi) && !preg_match("//\//si",$progadi)
  && !preg_match("/Ã?Æ?Ã?¶/si",$progadi) && !preg_match("/ü/si",$progadi) && !preg_match("/Ã?±/si",$progadi)
  && !preg_match("///////////s/si",$progadi) && !preg_match("\\\\\\\/si",$progadi) && !preg_match("/?????????/si",$progadi) 
  ){
 echo "<a href=\"ara.php?ara=".cln($progadi)."\">$progadi</a> (<strong>".$hit."</strong>) - ";}else{echo "";}
 }
 if($sayfa == 1){ 
 $linkCiktisi .= "<small>« Geri</small> ";
 }else{
 $birGeri = $sayfa-1;
 $linkCiktisi .= "<a href='?nu=$birGeri'><small>« Geri</small></a> ";
 } 
 for($i=1; $i <= $rowint; $i++){
 if( $sayfa == $i ){
 $linkCiktisi .= "<b>[$i]</b>";
 continue;
 }
 $linkCiktisi .= "<a href='?nu=$i'><small>$i</small></a> ";
 }
 echo "<hr><br>".$linkCiktisi;
 mysql_close();
?>