.

%PDF- %GIF98; %PNG; . Cyber Programmer
Server : Apache
System : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64
User : ndkhermy ( 1200)
PHP Version : 8.5.12
Disable Function : NONE
Directory : /home1/ndkhermy/public_html/website_6ca89795/user/
Upload File :
Current File : /home1/ndkhermy/public_html/website_6ca89795/user/ordershow.php
<?php
session_start(); 
include('header.php'); 

include('../dbcon.php');

if (!isset($_SESSION['username']) || !isset($_SESSION['id'])) {
    header('Location: ../login.php'); 
    exit();
}

$username = $_SESSION['username'];
$user_id = $_SESSION['id']; 
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Orders</title>
    <link rel="stylesheet" href="../assets/vendor/css/bootstrap.css">
</head>
<body>
<div class="container mt-5">
    <h2 class="mb-4">Orders</h2>

    <table class="table table-bordered">
        <thead>
            <tr>
                <th>No.</th>
                <th>Order ID</th>
                <th>Product ID</th>
                <th>Quantity</th>
                <th>Price</th>
                <th>Username</th>
                <th>Total Amount</th>
                <th>Payment Type</th>
                <th>Order Status</th>
                <th>Created Date</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $query = "
                SELECT 
                    o.id AS order_id, 
                    o.user_id, 
                    oi.product_id, 
                    oi.quantity, 
                    oi.price, 
                    o.total_amount, 
                    o.payment_type, 
                    o.order_status, 
                    o.created_at
                FROM orders o
                JOIN order_items oi ON o.id = oi.order_id
                WHERE o.user_id = ?
            ";
            if ($stmt = $conn->prepare($query)) {
                $stmt->bind_param("i", $user_id);
                $stmt->execute();
                $result = $stmt->get_result();
                if ($result->num_rows > 0) {
                    $count = 0;
                    while ($data = $result->fetch_assoc()) {
                        $count++;
                        ?>
                        <tr>
                            <td><?php echo $count; ?></td>
                            <td><?php echo htmlspecialchars($data['order_id']); ?></td>
                            <td><?php echo htmlspecialchars($data['product_id']); ?></td>
                            <td><?php echo htmlspecialchars($data['quantity']); ?></td>
                            <td><?php echo number_format($data['price'], 2); ?></td>
                            <td><?php echo htmlspecialchars($username); ?></td>
                            <td><?php echo number_format($data['total_amount'], 2); ?></td>
                            <td><?php echo htmlspecialchars($data['payment_type']); ?></td>
                            <td>
<?php 
$status = $data['order_status'];

if ($status == 'Pending') {
    echo '<span class="badge bg-warning">Pending</span>';
} 
elseif ($status == 'Processing') {
    echo '<span class="badge bg-info">Processing</span>';
} 
elseif ($status == 'Shipped') {
    echo '<span class="badge bg-primary">Shipped</span>';
} 
elseif ($status == 'Delivered') {
    echo '<span class="badge bg-success">Completed</span>';
} 
elseif ($status == 'Cancelled') {
    echo '<span class="badge bg-danger">Cancelled</span>';
} 
else {
    echo '<span class="badge bg-secondary">'.$status.'</span>';
}
?>
</td>
                            <td><?php echo htmlspecialchars($data['created_at']); ?></td>
                        </tr>
                        <?php
                    }
                } else {
                    echo "<tr><td colspan='10' class='text-center'>No orders found for this user.</td></tr>";
                }
                $stmt->close();
            } else {
                echo "<tr><td colspan='10' class='text-center'>Error in preparing query: " . htmlspecialchars($conn->error) . "</td></tr>";
            }
            ?>
        </tbody>
    </table>
</div>

<!-- Core JS -->
<script src="../assets/vendor/libs/jquery/jquery.js"></script>
<script src="../assets/vendor/libs/popper/popper.js"></script>
<script src="../assets/vendor/js/bootstrap.js"></script>
<script src="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>
<script src="../assets/vendor/js/menu.js"></script>
<script src="../assets/js/main.js"></script>

</body>
</html>
VaKeR 2022