LPJ@TUMBLR

PHP Pagination (from database)

//get the pagenum from url or else = 1

$pagenum = $_GET[‘page’];

if (!(isset($pagenum))){ 

$pagenum = 1; 

} 

//query to set number of pages

$first_query = mysql_query(“SELECT * FROM content”);

$first_num = mysql_num_rows($first_query);

//rows per page

$rows_per_page = 5;

$last_page = ceil($first_num/$rows_per_page);

//always “reset” pages.

if ($pagenum < 1){ 

$pagenum = 1; 

}elseif ($pagenum > $last_page){ 

$pagenum = $last_page; 

}

//this is the limit

$max = ($pagenum - 1) * $rows_per_page .’,’ .$rows_per_page;

//final query

$query = mysql_query(“SELECT * FROM content ORDER BY id DESC LIMIT $max”);

//newer-button

if($pagenum != 1){

$newer = $pagenum-1;

echo “<a href=’”.$root.”?page=$newer’>< Newer</a>”;

}

//older-button

if($pagenum != $last_page){

$older = $pagenum+1;

echo ” <a href=’”.$root.”?page=$older’> Older ></a> “;

}