File: /var/www/nclive/backend/preexamapi.php
<?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);
$array = array(2,6,7,8,9,11);
$ID=implode(',', $array);
$query="SELECT t1.id, t1.name,t1.entity_id,t1.label, t1.status FROM sp_exam_entity as t1 WHERE t1.id IN ($ID) order by t1.display_order ASC";
$sql2=$db->prepare($query);
$sql2->execute();
$mainSub = array();
while($row=$sql2->fetch()){
$id= $row['id'];
$enti_id= $row['entity_id'];
$enti_name= $row['name'];
$label= $row['label'];
$main[]=array("id"=>$id,"entity_id"=>$enti_id,"entity"=>$enti_name,"label"=>$label);
}
echo json_encode($main);
?>