<?php
$json = '{
"data": {
"loans": {
"totalCount": 301,
"values": [{
"name": "Anastacia",
"status": "fundRaising",
"plannedExpirationDate": "2017-08-19T22:10:06Z"
},
{
"name": "Mercy",
"status": "fundRaising",
"plannedExpirationDate": "2017-08-19T22:10:05Z"
}
]
}
}
}';
// to see the index more clerly we can use this
// to check for any parsing errors
switch (json_last_error()) {
case JSON_ERROR_NONE:
echo ' - No errors';
break;
case JSON_ERROR_DEPTH:
echo ' - Maximum stack depth exceeded';
break;
case JSON_ERROR_STATE_MISMATCH:
echo ' - Underflow or the modes mismatch';
break;
case JSON_ERROR_CTRL_CHAR:
echo ' - Unexpected control character found';
break;
case JSON_ERROR_SYNTAX:
echo ' - Syntax error, malformed JSON';
break;
case JSON_ERROR_UTF8:
echo ' - Malformed UTF-8 characters, possibly incorrectly encoded';
break;
default:
echo ' - Unknown error';
break;
}
echo "\n";
//This works:
echo $json_a['data']['loans']['values'][0]['name'];
echo "\n";
//this does not:
echo $json_a['data']['loans']['values'][0]['plannedExpirationDate'];
echo "\n";
//this does not either. It prints a date in 1970.
$date= $json_a['data']['loans']['values'][1]['plannedExpirationDate'];
?>
PD9waHAKCiRqc29uID0gJ3sKICAgICJkYXRhIjogewogICAgICAgICJsb2FucyI6IHsKICAgICAgICAgICAgInRvdGFsQ291bnQiOiAzMDEsCiAgICAgICAgICAgICJ2YWx1ZXMiOiBbewogICAgICAgICAgICAgICAgICAgICJuYW1lIjogIkFuYXN0YWNpYSIsCiAgICAgICAgICAgICAgICAgICAgInN0YXR1cyI6ICJmdW5kUmFpc2luZyIsCiAgICAgICAgICAgICAgICAgICAgInBsYW5uZWRFeHBpcmF0aW9uRGF0ZSI6ICIyMDE3LTA4LTE5VDIyOjEwOjA2WiIKICAgICAgICAgICAgICAgIH0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgIm5hbWUiOiAiTWVyY3kiLAogICAgICAgICAgICAgICAgICAgICJzdGF0dXMiOiAiZnVuZFJhaXNpbmciLAogICAgICAgICAgICAgICAgICAgICJwbGFubmVkRXhwaXJhdGlvbkRhdGUiOiAiMjAxNy0wOC0xOVQyMjoxMDowNVoiCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgIF0KICAgICAgICB9CiAgICB9Cn0nOwoKICAgIAovLyB0byBzZWUgdGhlIGluZGV4IG1vcmUgY2xlcmx5IHdlIGNhbiB1c2UgdGhpcwp2YXJfZHVtcChqc29uX2RlY29kZSgkanNvbiwgdHJ1ZSkpOyAKCgovLyB0byBjaGVjayBmb3IgYW55IHBhcnNpbmcgZXJyb3JzCnN3aXRjaCAoanNvbl9sYXN0X2Vycm9yKCkpIHsKICAgICAgICBjYXNlIEpTT05fRVJST1JfTk9ORToKICAgICAgICAgICAgZWNobyAnIC0gTm8gZXJyb3JzJzsKICAgICAgICBicmVhazsKICAgICAgICBjYXNlIEpTT05fRVJST1JfREVQVEg6CiAgICAgICAgICAgIGVjaG8gJyAtIE1heGltdW0gc3RhY2sgZGVwdGggZXhjZWVkZWQnOwogICAgICAgIGJyZWFrOwogICAgICAgIGNhc2UgSlNPTl9FUlJPUl9TVEFURV9NSVNNQVRDSDoKICAgICAgICAgICAgZWNobyAnIC0gVW5kZXJmbG93IG9yIHRoZSBtb2RlcyBtaXNtYXRjaCc7CiAgICAgICAgYnJlYWs7CiAgICAgICAgY2FzZSBKU09OX0VSUk9SX0NUUkxfQ0hBUjoKICAgICAgICAgICAgZWNobyAnIC0gVW5leHBlY3RlZCBjb250cm9sIGNoYXJhY3RlciBmb3VuZCc7CiAgICAgICAgYnJlYWs7CiAgICAgICAgY2FzZSBKU09OX0VSUk9SX1NZTlRBWDoKICAgICAgICAgICAgZWNobyAnIC0gU3ludGF4IGVycm9yLCBtYWxmb3JtZWQgSlNPTic7CiAgICAgICAgYnJlYWs7CiAgICAgICAgY2FzZSBKU09OX0VSUk9SX1VURjg6CiAgICAgICAgICAgIGVjaG8gJyAtIE1hbGZvcm1lZCBVVEYtOCBjaGFyYWN0ZXJzLCBwb3NzaWJseSBpbmNvcnJlY3RseSBlbmNvZGVkJzsKICAgICAgICBicmVhazsKICAgICAgICBkZWZhdWx0OgogICAgICAgICAgICBlY2hvICcgLSBVbmtub3duIGVycm9yJzsKICAgICAgICBicmVhazsKfQoKZWNobyAiXG4iOwoKJGpzb25fYSA9IGpzb25fZGVjb2RlKCRqc29uLCB0cnVlKTsKCi8vVGhpcyB3b3JrczoKZWNobyAkanNvbl9hWydkYXRhJ11bJ2xvYW5zJ11bJ3ZhbHVlcyddWzBdWyduYW1lJ107CmVjaG8gIlxuIjsKCi8vdGhpcyBkb2VzIG5vdDoKZWNobyAkanNvbl9hWydkYXRhJ11bJ2xvYW5zJ11bJ3ZhbHVlcyddWzBdWydwbGFubmVkRXhwaXJhdGlvbkRhdGUnXTsKZWNobyAiXG4iOwoKLy90aGlzIGRvZXMgbm90IGVpdGhlci4gSXQgcHJpbnRzIGEgZGF0ZSBpbiAxOTcwLgokZGF0ZT0gJGpzb25fYVsnZGF0YSddWydsb2FucyddWyd2YWx1ZXMnXVsxXVsncGxhbm5lZEV4cGlyYXRpb25EYXRlJ107CmVjaG8gZGF0ZSgnZC1tLVkgSDppOnMnLCBzdHJ0b3RpbWUoJGRhdGUpKTsKCj8+