User Profile

dqjqb · Jun 22 '16, 11:55 AM

I'm trying to get a JSON-file looking like this:

Code:

[
    [
    'Disease', [ latitude, longitude, magnitude, latitude, longitude, magnitude, ... ]
    ],
    [
    'Disease', [ latitude, longitude, magnitude, latitude, longitude, magnitude, ... ]
    ]
];

This is the current code:

Code:

$sqlDisease = mysql_query("SELECT DISTINCT Disease FROM DiseaseData")

...

dqjqb · Jun 16 '16, 12:18 PM

So, I'm trying to fetch API-data using cURL, but I get the message "fail" from the else-statement in the code below.
The API call is Google geocode for fetching coordinates.

The code:

Code:

 <?php 
    require_once('../db.php');
    $api_key = "somekey";
    $sqlQuery = mysql_query("SELECT `County` FROM `table`"); 
    $ch = curl_init();

...

User Profile

Profile Sidebar

MySQL to JSON, trouble while creating a nested array.

cURL not working while fetching Google API data