CREATE DATABASE order_system;

CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nama VARCHAR(255) NOT NULL,
    jumlah INT NOT NULL,
    status ENUM('Pending', 'Diproses', 'Selesai') DEFAULT 'Pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

<?php
// koneksi database
$conn = new mysqli("localhost", "root", "", "order_system");
if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error);
}
?>

<!-- Form Order (order.html) -->
<form action="process_order.php" method="POST">
    <input type="text" name="nama" placeholder="Nama" required>
    <input type="number" name="jumlah" placeholder="Jumlah" required>
    <button type="submit">Order</button>
</form>

<?php
// Simpan Order ke Database (process_order.php)
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $nama = $_POST['nama'];
    $jumlah = $_POST['jumlah'];
    $stmt = $conn->prepare("INSERT INTO orders (nama, jumlah) VALUES (?, ?)");
    $stmt->bind_param("si", $nama, $jumlah);
    if ($stmt->execute()) {
        echo "Order berhasil dibuat!";
    } else {
        echo "Error: " . $stmt->error;
    }
    $stmt->close();
}
?>

<?php
// Dashboard Admin (dashboard.php)
$result = $conn->query("SELECT * FROM orders");
echo "<table border='1'><tr><th>Nama</th><th>Jumlah</th><th>Status</th><th>Update</th></tr>";
while ($row = $result->fetch_assoc()) {
    echo "<tr>
        <td>{$row['nama']}</td>
        <td>{$row['jumlah']}</td>
        <td>{$row['status']}</td>
        <td>
            <a href='update_status.php?id={$row['id']}&status=Diproses'>Diproses</a> |
            <a href='update_status.php?id={$row['id']}&status=Selesai'>Selesai</a>
        </td>
    </tr>";
}
echo "</table>";
?>

<?php
// Update Status Order (update_status.php)
if (isset($_GET['id']) && isset($_GET['status'])) {
    $id = $_GET['id'];
    $status = $_GET['status'];
    $conn->query("UPDATE orders SET status='$status' WHERE id=$id");
    header("Location: dashboard.php");
}
?>