michael_heraghty - 7:40 pm on Nov 22, 2007 (gmt 0)

Hi,

I have just created my first database-driven page using PHP. It just takes data from a single table, and gives the user certain ways to order the data.

However, all the data is coming out on a single web page, which is too long.

Can anyone show me how to add some simple pagination? Here is the code.

Advice much appreciated (including any errors you see)!

<?php
/* This script gets listings from the database */
$db = mysql_connect("x", "y", "z");
if (!$db)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("x", $db);

$orderby = $_GET["orderby"];
$selectcategory = $_POST[selectcategory];

/* If the user has clicked an 'ordered by' link*/
if ($orderby == 'category'):
$sql = "SELECT * FROM localfood ORDER BY category";
elseif ($orderby == 'name'):
$sql = "SELECT * FROM localfood ORDER BY name";

//if the user has chosen a category from the drop-down
elseif (!empty($selectcategory)) :
$sql = "SELECT * FROM localfood WHERE category ='".$selectcategory."'";
else:
$sql = "SELECT * FROM localfood ORDER BY name";
endif;

/*Process the query and build the html table*/
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
print("<tr><td> ");
printf("<h3>%s</h3></td></tr>\n",
$row["name"]);

print("<tr><td><strong>Category:</strong> ");
printf("%s</td></tr>\n",
$row["category"]);

print("<tr><td><strong>Address:</strong><br />");
printf("%s</td></tr>\n",
$row["address"]);

print("<tr><td><strong>Phone:</strong> ");
printf("%s</td></tr>\n",
$row["phone"]);
printf("<tr><td><strong>Email:</strong> <a href=\"mailto:%s\">%s</a></td></tr>\n",
$row["email"], $row["email"]);
printf("<tr><td><strong>Web:</strong> <a href=\"%s\">%s</a>\n",
$row["web"], $row["web"]);
print("</td></tr>\n<tr><td><strong>Details:</strong><br />");
printf("%s</td></tr>\n",
$row["details"]);
}

?>