<?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);
$max=10;
//$min=$_REQUEST['pageN'];
$min=isset($_GET['page']) ? $_GET['page'] : 1;
$count = ($min - 1) * $max;
//$count= $min * $limit;

$count1="select count(*) as total 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.display_order ASC";
$sql2=$db->prepare($count1);
$sql2->execute();
$row2=$sql2->fetch();
$countresult=$row2['total'];
$div= ceil($countresult / $max);
$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 limit $count,$max";
$sql=$db->prepare($query);
$sql->execute();
$mainsub2=array();
while($row=$sql->fetch()){
//$type=$row['type'];	

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

$mainsub[]=$array;
}
$array2=array("Total"=>$countresult,"no_of_page"=>$div,"cur_page"=>$min,"data"=>$mainsub);
$mainsub2[]=$array2;	
echo json_encode($mainsub2);

?>