<?php 
include "../config.php";
if(isset($_POST['search'])){
    $search = $_POST['search'];
    $query = "SELECT * FROM vendor_master WHERE district like'%".$search."%' GROUP BY district";
    $result = mysqli_query($conn,$query);
    
    while($row = mysqli_fetch_array($result) ){
        $response[] = array("value"=>$row['district'],"label"=>$row['district']);
    }

    echo json_encode($response);
}

exit;


