public static function getProductsByCategory($category_id)
{
$db = Database::getDB();
$category = CategoryDB::getCategory($category_id);
$query = "SELECT * FROM products\n WHERE categoryID = '{$category_id}'\n ORDER BY productID";
$result = $db->query($query);
$products = array();
foreach ($result as $row) {
$product = new Product($category, $row['productCode'], $row['productName'], $row['listPrice']);
$product->setId($row['productID']);
$products[] = $product;
}
return $products;
}
public function getProduct($product_id)
{
$db = Database::getDB();
$query = "SELECT * FROM products\n WHERE productID = '{$product_id}'";
$result = $db->query($query);
$row = $result->fetch();
$category = CategoryDB::getCategory($row['categoryID']);
$product = new Product();
$product->setCategory($category);
$product->setId($row['productID']);
$product->setCode($row['productCode']);
$product->setName($row['productName']);
$product->setPrice($row['listPrice']);
return $product;
}
private function createProducts()
{
$ipad = new Product();
$ipad->setId(1);
$ipad->setDescription('A brand new 16 GIGA iPad');
$ipad->setPrice('499.00');
$this->allProducts[] = $ipad;
$iphone = new Product();
$iphone->setId(2);
$iphone->setDescription('A brand new 32 GIGA iPhone');
$iphone->setPrice(599.0);
$this->allProducts[] = $iphone;
$ipod = new Product();
$ipod->setId(3);
$ipod->setDescription('A brand new 8 GIGA iPod');
$ipod->setPrice(299.0);
$this->allProducts[] = $ipod;
}
public static function getProductsByCategory($category_id)
{
$db = Database::getDB();
$category = CategoryDB::getCategory($category_id);
$query = 'SELECT * FROM products
WHERE products.categoryID = :category_id
ORDER BY productID';
$statement = $db->prepare($query);
$statement->bindValue(":category_id", $category_id);
$statement->execute();
$rows = $statement->fetchAll();
$statement->closeCursor();
foreach ($rows as $row) {
$product = new Product($category, $row['productCode'], $row['productName'], $row['listPrice']);
$product->setId($row['productID']);
$products[] = $product;
}
return $products;
}
<?php
require_once __DIR__ . '/../common/autoload_cms.php';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$entity = new Product();
$entity->setId($_GET['id'])->setUserId($_POST['user_id'])->setName($_POST['name'])->setPrice($_POST['price'])->setQuantity($_POST['quantity'])->setDateAdded(date('Y-m-d H:i:s'))->saveImage($_FILES['image']);
$productCollection = new ProductCollection();
$productCollection->save($entity);
header('Location: product_list.php');
exit;
}
$productCollection = new ProductCollection();
$product = $productCollection->one(array('id' => $_GET['id']));
$userCollection = new UserCollection();
$users = $userCollection->all();
require_once 'include/header.php';
?>
<div class="container">
<a href="product_image_list.php?product_id=<?php
echo $product->getId();
?>
" class="btn btn-success">Gallery</a>
<br><br>
<form method="post" action="" enctype="multipart/form-data">
<div class="form-group">
<label for="user">User:</label>
<select name="user_id" id="user" class="form-control">
<?php
foreach ($users as $user) {
