display.php

<?php
// Database connection
$con = mysqli_connect("localhost", "root", "423301", "mini");

// Check connection
if (!$con) {
    die("Connection failed: " . mysqli_connect_error());
}

// Fetch all turf records
$result = $con->query("SELECT * FROM turf ORDER BY id DESC");

// Prepare output
$output = "";
while ($rs = $result->fetch_array(MYSQLI_ASSOC)) {
    if ($output != "") {
        $output .= ",";
    }
    $output .= '{"id":"' . $rs["id"] . '",';
    $output .= '"turf_name":"' . $rs["turf_name"] . '",';
    $output .= '"location":"' . $rs["location"] . '",';
    $output .= '"price":"' . $rs["price"] . '",';
    $output .= '"availability":"' . $rs["availability"] . '"}';
}

$output = '{"records":[' . $output . ']}';

// Close connection
$con->close();

// Output JSON
echo ($output);
?>