public function addProduct(ProductBindingModel $p)
{
$conn = DB::connect();
$insertProductSql = 'INSERT INTO products(name, price, added_on, description, quantity, `condition`, picture)
VALUES(
"' . $p->getName() . '",
"' . $p->getPrice() . '",
"' . time() . '",
"' . $p->getDescription() . '",
"' . $p->getQuantity() . '",
"' . $p->getCondition() . '",
"' . $p->getPicture() . '"
)';
if (!$conn->query($insertProductSql)) {
throw new \Exception("Database error");
}
$getProductId = $conn->query('SELECT id FROM products WHERE name="' . $p->getName() . '" ORDER BY added_on DESC LIMIT 1')->fetch();
$addCategorySql = 'INSERT INTO category_product(category_id, product_id)
VALUES("' . $p->getCategory() . '", "' . $getProductId["id"] . '")';
if (!$conn->query($addCategorySql)) {
throw new \Exception("Database error");
}
View::$viewBag['successMessage'] = "Product successfully added";
}
