1#@!#!123s

��JFIF�� 1#@!#!123s

: / home / pattklvg / public_html / api / institutes /

Filename : subzone.php

back

<?php
include "../../dist/resources/config.php";
include "../common/utils.php";
$data = json_decode(file_get_contents("php://input"), TRUE);

$zone = $data['zone'];

$response = array();
$sql_query =$conn ->prepare("select  institute.inst_id,institute.subzone from institute where inst_zone='$zone' GROUP BY subzone  order by subzone ASC;") ;
     
$sql_query ->execute();

$sql_query -> bind_result($id,$subzone);
$result = array();
while($sql_query ->fetch()){
	$temp = array();
	$temp['inst_id'] = $id;
	$temp['subzone'] = $subzone;
	
	

	array_push($result, $temp);
}

	echo json_encode($result);



	?>