All pastes #496034 Raw Edit

Something

public text v1 · immutable
·published 2007-05-19 00:33 UTC
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 = "&nbsp;";
		$prev = "&nbsp;";
		}
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 = "&nbsp;";
		$last = "&nbsp;";
		}
echo '<h4>'.$first . $prev . $nav . $next . $last.'</h4>';
?>
 </body>