File Explorer

<?php include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
$usersList_array =array();   
$row_array = array();
$note_array = array(); 
$sts="Active";
if(is_numeric($_POST['type'])){
$type=intval($_POST['type']);   
$propertyfor=($_POST['property_for']);   
$sqlpt=mysqli_query($conn,"SELECT es_property.*,es_property_type.types FROM `es_property` join es_property_type on es_property.property_type=es_property_type.id WHERE  es_property.property_type='".$type."' and es_property.property_for='".$propertyfor."' and es_property.status='".$sts."'");
}elseif($_POST['area']){
 $area=$_POST['area'];   
 $propertyfor=$_POST['property_for'];   
 $sqlt="SELECT es_property.*,es_property_type.types FROM `es_property` join es_property_type on es_property.property_type=es_property_type.id join area on es_property.area_location=area.id WHERE  area.id='".$area."' and es_property.property_for='".$propertyfor."' and es_property.status='".$sts."'"; 
 $sqlpt=mysqli_query($conn,$sqlt);
}elseif($_POST['price']){
 $price=($_POST['price']);   
  $names_str = explode("-",$price);
  $prange1=$names_str[0];
  $prange2=$names_str[1];
 $sqlpt=mysqli_query($conn,"SELECT es_property.*,es_property_type.types FROM `es_property` join es_property_type on es_property.property_type=es_property_type.id WHERE (es_property.price >= ".$prange1." and es_property.price <= ".$prange2.") and es_property.property_for='".$propertyfor."' and es_property.status='".$sts."'"); 
}  
$json_response = array();
if(mysqli_num_rows($sqlpt) > 0) {
while($row = mysqli_fetch_array($sqlpt)) { 
$uid=$row['property_added'];  
$resus=mysqli_fetch_array(mysqli_query($conn,"select * from es_property_user where id=".$uid));
$sql_area=mysqli_fetch_array(mysqli_query($conn,"SELECT * from area where id=".$row['area_location']));
$row_array['created_date'] = $row['created_now'];        
$row_array['property_name'] = $row['property_name'];        
$row_array['room'] = $row['room'];        
$row_array['bathrooms'] = $row['bathrooms'];        
$row_array['property_status'] = $row['property_status'];        
$row_array['garages'] = $row['garages'];        
$row_array['year_built'] = $row['year_built'];        
$row_array['property_id'] = $row['property_id'];        
$row_array['city'] = $row['city'];        
$row_array['state'] = $row['state'];        
$row_array['area'] = $row['area'];   
$row_array['area_in'] = $row['area_in'];  
$row_array['price'] = $row['price'];              
$row_array['id'] = $row['id'];
$row_array['area_name'] = $sql_area['area_name'];
$row_array['personal_type'] = $resus['personal_type'];
$row_array['profile_img'] = $resus['profile_img'];
$row_array['name'] = $resus['name'];
$row_array['mobile_no'] = $resus['mobile_no'];
$row_array['desp'] = $row['desp'];
$row_array['floor_plan'] = $row['floor_plan'];
$row_array['furnished_status'] = $row['furnished_status'];
$row_array['property_for'] = $row['property_for'];
$row_array['floor_no'] = $row['floor_no'];
$row_array['address'] = $row['address'];

$row_array['notes'] = array();
$id = $row['id'];
$sql_prd=mysqli_query($conn,"select * from es_property_image where property_id=".$id);
while($rows = mysqli_fetch_assoc($sql_prd)){
$note_array['id'] = $rows['id'];
$note_array['images'] = $rows['images'];
array_push($row_array['notes'],$note_array);
}
array_push($usersList_array, $row_array);

}
//array_push($usersList_array, $user_array);

}
echo json_encode($usersList_array, JSON_PRETTY_PRINT);
//echo json_encode($response);
mysqli_close($conn);
} ?>

Editing File: menu-property-search.php