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"; }