TIF_NGANJUK_E41212020/admin/ajax/cek_pesanan.php

22 lines
647 B
PHP

<?php
include $_SERVER['DOCUMENT_ROOT'] . "/config.php";
$query = mysqli_query($conn, "SELECT id_order, status_order, tanggal_order
FROM orders
WHERE status_order IN ('Menunggu Pembayaran', 'Pembayaran Sukses')
ORDER BY tanggal_order DESC");
$data = [];
while ($row = mysqli_fetch_assoc($query)) {
$data[] = $row;
}
$response = [
'total' => count($data),
'id_order' => !empty($data) ? $data[0]['id_order'] : null, // Ambil ID order terbaru saja
'data' => $data // Tetap kirim semua data kalau butuh
];
echo json_encode($response);
?>