Simple Pagination
Listed In Uncategorized » — Viewing Full Tutorial
<?php
/*
SIMPLE PHP PAGINATION BY FEDEKILLER
*/
include("config.php");//Includes the configuration file
$table = 'tutorials_content';//Table name here
$limit = 42;//Limit of results here
$page = $_GET['page'];//Gets the page
$totalrows = mysql_num_rows(mysql_query("SELECT id FROM $table"));//Get the total rows of the table
if(empty($page))//If the page is empty
{
$page = '1';//sets the page to 1
};
$start = ($page-1)*$limit;//set the start page
$start = round($start,0);//rounds it
$result = mysql_query("SELECT * FROM $table LIMIT $start, $limit");//makes the query, here you can add for example
//WHERE something='somethingelse'
while ($r = mysql_fetch_array($result))
{
echo "$r[title]<br>";
};
$totalpages = $totalrows / $limit;//Gets the totalpages
$totalpages = ceil($totalpages);//rounds them to the bigger number, so if the limit is 10 and there are 11 results it will show 2 paegs instead of 1 :)
if($page == 1)//if the page is 1
{
$actualpage = '[1]';//actial page 1
}
else
{
$actualpage = "[$page]";//else actualpage is the one we get using the $_GET
}
if($page < $totalpages)//if the page is smaller than totalpages
{
$nv = $page+1;//next page
$pv = $page-1;//prev page
$nextpage = "<a href=?page=$nv>></a>";//next page link
$prevpage = "<a href=?page=$pv><</a>";//preg page link
$firstpage = "<a href="?page=1">«</a>";//first page
$finalpage = "<a href="?page=$totalpages">»</a>";//last page
}
if($page == '1')//if the page is 1
{
$nv = $page+1;
$nextpage = "<a href=?page=$nv>> </a>";
$prevpage = "<";
$firstpage = "«";
$finalpage = "<a href="?page=$totalpages">»</a>";
}elseif($page == $totalpages){//is the page is equal than the totalpages
$pv = $page-1;
$nextpage = ">";
$prevpage = "<a href=?page=$pv><</a>";
$firstpage = "<a href="?page=1">«</a>";
$finalpage = "»";
}
if($totalpages == '1' || $totalpages == '0'){//if totalpages is 1 or 0
$nextpage = ">";
$prevpage = "<";
$firstpage = "«";
$finalpage = "»";
}
echo "$firstpage $prevpage $actualpage $nextpage $finalpage<br>Pages: $totalpages";//echoes the pages at the botton of the file
?>
Hope you find this useful, any problem, pm me
