Insert into MySQL using JSON not working

Question

What do I have wrong in the following code:

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "practice";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connection made...";

//$payload_dump = $_POST['payload']
$payload = '{"device":"gabriel","data_type":"data","zone":1,"sample":4,"count":0,"time_stamp":"00:00"}'

$payload_array = json.decode($payload,true);

//get the data_payload details
$device = $payload_array['device'];
$type = $payload_array['data_type'];
$zone = $payload_array['zone'];
$sample = $payload_array['sample'];
$count = $payload_array['count'];
$time = $payload_array['time_stamp'];

$sql = "INSERT INTO data(device, data_type, zone, sample, count, time_stamp) VALUES('$device', '$type', '$zone', '$sample', '$count', '$time')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}


$conn->close();
?>

I get the following error:

Parse error: syntax error, unexpected '$payload_array' (T_VARIABLE) in /Applications/XAMPP/xamppfiles/htdocs/insert_from_json.php on line 18

This PHP file receives the "payload" from a python file via JSON. The PHP file inserts that data into a table. $payload is a test variable to "simulate" the data coming in from the python code in the line above it. The payload could contain multiple rows. Maybe there is a better way to insert multiple rows than what I am attempting?

Syntax error json.decode should be json_decode

RiggsFolly
– RiggsFolly

2015-08-06 15:32:39 +00:00
Commented Aug 6, 2015 at 15:32 — RiggsFolly
– RiggsFolly, Commented Aug 6, 2015 at 15:32
; is missing at the end of 16th line as well

Mantas
– Mantas

2015-08-06 15:38:45 +00:00
Commented Aug 6, 2015 at 15:38 — Mantas
– Mantas, Commented Aug 6, 2015 at 15:38

dlporter98 · Accepted Answer · 2015-08-06 15:32:52Z

1

On line 18 you have the following:

$payload_array = json.decode($payload,true);

When it should be

$payload_array = json_decode($payload,true);

You used a period (.) instead of an underscore (_).

answered Aug 6, 2015 at 15:32

dlporter98

1,6301 gold badge12 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

RiggsFolly Over a year ago

Thats what I said too.

dlporter98 Over a year ago

I think we were doing it at the same time. I try to refresh the screen a few times before posting an answer to see if someone has already posted a decent one.

RiggsFolly Over a year ago

No sweat, was just having a laugh, not a dig

Collectives™ on Stack Overflow

Insert into MySQL using JSON not working

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related