ambil_detail_pesanan.php

<?php
header('Content-Type: application/json');
$conn = new mysqli("localhost", "root", "", "ngantriless");

if ($conn->connect_error) {
    echo json_encode(["status" => "error", "message" => "Koneksi gagal"]);
    exit;
}

$id = $_GET['id'] ?? 0;
if (!$id) {
    echo json_encode(["status" => "error", "message" => "ID tidak valid"]);
    exit;
}

// Ambil pesanan utama
$qPesanan = $conn->prepare("SELECT total FROM pesanan WHERE id = ?");
$qPesanan->bind_param("i", $id);
$qPesanan->execute();
$pesanan = $qPesanan->get_result()->fetch_assoc();

// Ambil detail pesanan
$qDetail = $conn->prepare("SELECT nama_menu, harga, quantity FROM pesanan_detail WHERE id_pesanan = ?");
$qDetail->bind_param("i", $id);
$qDetail->execute();
$items = $qDetail->get_result()->fetch_all(MYSQLI_ASSOC);

echo json_encode([
    "status" => "success",
    "total" => $pesanan['total'],
    "items" => $items
]);
$conn->close();
?>