Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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

share|improve this question
1  
Use var_dump() to see what you got instead of print. – fdomig Aug 10 '12 at 18:40
add comment (requires an account with 50 reputation)

2 Answers

up vote 2 down vote

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

share|improve this answer
add comment (requires an account with 50 reputation)
up vote 1 down vote

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;
}
share|improve this answer
add comment (requires an account with 50 reputation)

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.