تفضل اخوى
كود PHP:
<?php
if(!$page)
{
$page=1;
}
else
{
$page=$_GET['page'];
}
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("DATABASE", $con);
$max=2;
$from=($max*$page)-$max;
$sql = mysql_query("select * from DATABASE");
$num_sql = mysql_num_rows($sql);
$sql1 = mysql_query("select * from DATABASE limit $from,$max");
$num_sql1 = mysql_num_rows($sql1);
$pages=ceil($num_sql/$max);
$result = mysql_query("SELECT * FROM DATABASE");
echo "<table border='1'>
<tr>
<th>id</th>
<th>Name</th>
<th>Age</th>
</tr>";while($row = mysql_fetch_array($sql1))
{
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
if($page>1)
{
$prev=$page-1;
echo"<a href=".$PHP_SELF."?page=$prev></a>";
}
for($i=1;$i<=$pages;$i++)
{
if($page==$i) echo"[$i]";
else
{
echo"<a href=".$PHP_SELF."?page=$i>$i</a>";
}
}
if($page<$pages)
{
$next=$page+1;
echo"<a href=".$PHP_SELF."?page=$next></a>";
}
?>
لاتنسانى من الدعاء