<?php include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
	$usersList_array =array();
    $row_array = array();
     $user_id = $_POST['user_id'];
	$sql="select * from user_profile where user_profile.id ='$user_id'";
    $result = mysqli_query($conn, $sql);
     $json_response = array();
	if(mysqli_num_rows($result) > 0) {
	while($row = mysqli_fetch_assoc($result)) {
    $country=$row['country'];
    $state=$row['state'];
    $city=$row['city'];
    $sql_country = mysqli_query($conn,"select * from countries where id = '$country'");
    $row_country = mysqli_fetch_array($sql_country);
    $sql_state = mysqli_query($conn,"select * from states where id = '$state'");
    $row_state = mysqli_fetch_array($sql_state);
    $sql_city = mysqli_query($conn,"select * from cities where id = '$city'");
    $row_city = mysqli_fetch_array($sql_city);
    $shp_country=$row['shp_country'];
    $shp_state=$row['shp_state'];
    $shp_city=$row['shp_city'];
    $sql_shcountry = mysqli_query($conn,"select * from countries where id = '$shp_country'");
    $row_shcountry = mysqli_fetch_array($sql_shcountry);
    $sql_shstate = mysqli_query($conn,"select * from states where id = '$shp_state'");
    $row_shstate = mysqli_fetch_array($sql_shstate);
    $sql_shcity = mysqli_query($conn,"select * from cities where id = '$shp_city'");
    $row_shcity = mysqli_fetch_array($sql_shcity);
    $row_array['fname'] = $row['fname'];        
    $row_array['email'] = $row['email'];        
    $row_array['mob_no'] = $row['mob_no'];        
    $row_array['address'] = $row['addr'];        
    $row_array['landmark'] = $row['landmark'];        
    $row_array['bpincode'] = $row['pincode'];        
    $row_array['image'] = $row['image'];      
    $row_array['profile_img'] = $row['prof_img'];     
    $row_array['bcountry'] = $row_country['name'];        
    $row_array['bstate'] = $row_state['name'];        
    $row_array['bcity'] = $row_city['name'];  
    $row_array['sh_name'] = $row['sh_name'];        
    $row_array['sh_phone'] = $row['sh_phone'];        
    $row_array['shp_addr'] = $row['shp_addr'];        
    $row_array['sh_landmark'] = $row['sh_landmark'];        
    $row_array['shp_pincode'] = $row['shp_pincode'];        
    $row_array['shp_country'] = $row_shcountry['name'];        
    $row_array['shp_state'] = $row_shstate['name'];        
    $row_array['shp_city'] = $row_shcity['name'];        
    $row_array['id'] = $row['id'];
    $row_array['notes'] = array();
      array_push($usersList_array, $row_array);
	 }
	} 
	echo json_encode($usersList_array, JSON_PRETTY_PRINT);
	//echo json_encode($response);
	mysqli_close($conn);
}