I have a wholesale website that i'm working on that shows hundreds of items that are updated from time to time. These items are kept in a mysql database with several tables.
I want to let the the customer browse (from a dynamically created drop down list - which i've done) the items by furniture class, and then have the query results limited to 26 items per page, in two columns using DIVs. The CSS for the DIVs is taken care of, as is the PHP to query the database as shown at: http://www.chinaonsite.com/washburn/ctr4/example.6-8.php
Below is the code that has gotten me this far. I now want to:
*limit results that are shown per page
*have the results shown in two column divs"leftcol" "rightcol"
*dynamically create previous/next/first/last links - paginate
[PHP]
<?php
require "../includes/db.inc";
// selectDistinct() function shown in Example 6-9 goes here
require "example.6-9.php";
// Connect to the server
if (!($conn = @ mysql_connect($hostName, $username, $password)))
;
if (!mysql_select_db($databaseName, $conn))
;
print "<p>\nType of Furniture:</p>";
// Produce the select list
// Parameters:
// 1: Database connection
// 2. Table that contains values
// 3. Attribute that contains values
// 4. <SELECT> element name
// 5. Optional <OPTION SELECTED>
selectDistinct($conn, "furniture_class", "furniture_class_id", "typeName",
"All");
?>
<br />
<input type="submit" value="Show Types" /><br />
</form>
<?php
// Show all items in a furniture class in a
function displayClassList($conn,
$query,
$typeName)
{
// Run the query on the server
if (!($result = @ mysql_query ($query, $conn)))
showerror();
// Find out how many rows are available
$rowsFound = @ mysql_num_rows($result);
// If the query has results ...
if ($rowsFound > 0)
{
// ... print out a header
print "pieces from furniture type $typeName<br>";
// Report how many rows were found
print "{$rowsFound} records found matching your criteria<br>";
// and start a <table>.
print '<ul class="contentone">';
// Fetch each of the query rows
while ($row = @ mysql_fetch_array($result))
{
// Print one row of results
print '<li class="float expand">' .
"<p>{$row["sku_id"]}</p>" .
"<p>{$row["length"]} " ." x " . " {$row["depth"]} " . " x " . "{$row["height"]}</p>" .
"<p>Unit Price: {$row["exWx"]}</p>" .
"<p>Quantity: {$row["quantity"]}</p>" . "<a " .
'class="p1" ' . 'href="../../Product/RAY/070721/' .
"{$row["sku_id"]}" . '.JPG">' .
'<img src="../../Product/RAY/070721/' . "{$row["sku_id"]}" . '.JPG"/>' .
'<img class="large" src="../../Product/RAY/070721/' . "{$row["sku_id"]}" . '.JPG" ' .
'title="' . "{$row["description"]}" . '"/>' .
"</a></li>";
} // end while loop body
// Finish the <table>
print "</ul>";
} // end if $rowsFound body
} // end of function
// Connect to the MySQL server
if (!($conn = @ mysql_connect($hostName, $username, $password)))
die("Could not connect");
// Secure the user parameter $regionName
$typeName = mysqlclean($_GET, "typeName", 30, $conn);
if (!mysql_select_db($databaseName, $conn))
showerror();
// Start a query ...
$query = "SELECT sku_id, description, quantity, exWx, length, depth, height
FROM furniture, furniture_class
WHERE furniture.furniture_class = furniture_class.furniture_class_id";
// ... then, if the user has specified a region, add the typeName
// as an AND clause ...
if (isset($typeName) && $typeName != "All")
$query .= " AND furniture_class_id = \"{$typeName}\"";
// ... and then complete the query.
$query .= " ORDER BY sku_id";
// run the query and show the results
displayClassList($conn, $query, $typeName);
?>
[/PHP]
Any thoughts or ideas would be much appreciated. This is my first PHP driven website, so the hours have been long and frustrating.
Thanks - Siri
