beginTransaction(); // 1. Validate stock for all products in the cart foreach ($_SESSION['cart'] as $product_id => $quantity) { // SELECT FOR UPDATE locks the rows to prevent race conditions during checkout $stmt = $pdo->prepare("SELECT * FROM products WHERE id = ? FOR UPDATE"); $stmt->execute([$product_id]); $product = $stmt->fetch(); if (!$product) { throw new Exception("ไม่พบรหัสสินค้า: " . $product_id); } if ($product['stock'] < $quantity) { throw new Exception("สินค้า '" . $product['name'] . " (" . $product['size'] . ")' มีสต็อกไม่เพียงพอ (คงเหลือ " . $product['stock'] . " ชิ้น)"); } // Calculate price and accumulate $subtotal = $product['price'] * $quantity; $total_price += $subtotal; $order_summary[] = [ 'id' => $product_id, 'name' => $product['name'], 'size' => $product['size'], 'price' => $product['price'], 'quantity' => $quantity, 'subtotal' => $subtotal ]; } // 2. Insert into orders table $stmt = $pdo->prepare("INSERT INTO orders (customer_name, phone, address, total_price, payment_status) VALUES (?, ?, ?, ?, 'pending')"); $stmt->execute([$customer_name, $phone, $address, $total_price]); $order_id = $pdo->lastInsertId(); // 3. Insert into order_details and update product stock $stmtDetail = $pdo->prepare("INSERT INTO order_details (order_id, product_id, quantity) VALUES (?, ?, ?)"); $stmtUpdateStock = $pdo->prepare("UPDATE products SET stock = stock - ? WHERE id = ?"); foreach ($order_summary as $item) { // Insert details $stmtDetail->execute([$order_id, $item['id'], $item['quantity']]); // Deduct stock $stmtUpdateStock->execute([$item['quantity'], $item['id']]); } // Commit all changes $pdo->commit(); // Clear cart session since order is placed successfully $_SESSION['cart'] = []; } catch (Exception $e) { // Rollback the transaction on error $pdo->rollBack(); $error_message = $e->getMessage(); } // Render Order Result ?> ผลการสั่งซื้อ - Minimalist Closet

Order Confirmed!

สั่งซื้อเสร็จสิ้น สต็อกถูกอัปเดตเรียบร้อยแล้ว

รหัสสั่งซื้อ: #

ชื่อลูกค้า:

เบอร์โทรศัพท์:

ที่อยู่จัดส่ง:

ยอดชำระเงินรวม: ฿

กลับสู่หน้าหลัก

Order Failed

ไม่สามารถทำการสั่งซื้อได้

กลับไปแก้ไขตะกร้า กลับสู่หน้าหลัก