My Guitar Shop Product Manager Product List Categories > Code Name Price value= > value= > Add Product List Categories My Guitar Shop, Inc.

require_once('database.php');

// Get category ID

if (!isset($category_id)) {

$category_id = filter_input(INPUT_GET, 'category_id',

FILTER_VALIDATE_INT);

if ($category_id == NULL || $category_id == FALSE) {

$category_id = 1;

}

}

// Get name for selected category

$queryCategory = 'SELECT * FROM categories

WHERE categoryID = :category_id';

$statement1 = $db->prepare($queryCategory);

$statement1->bindValue(':category_id', $category_id);

$statement1->execute();

$category = $statement1->fetch();

$category_name = $category['categoryName'];

$statement1->closeCursor();

// 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();

?>

Product Manager

Product List

Categories

• ">

Code	Name	Price
			value=""> value="">

Add Product

List Categories

© My Guitar Shop, Inc.

Assignment 4-1 - Start from the solution for exercise 4-1. - Add another column to the Product List table that contains Edit buttons. These buttons should link to an Edit Product page that works similarly to the Add Product page, but this page should contain the data for the selected product and have an Update Product button below the text boxes. When this button is clicked, the product should be updated. - To keep things simple, display the category ID in a text box. For extra credit, use a dropdown list to display the correct category name for the product that's being edited. - To learn how to code an UPDATE statement that updates multiple columns, see chapter 18