1#@!#!123s

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

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

Filename : list.php

back

<?php
include "../../dist/resources/config.php";
// include "../common/utils.php";



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

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

	array_push($result, $temp);
}

	echo json_encode($result);



	?>