File: /var/www/nclive/backend/state_get_header_state.php
<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
include "config.php";
$getHeaderStateQuery="Select state_id, state_name, state_slug, state_code , image_icon from sp_states where header_status='1' order by header_order limit 7 ";
$sqlHeaderState=$db->prepare($getHeaderStateQuery);
$sqlHeaderState->execute();
$stateDataArray = array();
while($rowHeaderState=$sqlHeaderState->fetch()){
$stateArray = array();
$stateArray["state_id"] = $rowHeaderState['state_id'];
$stateArray["state_code"] = $rowHeaderState['state_code'];
$stateArray["state_name"] = $rowHeaderState['state_name'];
$stateArray["state_slug"] = $rowHeaderState['state_slug'];
$stateArray["state_icon"] = $rowHeaderState['image_icon'];
$stateDataArray[]=$stateArray;
}
$jsonData[]=array("state_data"=>$stateDataArray);
echo json_encode($jsonData);
?>