public static function setOrder(Order $order) { $query = "INSERT INTO commandes (prix, id_user)\n\t\t\tVALUES ('" . $order->getPrice() . "','" . $order->getIdUser() . "')"; DBOperation::exec($query); $lastId = DBOperation::getLastId(); foreach ($_SESSION["cart"] as $product) { $query = "INSERT INTO produits_commandes (id_produit, id_commande, quantity)\n\t\t\t\tVALUES ('" . $product->getId() . "','" . $lastId . "','" . $product->getQuantity() . "')"; DBOperation::exec($query); } }
public static function addProduct($name, $description, $price) { $query = "INSERT INTO produits (nom, description, prix)\n\t\t\tVALUES ('" . $name . "', '" . $description . "', '" . $price . "')"; DBOperation::exec($query); $lastId = DBOperation::getLastId(); $directory = ROOT . "img/"; $file = basename($_FILES['link']['name']); $extension = ".jpg"; if (strrchr($_FILES['link']['name'], '.') == $extension) { if (!move_uploaded_file($_FILES['link']['tmp_name'], $directory . $file)) { echo 'Failed...'; } } $query = "INSERT INTO images (link, id_produit)\n\t\t\tVALUES ('" . $_FILES['link']['name'] . "', '" . $lastId . "')"; DBOperation::exec($query); }
public static function save($aProducts, User $oUser) { if (count($aProducts) === 0) { return false; } $dDate = date('Y-m-d H:i:s'); $fTotal = self::getTotal(); // create order $sQuery = "insert into orders(user_email,date,total) values('{$oUser->getEmail()}','{$dDate}',{$fTotal})"; if (!DBOperation::exec($sQuery)) { return false; } $iOrderId = DBOperation::getLastId(); foreach ($aProducts as $oCartProduct) { $sQuery = "insert into order_product(order_id,product_id,quantity) values({$iOrderId},\n {$oCartProduct->getId()},{$oCartProduct->getQuantity()})"; if (!DBOperation::exec($sQuery)) { return false; } } return true; }
public static function create(Product $oProduct) { $sName = addslashes($oProduct->getName()); $sDescription = addslashes($oProduct->getDescription()); $sImage = addslashes($oProduct->getImage()); $fPrice = floatval($oProduct->getPrice()); $sQuery = 'insert into product(name,description,image,price) values('; $sQuery .= "'{$sName}','{$sDescription}','{$sImage}','{$fPrice}'"; $sQuery .= ')'; $bSuccess = DBOperation::exec($sQuery); if (!$bSuccess) { return null; } // get last id $iProductId = DBOperation::getLastId(); // insert categories $aCategories = $oProduct->getCategories(); if (count($aCategories) > 0) { foreach ($aCategories as $oCategory) { $sQuery = 'insert into product_category(product_id,category_id) values('; $sQuery .= "'{$iProductId}','{$oCategory->getId()}'"; $sQuery .= ')'; DBOperation::exec($sQuery); } } return $iProductId; }