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

Kungfu Panda - Product Manager

Product List

Code Name Price
$

Add Product