// how many rows to show per page
$rowsPerPage = 5;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))$pageNum = $_GET['page'];
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$query = "SELECT id FROM tags LIMIT $offset, $rowsPerPage";
$result = db_query($query);
// print out the tags
while($row = db_array($result))
{
echo $row['id'] . '
';
}
echo '
';
// how many rows we have in database
$query = "SELECT COUNT(id) AS numrows FROM tags WHERE user_id = '".ID."'";
$result = db_query($query);
$row = db_array($result);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
$pagetabs = 5;
$serparator = '...';
if ($pageNum <= 3){$page = 1;}
if ($pageNum = 4){$page = $pageNum-2;$pagetabs = $pagetabs + 1;}
if ($pageNum > 4){$page = $pageNum-2;$pagetabs = $pagetabs + 2;}
if ($pageNum == $maxPage){$page = $maxPage-5;}
echo $page;
echo '-'.$pagetabs;
for($page; $page <= $pagetabs; $page++)
{
if ($page == $pageNum)
{
$nav .= ''.$page.''; // no need to create a link to current page
}else{
if ($page <= 3)
{
$nav .= ''.$page.'';
}
if ($page >= 4)
{
$nav .= ''.$page.'';
}
}
}
// creating previous and next link
// plus the link to go straight to
// the first and last page
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = ' « Previous ';
//$first = '[First Page]';
}
else
{
$prev = '« Previous'; // we're on page one, don't print previous link
//$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = ' Next » ';
//$last = " [Last Page] ";
}
else
{
$next = ' Next »'; // we're on the last page, don't print next link
//$last = ' '; // nor the last page link
}
// print the navigation link
echo '