FM / gcdriver

/home/desid573/public_html/gcdriver

Name	Size	Mode	Actions
assets/	-	0755	rm
lib/	-	0755	rm
payment/	-	0755	rm
PHPMailer/	-	0755	rm
square/	-	0755	rm
array.php	2200	0644	edit dl rm
a_name_address.php	959	0644	edit dl rm
class.phpmailer.php	140901	0644	edit dl rm
class.pop3.php	10385	0644	edit dl rm
class.smtp.php	40343	0644	edit dl rm
error_log	41735	0644	edit dl rm
gcpathfinder.png	2088	0644	edit dl rm
gcsedan.png	2636	0644	edit dl rm
index.php	83374	0644	edit dl rm
logo.jpg	24991	0644	edit dl rm
newJob.php	7176	0644	edit dl rm
PHPMailer.zip	255392	0644	edit dl rm
style.json	1014	0644	edit dl rm
test.php	977	0644	edit dl rm
test2.php	932	0644	edit dl rm
test3.php	1269	0644	edit dl rm
thankyou.php	21667	0644	edit dl rm
typeConfig.php	1460	0644	edit dl rm

Edit: /home/desid573/public_html/gcdriver/array.php (2200B)

<?php

require("lib/config.php");
	    
	    
	    $query = "SELECT * FROM locations";
        $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;
                
            }
            
            
           
                
                
            
            
            
         
            
        }
        
        $query = "SELECT * FROM prices";
        $result = mysqli_query($conn, $query);
        
        $price = array();
        
        while($row = mysqli_fetch_assoc($result)) {
        
            array_push($price, $row);
            
        }
        
        
        $response["status"] = "ok";
        $response["areas"] = $array;
        $response["terminals"] = $city;
        $response["prices"] = $price;
        
        
        
        echo json_encode($response, true);

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; } } $query = "SELECT * FROM prices"; $result = mysqli_query($conn, $query); $price = array(); while($row = mysqli_fetch_assoc($result)) { array_push($price, $row); } $response["status"] = "ok"; $response["areas"] = $array; $response["terminals"] = $city; $response["prices"] = $price; echo json_encode($response, true); ?>