/home/desid573/public_html/family
Edit: /home/desid573/public_html/family/array.php (2173B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "SELECT * FROM locations ORDER BY `city`, `airport` DESC";
$result = mysqli_query($conn, $query);
$array = array();
while($row = mysqli_fetch_assoc($result)) {
/*$sql = "UPDATE alert_area SET array = '".serialize($row["array"])."' WHERE id = ".$row["id"];
$success = $conn->query($sql);
if(!$success) {
echo $conn->error;
}*/
$data["city"] = $row["city"];
$data["array"] = unserialize($row["array"]);
$data["airport"] = $row["airport"];
array_push($array, $data);
}
$query = "SELECT * FROM terminal_details";
$result = mysqli_query($conn, $query);
$new = array();
$city = array();
while($row = mysqli_fetch_assoc($result)) {
$cityArray = $city[$row["city"]];
$thisArray = array("name" => $row["name"], "buttonLabel" => $row["buttonLabel"], "lat" => $row["lat"], "long" => $row["long"]);
if($cityArray == null) {
$city[$row["city"]] = [$thisArray];
} else {
array_push($cityArray, $thisArray);
$city[$row["city"]] = $cityArray;
}
}
$response["status"] = "ok";
$response["areas"] = $array;
$response["terminals"] = $city;
echo json_encode($response, true);
?>
