|
$id, $stednavn, $grend "; } echo ' '; // how many rows we have in database if ($soke == 'Oza / Søk' || $navnS != "") { $query2 = "SELECT COUNT(id) AS numrows FROM stedsnavn WHERE stednavn LIKE '%$navnS%' AND grend not LIKE ''"; } else { $query2 = "SELECT COUNT(id) AS numrows FROM stedsnavn WHERE stednavn LIKE '$sn' AND grend not LIKE ''"; } $result2 = mysqli_query($forbindelse, $query2) or die('Error, query failed'); $row = mysqli_fetch_array($result2, MYSQLI_ASSOC); $numrows = $row['numrows']; // how many pages we have when using paging? $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; // creating 'previous' and 'next' link // plus 'first page' and 'last page' link // print 'previous' link only if we're not // on page one if ($pageNum > 1) { $page = $pageNum - 1; if ($soke == 'Oza / Søk' || $navnS != "") { $prev = " [Forrige] "; $first = " [1. side] "; }else { $prev = " [Forrige] "; $first = " [1. side] "; } } else { $prev = ' [Forrige] '; // we're on page one, don't enable 'previous' link $first = ' [1. side] '; // nor 'first page' link } // print 'next' link only if we're not // on the last page if ($pageNum < $maxPage) { $page = $pageNum + 1; if ($soke == 'Oza / Søk' || $navnS != "") { $next = " [Neste] "; $last = " [Siste side] "; } else{ $next = " [Neste] "; $last = " [Siste side] "; } } else { $next = ' [Neste] '; // we're on the last page, don't enable 'next' link $last = ' [Siste side] '; // nor 'last page' link } // print the page navigation link echo $first . $prev . " Showing page $pageNum of $maxPage pages " . $next . $last; mysqli_close($forbindelse); ?> |
|