get values of multidimensional json array

Question

I am trying to get the value of two variables from an json array. The array becomes sended with ajax then decoded and "saved" into $jsonarray. Then I try to get the volume and the symbol variables from the array and insert them into my database. I dont understand the syntax of this $jsonarray->result->{"quote"}->symbol and tried any times how its right but the error wont disappear.

thats my array:

{"query":{"count":1,"created":"2016-02-15T15:11:47Z","lang":"de-DE","results":{"quote":{"symbol":"ZN","Ask":"2.05","Bid":"1.78","Volume":"13214","PercentChange":"+0.56%"}}}}

relevant php piece:

$jsonString = $_POST['mydata'];
$jsonarray = json_decode($jsonString[0]['query']);
if ($stmt = $mysqli->prepare('INSERT INTO volume (stocksymbol, volume, time) VALUES ( ?, ?, now())')) {

    /* bind parameters for markers */
    $stmt->bind_param("si", $jsonarray->result->{"quote"}->symbol, $jsonarray->result->{"quote"}->Volume);

    /* execute query */
    $stmt->execute();

    /* close statement */
    $stmt->close();
}

You should perhaps peruse the manual for how bind_param needs to be called: php.net/manual/en/mysqli-stmt.bind-param.php — deceze
– deceze ♦, Commented Feb 15, 2016 at 15:28
Now that you've fixed the cause of the issue... is there still any problem...?! — deceze
– deceze ♦, Commented Feb 15, 2016 at 15:48
I take that as a "no"?! You've basically removed your question with your last edits... — deceze
– deceze ♦, Commented Feb 15, 2016 at 15:57
When I run var_dump($jsonarray); I get NULL I search now where the problem is. — Bodoppels
– Bodoppels, Commented Feb 15, 2016 at 16:02

C Würtz · Accepted Answer · 2016-02-15 16:14:05Z

2

Are you sure this line is correct? $jsonarray = json_decode($jsonString[0]['query']);

In this case, you should access to the result by: $jsonarray->query->results->...

edited Feb 15, 2016 at 16:14

answered Feb 15, 2016 at 15:53

C Würtz

8749 silver badges20 bronze badges

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

2 Comments

Bodoppels Over a year ago

Yes thank you thats the problem, I am trying to search now for the reason

C Würtz Over a year ago

The JSON object has only one first level property: query. It's not {"count":1, "created": "today", "lang": "AZ", "results": {}}

hasumedic · Accepted Answer · 2016-02-15 15:35:07Z

2

Try with:

/* bind parameters for markers */
    $stmt->bind_param("ss", $jsonarray->result->{"quote"}->symbol, $jsonarray->result->{"quote"}->Volume);

answered Feb 15, 2016 at 15:35

hasumedic

2,17712 silver badges17 bronze badges

Comments

Sergey Vidusov · Accepted Answer · 2016-02-16 04:30:21Z

1

You could try and decode your JSON as an associative array instead. Assuming that $_POST['mydata'] contains the JSON string you showed us, try this:

$jsonString = $_POST['mydata']; 
$jsonarray = json_decode($jsonString, TRUE);

This way, you can access the values in a more consistent way:

$stmt->bind_param(
     "si", 
     $jsonarray['query']['results']['quote']['symbol'], 
     $jsonarray['query']['results']['quote']['Volume']
);

answered Feb 16, 2016 at 4:30

Sergey Vidusov

1,3421 gold badge7 silver badges10 bronze badges

Collectives™ on Stack Overflow

get values of multidimensional json array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related