function saveOrder($bucket, $price, $user_id, $delivery_type, $address) { global $db; $orderId = $bucket['orderId']; $order = serialize($bucket); $status = 'new order'; $time_ordered = date("H:i:s d-m-Y", time()); try { $query = $db->prepare("INSERT INTO orders (`order_id`, `user_id`, `order`, `price`, `delivery_type`, `address`, `status`, `time_ordered`) VALUES (:order_id, :user_id, :order, :price, :delivery_type, :address, :status, :time_ordered)"); $query->execute(array(':order_id' => $orderId, ':user_id' => $user_id, ':order' => $order, ':price' => $price, ':delivery_type' => $delivery_type, 'address' => $address, 'status' => $status, ':time_ordered' => $time_ordered)); $email = $_SESSION['email']; orderMailer($email, $orderId, $bucket, $price, $delivery_type, $address); //шлем письмо с деталями заказа deleteAllBucket(); } catch (PDOException $e) { die($e->getMessage()); } }
<?php require "../classes/Lib.php"; require "../classes/DB.php"; require_once "session.inc.php"; //корзина if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (isset($_POST['id'])) { $id = clearInt($_POST['id']); add2Bucket($id, $q = 1); } elseif (isset($_POST['deleteAllBucket'])) { //если нажата кнопка "очистить корзину" deleteAllBucket(); // }elseif(isset($_POST['delItem2Bucket'])){//если нажат крестик для удаления одного товара - не работает // echo $_POST['delId']; // $delId = clearInt($_POST['delId']); // arr($GLOBALS); // delItem2Bucket($delId); } elseif (isset($_POST['checkout'])) { //если нажата кнопка "заказать" header("Location: ../bucket.php"); exit; } elseif (isset($_POST['countBucket'])) { //если нажата кнопка "пересчитать" $updateQuantity = $_POST['q']; updateBucket($updateQuantity); } elseif (isset($_POST['checkout_final'])) { //если нажата кнопка оформить заказ на странице корзина $price = clearInt($_POST['price']); if ($_POST['delivery'] === 'on' and !empty($_POST['address'])) { $delivery_type = "Курьерская доставка";