<?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);

$slug=$_REQUEST["state"];
$query="SELECT t1.id,t1.type, t1.name, t1.state_id, t1.city_id, t1.pincode, t1.address, t1.longitude,t1.latitude, t1.important_emails, t1.important_phones, t1.official_website_link, t1.online_apply_link, t1.online_fee_link, t1.result_link, t1.addmission_guidelines,t1.addmission_details,t2.state_slug,t2.state_name,t3.city FROM sp_kvs_navodya as t1 
LEFT JOIN sp_states as t2 on t1.state_id=t2.state_id
LEFT JOIN sp_city as t3 on t3.city_id=t1.city_id WHERE t1.type='nvs' AND t2.state_slug='$slug'  ORDER BY t1.added_date DESC";
$sql=$db->prepare($query);
$sql->execute();

while($row=$sql->fetch()){
$nvs_id=$row['id'];
$nvs_name=$row['name'];
$state_slug=$row['state_slug'];
$address=$row['address'];
$pincode=$row['pincode'];
$longitude=$row['longitude'];
$latitude=$row['latitude'];
$important_emails=$row['important_emails'];
$important_phones=$row['important_phones'];
$official_website_link=$row['official_website_link'];
$online_apply_link=$row['online_apply_link'];
$online_fee_link=$row['online_fee_link'];
$result_link=$row['result_link'];
$state_name=$row['state_name'];
$city=$row['city'];


$array=array("nvs_id"=>$nvs_id,"nvs_name"=>$nvs_name,"address"=>$address,"important_emails"=>$important_emails,"state_name"=>$state_name,"city"=>$city,"pincode"=>$pincode,"longitude"=>$longitude,"latitude"=>$latitude,"important_phones"=>$important_phones,"official_website_link"=>$official_website_link,"online_apply_link"=>$online_apply_link,"online_fee_link"=>$online_fee_link,"result_link"=>$result_link);
$mainsub[]=$array;
}
//print_r($mainsub);

echo json_encode($mainsub);

?>