prepare("
SELECT o.*, u.name, u.email, u.phone
FROM orders o
JOIN users u ON o.user_id = u.id
WHERE o.id = ? AND u.email = ?
");
$stmt->execute([$order_id, $email]);
$order = $stmt->fetch(PDO::FETCH_ASSOC);
if ($order) {
// Fetch Items
$iStmt = $pdo->prepare("
SELECT p.name, v.name as variant
FROM order_items oi
JOIN products p ON oi.product_id = p.id
JOIN product_variants v ON oi.variant_id = v.id
WHERE oi.order_id = ?
");
$iStmt->execute([$order_id]);
$items = $iStmt->fetchAll(PDO::FETCH_ASSOC);
} else {
$error = "Order not found or email does not match.";
}
}
?>
Items
Access Details / License Key