<?php
$page = $_GET['page'];
if(!$page || $page == 0 || !is_numeric($page)){
$page = 1;
}
$limit = 5;
class paginate{
function init($limit, $page){
$query1 = mysql_query("SELECT * FROM portfolio");
$total_pages = ceil(mysql_num_rows($query1)/$limit);
$prev = '<a href="?page=' . ($page-1) . '">Prev</a>';
$next = '<a href="?page=' . ($page+1) . '">Next</a>';
if($page <= 1){
$page = 1;
$prev = '';
}
elseif($page >= $total_pages){
$page = $total_pages;
$next = '';
}
if($page > 2){
$prev = '<a href="?page=1">First</a> ' . $prev;
}
if($page < ($total_pages - 1)){
$next = $next . ' <a href="?page=' . $total_pages . '">Last</a>';
}
$start = ($limit*($page-1));
$query2 = mysql_query("SELECT * FROM portfolio LIMIT $start, $limit") or die("Error
In Query " . mysql_error());
$times_done=0;
while($row = mysql_fetch_array($query2)) {
if($times_done=='5'){
$content .= '<br><br>';
$times_done=1;
}
else{
$times_done++;
}
$content .= '<li>'.$row['name'].'<br/>'.'<a href="http://'.$row['address'].'"<img src="'.$row['image'].'"width="400" />'.'</a>'.'</li>';
}
$content .= '<br><hr>' . $prev . ' Page ' . $page . '/' . $total_pages . ' ' . $next;
return $content;
}
}
$class = &new paginate;
echo $class->init($limit, $page);
?>

$sql = "SELECT id FROM portfolio";

$get = mysql_query($sql);

$limit = mysql_num_rows($get);