:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/kreative_crm/quatation/**
:: Editing File: get_farmer_details.php
<?php include("db.php"); // Your database connection if (isset($_POST['farmer_id'])) { $farmer_id = mysqli_real_escape_string($conn, $_POST['farmer_id']); /*$query = "SELECT contact, village, state FROM farmers WHERE id = '$farmer_id'";*/ $query = "SELECT phone, village, state FROM party WHERE id = '$farmer_id'"; $result = mysqli_query($conn, $query); if ($row = mysqli_fetch_assoc($result)) { // Return data as JSON header('Content-Type: application/json'); echo json_encode($row); } else { // Handle case where farmer is not found echo json_encode(['phone' => '', 'village' => '', 'state' => '']); } } ?>