p.php

<?php

$host = mysqli_connect("localhost", "root", "", "ball");

$query = mysqli_query($host, "SELECT * FROM tb_booking");
$queryLapangan = mysqli_query($host, "SELECT * from tb_lapangan");


//Ambil data pokoknya dah :v

$lapangan = [];
while($getLapangan = $queryLapangan->fetch_assoc()){
    $lapangan[] = $getLapangan;
}


//Ini sama ambil data :v
$booking = [];
while($getBooking = $query->fetch_assoc()){
    $booking[] = $getBooking;
}


//Butuh json? 
$finalJson = [];

//Filter setiap orderan
foreach($booking as $book){

    $lapanganDipesan = [];
    $lapanganTersedia = [];

    //loop setiap lapangan
    foreach($lapangan as $lapang){

        //Cek kalau memang dipesan
        if($book["id_lapangan"] == $lapang["id_lapangan"]){
            array_push($lapanganDipesan, $lapang["id_lapangan"]);
        }
        
        //Kalau ga ada ya gitu dah :v
        else{
            array_push($lapanganTersedia, $lapang["id_lapangan"]);
        }
    }
    array_push($finalJson, ["lapangan_dipesan" => $lapanganDipesan, "lapangan_tersedia" => $lapanganTersedia]);
}



//Wrap it up together
header('Content-Type: application/json');
echo json_encode($finalJson);


?>