public static 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($category, $row['productCode'], $row['productName'], $row['listPrice']);
$product->setID($row['productID']);
return $product;
}
public static function getProduct($product_id)
{
$db = Database::getDB();
$query = 'SELECT * FROM products
WHERE productID = :product_id';
$statement = $db->prepare($query);
$statement->bindValue(":product_id", $product_id);
$statement->execute();
$row = $statement->fetch();
$statement->closeCursor();
$category = CategoryDB::getCategory($row['categoryID']);
$product = new Product($category, $row['productCode'], $row['productName'], $row['listPrice']);
$product->setID($row['productID']);
return $product;
}
