prepare($query);
$statement->bindValue(':category_id', $category_id);
$statement->execute();
$category = $statement->fetch();
$category_name = $category['categoryName'];
$statement->closeCursor();
//echo $category_name;
//Get all categories
$query = 'SELECT * FROM categories ORDER BY categoryID';
$statement = $db->prepare($query);
$statement->execute();
$categories = $statement->fetchAll();
$statement->closeCursor();
/*
foreach ($categories as $category) :
echo $category['categoryID'];
echo "; ";
echo $category['categoryName'];
echo "
\n";
endforeach;
*/
//Get products for selected category
$query = "SELECT * FROM products WHERE categoryID = :category_id ORDER BY productID";
$statement = $db->prepare($query);
$statement->bindValue(':category_id', $category_id);
$statement->execute();
$products = $statement->fetchAll();
$statement->closeCursor();
/*
foreach ($products as $p)
{
echo $p['productCode']."; ";
echo $p['productName']."; ";
echo $p['listPrice']."
\n ";
} //end foreach
*/
?>
kungfu panda shop
Kungfu Panda - Product Manager
Product List