<?php

header("Content-type:application/json");

require_once('../dbConnect.php');

$query = mysqli_query($conn, "SELECT * FROM `payment_details`");

$response["payments"] = array();

while( $row = mysqli_fetch_assoc($query)){
 $payments = array();
    $payments ["number_plate"] = $row["number_plate"];
   $payments ["fare"] = $row["fare"];
    $payments ["courier"] = $row["courier"];
    $payments ["amount"] = $row["amount"];
    $payments ["name_of_passenger"] = $row["name_of_passenger"];
    $payments ["phone_no_of_passenger"] = $row["phone_no_of_passenger"];
    $payments ["id_no_of_passenger"] = $row["id_no_of_passenger"];
    $payments ["destination"] = $row["destination"];

array_push($response["payments"], $payments);
}

echo json_encode($response);

?>