<?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 DISTINCT(t1.state_id) as sid, t1.state_name, t1.image_icon,t2.state_id FROM sp_states as t1
LEFT JOIN sp_exam as t2 on t2.state_id=t1.state_id WHERE t2.state_id!='null' ORDER BY t2.add_date DESC";	
$sql=$db->prepare($query);
$sql->execute();

while($row=$sql->fetch()){	
$state_name= $row['state_name'];
$state_id= $row['sid'];
$image_icon= 'images'.'/'.$row['image_icon'];


$array4=array("state_id"=>$state_id,"state_name"=>$state_name,"image_icon"=>$image_icon);
$mainarray[]=$array4;
}	

echo json_encode($mainarray , TRUE);

?>