<?php

$limit  = "20";
$sayfa = (!empty($_GET['sayfa'])) ? (int)$_GET['sayfa'] : 1;
$toplam_kayit  = mysql_num_rows(mysql_query("SELECT id FROM imza"));



$offset =  $sayfa * $limit;

$offset = $offset - $limit;

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



$sorgu = "SELECT * FROM imza ORDER BY `id` desc LIMIT ".$limit." OFFSET ".$offset;


$sorgulama = @mysql_query($sorgu);
if (@mysql_num_rows($sorgulama)>0){
//kayıtları listele
while ($kayit=@mysql_fetch_assoc($sorgulama)){
###################### var ##############################################
$isim=$kayit["isim"];
$meslek=$kayit["meslek"];
$sehir=$kayit["sehir"];

echo "<tr>
    <td><font color=\"#000000\" face=\"verdana\" size=\"2\">$isim</font></td>
    <td><font color=\"#000000\" face=\"verdana\" size=\"2\">$meslek</font></td>
    <td><font color=\"#000000\" face=\"verdana\" size=\"2\">$sehir</font></td>
  </tr>";
}
}

echo "<table width=\"100%\" height=\"30px\">";
echo "<td height=\"10\">";
echo "</td>";
echo "</table>";
?>




<?php

echo "<table width=\"100%\">";
echo "<tr width=\"100%\">";
if($sayfa_sayisi < 12)
	{
        
        for($i = 1; $i <= $sayfa_sayisi ; $i++)
        {
            if($i == $sayfa)
            {
                echo "<strong>".$i."</strong>";
                
            }
            else
            {
            
                echo "[<a href=?sayfa=".$i.">".$i."</a>]";    
            }
        }
		
	}else{
		if(isset($_GET['sayfa']) && intval($_GET['sayfa']) > 1)
		{
		echo "[<a href=index.php>ilk sayfa</a>]";
		}
			if(intval($_GET['sayfa']-6) < 1){
			$y= 2;
			}else{
			$y= intval($_GET['sayfa']-6);
			}
	
		 for($r = $y; $r < intval($_GET['sayfa']) && $r > 0 ; $r++)
			{

					
						echo "[<a href=?sayfa=".$r.">".$r."</a>]";    
					
				
			}
		if(intval($_GET['sayfa']) > 1 ){
		echo "<strong>".intval($_GET['sayfa'])."</strong>";
		}
		for($i = intval($_GET['sayfa'])+1; $i < intval($_GET['sayfa'])+7; $i++)
			{
				if($i < $sayfa_sayisi)
				{
					if($i > 1){
						echo "[<a href=?sayfa=".$i.">".$i."</a>]";    
					}
				}
				
				
			}
		if(intval($_GET['sayfa']) < $sayfa_sayisi -7)
				{
					
				echo "[<a href=?sayfa=".$sayfa_sayisi.">son sayfa</a>]";    
					
				}else{
					echo "[<a href=?sayfa=".$sayfa_sayisi.">".$sayfa_sayisi."</a>]";    

				}

	}

echo "</tr>";
echo "</table>";
?>