Urgent help needed! Transaction process after shopping cart

@mirainc — the cart should be moved to an order record only for that shopper, not emptied site-wide. @WillGresham was right to flag a shared cart; @buddylee17 correctly asked how the cart is stored. A reliable pattern is: create an order row, copy only that shopper's cart rows into order_items, then remove only those cart rows inside a single database transaction so the move is atomic.

Typical schema (examples): carts(id, cart_key, product_id, qty, price); orders(id, user_id, total, created_at); order_items(id, order_id, product_id, qty, price). Checkout steps: start DB transaction, insert an orders row, copy cart rows into order_items with an INSERT ... SELECT ... FROM carts WHERE cart_key = ?, delete those carts rows, then commit. Use prepared statements, check inventory/price consistency before commit, and rollback on any error to avoid partial state.

A compact PDO example showing the pattern:

<?php
$db = new PDO($dsn,$user,$pass,[PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION]);
$db->beginTransaction();

$stmt = $db->prepare("INSERT INTO orders (user_id,total,created_at) VALUES (:uid,:total,NOW())");
$stmt->execute([':uid'=>$userId,':total'=>$total]);
$orderId = $db->lastInsertId();

$ins = $db->prepare("
  INSERT INTO order_items (order_id,product_id,qty,price)
  SELECT :oid,product_id,qty,price FROM carts WHERE cart_key = :key
");
$ins->execute([':oid'=>$orderId,':key'=>$cartKey]);

$del = $db->prepare("DELETE FROM carts WHERE cart_key = :key");
$del->execute([':key'=>$cartKey]);

$db->commit();
?>

Notes: store the cart key securely (cookie or tied to logged-in user), validate prices and stock just before commit (or lock rows), and handle multi-tab/parallel checkout by using locks or checking affected row counts. In Dreamweaver you place this PHP on the checkout handler page and test on a PHP-enabled server; prefer PDO or mysqli over deprecated interfaces.