insert.php

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

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

// Get data from AngularJS
$data = json_decode(file_get_contents("php://input"));

// Extract values safely
$turf_name = mysqli_real_escape_string($con, $data->turf_name);
$location = mysqli_real_escape_string($con, $data->location);
$price = mysqli_real_escape_string($con, $data->price);
$availability = mysqli_real_escape_string($con, $data->availability);
$btnname = $data->btnname;
$id = isset($data->id) ? $data->id : 0;

// Insert or Update
if ($btnname == "Add") {
    $query = "INSERT INTO turf (turf_name, location, price, availability) 
              VALUES ('$turf_name', '$location', '$price', '$availability')";
    
    if (mysqli_query($con, $query)) {
        echo "✅ Turf Added Successfully!";
    } else {
        echo "❌ Failed to Add Turf.";
    }
} 
elseif ($btnname == "Update") {
    $query = "UPDATE turf 
              SET turf_name='$turf_name', location='$location', price='$price', availability='$availability' 
              WHERE id='$id'";
    
    if (mysqli_query($con, $query)) {
        echo "✅ Turf Updated Successfully!";
    } else {
        echo "❌ Failed to Update Turf.";
    }
}

// Close connection
mysqli_close($con);
?>