File manager - Edit - /home/webapp69.cm.in.th/u69319090024/Shop24/success.php
Back
<?php require_once __DIR__ . '/header.php'; // ------------------------------------------------------------ // ตรวจสอบพารามิเตอร์ order_id // ------------------------------------------------------------ $order_id = filter_input(INPUT_GET, 'order_id', FILTER_VALIDATE_INT); if (!$order_id) { header('Location: index.php'); exit; } // ------------------------------------------------------------ // ดึงข้อมูลคำสั่งซื้อหลักจากฐานข้อมูลด้วย PDO Prepared Statement // ------------------------------------------------------------ $stmt_order = $pdo->prepare(" SELECT o.*, u.fullname, u.email FROM orders o JOIN users u ON o.user_id = u.id WHERE o.id = ? "); $stmt_order->execute([$order_id]); $order = $stmt_order->fetch(); if (!$order) { echo '<div class="alert alert-danger my-5">ไม่พบข้อมูลคำสั่งซื้อที่ระบุ</div>'; require_once __DIR__ . '/footer.php'; exit; } // ------------------------------------------------------------ // ดึงรายการสินค้าในคำสั่งซื้อ (order_items) // ------------------------------------------------------------ $stmt_items = $pdo->prepare(" SELECT oi.*, p.name AS product_name, p.image FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id = ? "); $stmt_items->execute([$order_id]); $order_items = $stmt_items->fetchAll(); ?> <div class="row justify-content-center py-4"> <div class="col-lg-8"> <!-- Success Banner Card --> <div class="card border-0 shadow-sm rounded-4 text-center overflow-hidden mb-4"> <div class="bg-success text-white p-4 p-md-5 position-relative"> <div class="mb-3"> <i class="fa-solid fa-circle-check display-1"></i> </div> <h2 class="fw-bold mb-2">ขอบคุณสำหรับการสั่งซื้อ!</h2> <p class="lead mb-0 opacity-90">ทำรายการสั่งซื้อเสร็จสมบูรณ์เรียบร้อยแล้ว</p> </div> <div class="card-body p-4 p-md-5"> <div class="row g-3 text-start bg-light p-3 rounded-3 border mb-4"> <div class="col-6 col-sm-3"> <span class="text-muted small d-block">หมายเลขคำสั่งซื้อ</span> <span class="fw-bold text-primary fs-6">#ORDER-<?= str_pad($order['id'], 5, '0', STR_PAD_LEFT) ?></span> </div> <div class="col-6 col-sm-3"> <span class="text-muted small d-block">วันที่สั่งซื้อ</span> <span class="fw-semibold text-dark"><?= date('d/m/Y H:i', strtotime($order['created_at'])) ?> น.</span> </div> <div class="col-6 col-sm-3"> <span class="text-muted small d-block">สถานะคำสั่งซื้อ</span> <span class="badge bg-success rounded-pill px-3 py-1 fw-medium"><i class="fa-solid fa-check me-1"></i>สำเร็จ (Completed)</span> </div> <div class="col-6 col-sm-3"> <span class="text-muted small d-block">ผู้สั่งซื้อ</span> <span class="fw-semibold text-dark"><?= htmlspecialchars($order['fullname']) ?></span> </div> </div> <h5 class="fw-bold text-start mb-3"><i class="fa-solid fa-receipt text-primary me-2"></i>สรุปรายละเอียดสินค้า</h5> <div class="table-responsive mb-4"> <table class="table align-middle text-start"> <thead class="table-light"> <tr> <th>รายการสินค้า</th> <th class="text-center">ราคาต่อชิ้น</th> <th class="text-center">จำนวน</th> <th class="text-end">ราคารวม</th> </tr> </thead> <tbody> <?php foreach ($order_items as $item): ?> <tr> <td> <div class="d-flex align-items-center gap-3"> <?php $img = get_product_image_url($item['image']); ?> <img src="<?= htmlspecialchars($img) ?>" class="rounded-3 border" style="width: 48px; height: 48px; object-fit: cover;" alt=""> <span class="fw-semibold text-dark"><?= htmlspecialchars($item['product_name']) ?></span> </div> </td> <td class="text-center text-muted"><?= format_price($item['price']) ?></td> <td class="text-center fw-bold"><?= $item['quantity'] ?></td> <td class="text-end fw-bold text-primary"><?= format_price($item['price'] * $item['quantity']) ?></td> </tr> <?php endforeach; ?> </tbody> <tfoot> <tr> <th colspan="3" class="text-end pt-3 fs-5">ยอดรวมสุทธิทั้งสิ้น:</th> <th class="text-end pt-3 fs-4 text-primary fw-bold"><?= format_price($order['total_price']) ?></th> </tr> </tfoot> </table> </div> <div class="d-flex justify-content-center gap-3"> <a href="index.php" class="btn btn-primary-custom rounded-pill px-4 py-2 fw-semibold"> <i class="fa-solid fa-store me-2"></i>กลับไปเลือกซื้อสินค้าต่อ </a> </div> </div> </div> </div> </div> <?php require_once __DIR__ . '/footer.php'; ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.23 |
proxy
|
phpinfo
|
Settings