<?php
require_once 'db.php';

if (isset($_POST['name']) && isset($_POST['designation']) && isset($_POST['description'])) {

    // Extract data from the POST request
    $name = $_POST['name'];
    $designation = $_POST['designation'];
    $description = $_POST['description'];

    // SQL query to insert data into the 'vehicles' table
    $sql = "INSERT INTO testimonials (name, designation, description) 
            VALUES (
            '$name', 
            '$designation', 
            '$description')";

    if (mysqli_query($link, $sql)) {
        $response = [
            'error_flag' => 0,
            'message' => 'Testimonial Added Successfully!'
        ];
        echo json_encode($response);
    } else {
        $response = [
            'error_flag' => 1,
            'message' => 'Failed to add testimonial details.'
        ];
        echo json_encode($response);
    }
} else {
    $response = [
        'error_flag' => 1,
        'message' => 'Invalid request. Missing required parameters.'
    ];
    echo json_encode($response);
}