[HTTP: JSON ERROR] ROBLOX can't parse JSON?

Asked by

9 years ago

Hello,

I have recently began development of a database for a group. Within my database, I have a section for points (you earn them @ trainings etc), discipline, medals, and logs. My end goal is something similar to that of RAT's InfoCenter.

Now, I have the points and discipline parts working. The logs and medals, however, are a problem because I am trying to fetch an array from the SQL database. The PHP code I have developed can do this, but the true problem lies in getting the array from the server back to roblox. The array must also be able to be iterated through.

Every time I use "json_encode($array);" (<< that code is PHP) and I echo it, it leads to an error when I try to decode it on the roblox server. The error is "Can't parse JSON". I tried both playing it in studio, and in game both of which fail to get the results I need.

Without further explanation, I will provide my code.

LUA CODE:

01-- receives userid via remote function
02-- passes userid to GET_STRIKES_API in web server
03 
04--function_ = game.ServerStorage.operating_system_q.remote_functions.invoke_f_strikes
05 
06-- ignore above ^
07 
08function get()
09 
10    local id = 17134610
11    print("starting")
12 
13    local s = game:GetService([==[HttpService]==]); -- / Assumes HttpEnabled is true
14    local info = {
15        userID = id;        
16    }
17    local json = s:JSONEncode(info);
18    local data = s:PostAsync([=[--]=], json);
19    local d = data
20    local new = s:JSONDecode(d);
21    print(new)
22end
23 
24get()
 View all 24 lines...

PHP CODE:

01<?php
02 
03        header('Content-Type: application/json');
04    $JSONReceived = file_get_contents("php://input");
05 
06    $Array = json_decode($JSONReceived, true);
07 
08    $userID = intval($Array['userID']);
09 
10    $servername = "--";
11    $username = "--";
12    $password = "--";
13    $dbname = "--";
14 
15    // Create connection
16    $conn = new mysqli($servername, $username, $password, $dbname);
17    // Check connection
18    if ($conn->connect_error) {
19        die("Connection failed: " . $conn->connect_error);
20    }
21 
22    $sql = "SELECT * FROM point_logs WHERE userid=$userID";
23    $result = $conn->query($sql);
24 
25    $host_array = array();
26    $timestamp_array = array();
27    $pointsawarded_array = array();
28    $description_array = array();
29 
30    $master_array = array();
31 
32    if ($result->num_rows > 0) {
33        // output data of each row
34        while($row = $result->fetch_assoc()) {
35            array_push($host_array, $row["host"]);
36            array_push($timestamp_array, $row["time"]);
37            array_push($pointsawarded_array, $row["points_awarded"]);
38            array_push($description_array, $row["description"]);
39 
40            $j1 = json_encode($host_array, true);
41            $j2 = json_encode($timestamp_array, true);
42            $j3 = json_encode($pointsawarded_array, true);
43            $j4 = json_encode($description_array, true);
44 
45            array_push($master_array, $j1, $j2, $j3, $j4);
46            $new_array = json_encode($master_array);
47            echo $new_array,"\n";
48        }
49    } else {
50        echo "error";
51    }
52 
53?>
 View all 53 lines...

The database contains two log entries with the said userid found in the lua code. Thus, the while($row = $result->fetch_assoc()) section runs twice. Obviously, I have the correct server name, username, database name, and password. I simply deleted those so you don't decide to log into my database ;)

If you have any questions, please ask.

And thanks in advance.

UPDATE With the following lua code:

01-- receives userid via remote function
02-- passes userid to GET_STRIKES_API in web server
03 
04--function_ = game.ServerStorage.operating_system_q.remote_functions.invoke_f_strikes
05 
06-- ignore above ^
07 
08function get()
09    local URLs = {}
10    local id = 17134610
11    print("starting")
12 
13    local s = game:GetService([==[HttpService]==]); -- / Assumes HttpEnabled is true
14    local info = {
15        userID = id;        
16    }
17    local json = s:JSONEncode(info);
18    local data = s:PostAsync([=[http://forfoxarmy.esy.es/database/Logs/GET_PLOGS_API.php]=], json);
19    --local a = s:GetAsync("--", true)
20    local d = data
21    print(d)
22    --local wfwe = s:JSONDecode(a)
23    --print(wfwe)
24end
25 
26get()
 View all 26 lines...

and the same PHP code as describe above, it prints

`1`	`["[\"blankdata\"]","[\"2016-02-04 04:08:37\"]","[\"1\"]","[\"blankdatal\"]"]`

`2`	`["[\"blankdata\"]","[\"2016-02-04 04:08:37\"]","[\"1\"]","[\"blankdatal\"]","[\"blankdata\",\"blankdata\"]","[\"2016-02-04 04:08:37\",\"2016-02-04 04:08:40\"]","[\"1\",\"1\"]","[\"blankdata\",\"blankdata\"]"]`

The information "blankdata", "2016-02-04 04:08:37", and "1" were information inputted in my SQL database (not random things being printed).

I know little of PHP, but what happens when you print the encoded JSON on the ROBLOX side? HTTPService:JSONDecode is expecting a string to decode. adark 5487 — 9y

Have you tried printing the data to make sure you're getting back what you think you are? e.g., is it possible you're getting back "error" ? BlueTaslem 18071 — 9y

Can you post what the PHP file is outputting? Merely 2122 — 9y

Yea, sure. adspace44 20 — 9y

View all comments (2 more)

["[\"blankdata\"]","[\"2016-02-04 04:08:37\"]","[\"1\"]","[\"blankdata\"]"] ["[\"blankdata\"]","[\"2016-02-04 04:08:37\"]","[\"1\"]","[\"he did well\"]","[\"xEnforcer\",\"xEnforcer\"]","[\"2016-02-04 04:08:37\",\"2016-02-04 04:08:40\"]","[\"1\",\"1\"]","[\"blankdata\",\"blankdata\"]"] adspace44 20 — 9y

^ that is information from my SQL database being printed adspace44 20 — 9y

[HTTP: JSON ERROR] ROBLOX can't parse JSON?

1 answer

Answer this question