<?php
@mysql_connect("localhost","truckpar_system","2385826") || die("Error 1");
@mysql_select_db("truckpar_system") || die("Error 2");
$sql = "SELECT * FROM urun";
$sorgu = mysql_query($sql);
$toplam = mysql_num_rows($sorgu);
$limit=10;
$sayfa = !empty($_GET["p"]) ? intval($_GET["p"]) : 1;$s = ($sayfa-1)*$limit;
$sql2 = "SELECT * FROM urun ORDER BY kid ASC LIMIT $s,$limit"; 
$sorgu2 = mysql_query($sql2);
$toplam2 = mysql_num_rows($sorgu2);
$a = ceil($toplam/$limit)+1;
 while($row=mysql_fetch_row($sorgu2)) {
echo "<center><table> 
<tr>"; 
 $img=$row['resim'];
 echo "<td >   <a href="urun.php?id='.$row['id'].'" style="text-decoration:none; color:black;"><br><img border='0' src='$img' width="124" height="100" border="0"></b><a />$baslik</a><hr></hr><p><font color=black>$hit kez oynandı</font></p></td>"; 
 $sayi++; 
    if($sayi % 5 == 0){ 
    echo "</tr>&nbsp;&nbsp;<tr>"; 
    }  
} 
echo "</tr></table></center>";  
      }
echo "<br><br><br><br>";
echo "<span class=yazi>Sayfa:</span> ";
$geri = $sayfa-1;
if($sayfa==1) { echo " <span class=yazi><font color=gray> < </font></span> "; } else { echo " <a href='?p=$geri' class=link> < </a> "; } 
for($i=1;$i<$a;$i++) {
if($sayfa==$i) { echo "<b>".$i."</b> "; } else {
echo "<a href='?p=$i' class=link>$i</a> ";
}
}
$ileri = $sayfa+1;
$b = ceil($toplam/$limit);
if($sayfa==$b) { echo " <span class=yazi><font color=gray> > </font></span> "; } else { echo " <a href='?p=$ileri' class=link> > </a> "; }
echo "<br><br>";
echo "<span class=yazi> <b>Su An Bulundugunuz Sayfa:</b> ".$sayfa."</span>";
echo "<br><br>";
echo "<span class=yazi> <b>Toplam Kayit:</b> ".$toplam."</span>";
echo "<br>";
echo "<span class=yazi> <b>Bir Sayfada Gosterilen Kayit:</b> ".$limit."</span>";
echo "<br>";
echo "<span class=yazi> <b>Toplam Sayfa:</b> ".$b."</span>";
?>