<?php
 header("Access-Control-Allow-Origin: *");

header('Content-Type: application/json');
include "config.php";

$query="select cat_id,name,url_slug,img_icon,status,display_order from sp_exam_category order by display_order ASC";
$sql=$db->prepare($query);
$sql->execute();

$mainarray=array();


while($row=$sql->fetch()){	
$cid=$row['cat_id'];
$exam=$row['name'];
$logo=$row['img_icon'];
$status=$row['status'];
$order=$row['display_order'];
$url_slug=$row['url_slug'];


$array=array("ID"=>$cid,"Name"=>$exam,"Image"=>$logo,"Status"=>$status,"Display order"=>$order,"url_slug"=>$url_slug);
$mainarray[]=$array;
}
echo json_encode($mainarray);

?>