<?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)) {
        $say++;
        if($say==5) { echo '</tr><tr>'; $say=1; }
        echo '<td style="border: 1px solid #800000; width: 125px" align="center">    
                <a href="urun.php?id='.$row['id'].'" style="text-decoration:none; color:black;"><b>'.$row['baslik'].'<br><img alt="" src="'.$row['resim'].'" width="124" height="100" border="0"></b></a>
              </td>';}
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>";
?>