HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux ip-172-31-18-78 6.17.0-1017-aws #17~24.04.1-Ubuntu SMP Tue May 26 21:09:53 UTC 2026 aarch64
User: ubuntu (1000)
PHP: 8.2.31
Disabled: NONE
Upload Files
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);


?>