صفحه بندی اطلاعات خروجی دیتا بیس
PHP:
<?php
print "<table width='400' border='0' align='center' cellpadding='0' cellspacing='0'>";
print "<tr>";
print "<td><div align='center'>";
if(!isset($start)) $start = 0;
$conn = mysql_connect('hostname', 'username', 'password') or die(mysql_error());
mysql_select_db('Database_name', $conn) or die(mysql_error());
$query1 = "SELECT * FROM Table_name ORDER BY Field_name DESC LIMIT " . $start . ", 10";
$query = "SELECT count(*) as count FROM Table_name ";
$result1 = mysql_query($query1);
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
// Previous page
if($start > 0)
print "<a href=?start=" . ($start - 10) . ">Previous page</a>"." " ;
// page_num
if($numrows > (0)) {print " ";print "<a href=?start=" . (0) . "> 1 </a>";print " ";}
if($numrows > (10)){print " ";print "<a href=?start=" . (10) . "> 2 </a>";print " ";}
if($numrows > (20)){print " ";print "<a href=?start=" . (20) . "> 3 </a>";print " ";}
if($numrows > (30)){print " ";print "<a href=?start=" . (30) . "> 4 </a>";print " ";}
if($numrows > (40)){print " ";print "<a href=?start=" . (40) . "> 5 </a>";print " ";}
if($numrows > (50)){print " ";print "<a href=?start=" . (50) . "> 6 </a>";print " ";}
if($numrows > (60)){print " ";print "<a href=?start=" . (60) . "> 7 </a>";print " ";}
if($numrows > (70)){print " ";print "<a href=?start=" . (70) . "> 8 </a>";print " ";}
if($numrows > (80)){print " ";print "<a href=?start=" . (80) . "> 9 </a>";print " ";}
if($numrows > (90)){print " ";print "<a href=?start=" . (90) . "> 10 </a>";print " ";}
// next page
if($numrows > ($start + 10))
print " "."<a href=?start=" . ($start + 10) . ">next page</a>";
$rrr = mysql_query($query1, $conn);
$roooow=@mysql_num_rows($rrr);
if ($rrr && $roooow>0){
while ($rorrrrw=@mysql_fetch_assoc($rrr)){
$sssb=($rorrrrw['Picture']);//Field_name
$sssss=($rorrrrw['Price']);//Field_name
print "</div> </td>";
print "</tr>";
print "<tr>";
print " <td><div align='center'></div></td>";
print "</tr>";
print "<tr>";
print "<td height='52' align='right' background=''><div align='right'>";
// print Field
print ($sssb);
print ($sssss);
print " <br>";
print " </div></td>";
print "</tr>";
print " <tr>";
print " <td><div align='center'>";
}
}else{
echo("NO RECORDE");
}
print "</div></td>";
print " </tr>";
print "</table>";
?>
آخرین ویرایش:
