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

$query="SELECT id ,category_name FROM sp_institutions_category";
$sql=$db->prepare($query);
$sql->execute();

while($row=$sql->fetch()){	
$id= $row['id'];
$category_name= $row['category_name'];

$array4=array("id"=>$id,"category_name"=>$category_name);
$mainarray[]=$array4;
}	

$main[] = $mainarray;
echo json_encode($main , TRUE);

?>