Konsep paging di PHP

Paging adalah konsep menampilkan data perhalaman dengan jumlah data perhalamannya sesuai yang diinginkan, di bawah ini contoh script PHP untuk menampilkan 5 data perhalaman:


<?
$host = “localhost”;
$user = “root”;
$pass = “”;

$db = “info”;
$conn = mysql_connect(”$host”,”$user”,”$pass”) or die (”Gagal Melakukan Koneksi ke Database Server”);
echo mysql_error();
mysql_select_db(”$db”,$conn) or die (”Database Tidak Ditemukan”);

$record_home = 5;
if(!$_GET['page'])
$page = 0;
else
$page = $_GET['page'];
$qmon = “select * from info order by id desc limit $page,$record_home”;
$query = mysql_query($qmon, $conn);
echo mysql_error();

if(mysql_num_rows($query)==0)
{
echo “<BR>Tidak terdapat berita”;
}
else
{
?>

<DL>
<?
while($br = mysql_fetch_row($query))
{
?>
<DT><?=$br[1]?></DD>
<?
}

?>
</DL>
<?
}
?>
<hr size=1>
<CENTER>
<?
if($page-$record_home>=0)

{
?>
<a href=”?page=0″>First</a> – <a href=”?page=<?=$page-$record_home?>”>Previous</a> -

<?
}
else
{
?>
First – Previous -
<?
}

$nav = “select count(*) from info”;
$query = mysql_query($nav,$conn);
$brs=mysql_fetch_row($query);
$n = $brs[0];
if ($page+$record_home<ceil($n/$record_home)*$record_home)
{
?>

<a href=”?page=<?=$page+$record_home?>”>Next</a> – <a href=”?page=<?=(ceil($n/$record_home)*$record_home)-$record_home?>”>Last</a>
<?
}

else
{
?>
Next – Last
<?
}
?></CENTER>

Sumber:
http://forum.linux.or.id/viewtopic.php?t=2970