rendered paste body<?php
include("xxxxxxxx"); //connect to DB
$rowsPerPage = 10 ; // set the number of entries we want on each page
$pageNum = 1 ; //set page to 1 initially
if(isset($_GET['page'])) {
$pageNum = $_GET['page']; // set $pageNum to the right page
}
$rowOffset = ($pageNum - 1) * 20 ; // set our $rowOffset
// set our SQL query
$sql = "SELECT bus_name, description, phone, www FROM member_directory LIMIT $rowOffset, $rowsPerPage";
// do it
$result = mysql_query($sql) or die ("Error, query failed");
echo $pageNum; // debugging
// **** handle the $result by printing tables **** //
while($row = mysql_fetch_assoc($result)) {
echo "<table>";
echo "<tr><td colspan=\"2\"><h3>". $row['bus_name']."</h3></td></tr>";
echo "<tr><td colspan=\"2\"><p>". $row['description']."</p></td></tr>";
echo "<tr><td>". $row['phone']."</td><td>". $row['www']."</td></tr></table>";
}
// build navigation links, first, prev, next, last
// start by counting the number or rows in table
// setup SQL
$sql = "SELECT COUNT(id) AS numrows FROM member_directory";
// do it
$result = mysql_query($sql) or die("Error, query failed");
// fill in $numRows
$row = mysql_fetch_assoc($result);
$numRows = $row['numrows'];
// figure out $maxPages
$maxPages = ceil($numRows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = " Page $pageNum of $maxPages";
// first and previous link
if($pageNum > 1) {
$pageNum --;
$first = " <a href=\"$self?page=1\">[First]</a>";
$prev = " <a href=\"$self?page=$pageNum\">[Prev]</a>";
}
else { //were on first page dont print first and previous
$first = " ";
$prev = " ";
}
if($pageNum < $maxPages) {
$pageNum ++;
echo $pageNum; // debugging
$next = " <a href=\"$self?page=$pageNum\">[Next]</a>";
$last = " <a href=\"$self?page=$maxPages\">[Last]</a>";
}
else { // were on the last page dont print next and last
$next = " ";
$last = " ";
}
echo '<h4>'.$first . $prev . $nav . $next . $last.'</h4>';
?>
</body>