decode json to php array and then to mysql

Question

i need to translate this json into a php array then cycle through the items and put them into there respective columns i have tried using json decode on it own but all i get back is the text array i know the request works fine and gives the following output :

 [{"roomType":"Single rooms","roomTypeCode":"SB"},{"roomType":"Double rooms","roomTypeCode":"DB"},{"roomType":"Twin rooms","roomTypeCode":"TB"},{"roomType":"Triple rooms","roomTypeCode":"TR"},{"roomType":"Suites","roomTypeCode":"S"},{"roomType":"Non-smoking rooms","roomTypeCode":"NS"},{"roomType":"Quad rooms","roomTypeCode":"Q"},{"roomType":"Twin for sole use","roomTypeCode":"TS"}]

if i print the string that needs to be decoded its all there but json decode doesn't seem to be able to just but this into an associative array the way im trying to use it heres the request

$ch = curl_init();
$timeout = 0;
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
$rawdatar = curl_exec($ch);
curl_close($ch);
$roomdata = json_decode($rawdatar);
print $roomdata;

if i print $rawdatar i get the aforementioned line of json but nothing but Array when i print $roomdata what am i doing wrong

Use var_dump() to see what you got instead of print.

fdomig
– fdomig

2012-08-10 18:40:44 +00:00
Commented Aug 10, 2012 at 18:40 — fdomig
– fdomig, Commented Aug 10, 2012 at 18:40

Tim Withers · Accepted Answer · 2012-08-10 18:43:33Z

2

Your JSON data is an array of objects:

Try doing this:

echo $roomdata[0]->roomType;

if you print($roomdata), it will always show Array because that is what it is. For more information, read up on json_decode: http://php.net/manual/en/function.json-decode.php

answered Aug 10, 2012 at 18:43

Tim Withers

12.1k5 gold badges45 silver badges68 bronze badges

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

Comments

Mike Brant · Accepted Answer · 2012-08-10 18:43:51Z

1

Decoding JSON is not going to magically put things into an associative array. The JSON structure you have there represents an array of objects. You would need to map this to an associative array yourself like this:

$object_array = json_decode($rawdatar);
$result_array = array();
foreach($object_array as $obj) {
    $result_array[$obj->roomType] = $obj->roomTypeCode;
}

answered Aug 10, 2012 at 18:43

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Collectives™ on Stack Overflow

decode json to php array and then to mysql

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related