<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
include "config.php";
/* ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL); */

$state=$_REQUEST['state'];
$city=$_REQUEST['city'];

if($state!=''){
$query="select k.type,k.name,s.state_name,c.city,k.pincode, k.address, k.longitude, k.latitude, k.important_emails, k.important_phones, k.official_website_link,k.addmission_guidelines,k.addmission_details, k.online_apply_link,k.online_fee_link,k.result_link from sp_kvs_navodya as k
left join sp_states as s on s.state_id=k.state_id
left join sp_city as c on c.city_id=k.city_id where k.type='KVS' and s.state_name='$state' order by k.added_date DESC";
}
else if($city!=''){
$query="select k.type,k.name,s.state_name,c.city,k.pincode, k.address, k.longitude, k.latitude, k.important_emails, k.important_phones, k.official_website_link,k.addmission_guidelines,k.addmission_details, k.online_apply_link,k.online_fee_link,k.result_link from sp_kvs_navodya as k
left join sp_states as s on s.state_id=k.state_id
left join sp_city as c on c.city_id=k.city_id where k.type='KVS' and c.city='$city' order by k.added_date DESC";	
}
else{
$query="select k.type,k.name,s.state_name,c.city,k.pincode, k.address, k.longitude, k.latitude, k.important_emails, k.important_phones, k.official_website_link,k.addmission_guidelines,k.addmission_details, k.online_apply_link,k.online_fee_link,k.result_link from sp_kvs_navodya as k
left join sp_states as s on s.state_id=k.state_id
left join sp_city as c on c.city_id=k.city_id where k.type='KVS' order by k.added_date DESC";	
}
$sql=$db->prepare($query);
$sql->execute();
$mainsub2=array();
while($row=$sql->fetch()){
$name=$row['name'];
$state=$row['state_name'];
$city=$row['city'];
$pin=$row['pincode'];
$add=$row['address'];
$lon=$row['longitude'];
$lat=$row['latitude'];
$imp_email=$row['important_emails'];
$imp_phone=$row['important_phones'];
$web=$row['official_website_link'];
$guide=$row['addmission_guidelines'];
$details=$row['addmission_details'];
$on_applylink=$row['online_apply_link'];
$on_feelink=$row['online_fee_link'];	
$res_link=$row['result_link'];
$array=array("name"=>$name,"state"=>$state,"city"=>$city,"pincode"=>$pin,"address"=>$add,"longitude"=>$lon,"latitude"=>$lat,"important_email"=>$imp_email,"important_phone"=>$imp_phone,"website_link"=>$web,"addmission_guidelines"=>$guide,"addmission_details"=>$details,"apply_link"=>$on_applylink,"fee_link"=>$on_feelink,"result_link"=>$res_link);
$mainsub2[]=$array;
}

 
echo json_encode($mainsub2);

?>