{"id":25995,"date":"2022-12-14T22:21:20","date_gmt":"2022-12-14T16:51:20","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/"},"modified":"2022-12-14T22:21:20","modified_gmt":"2022-12-14T16:51:20","slug":"solved-how-to-read-json-values-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/","title":{"rendered":"[Solved] how to read Json values [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Whoever designed ( and I dont know why I used the word designed ) this data structure should be taken out and given a basic education…. and then shot.<\/p>\n

I dont know of any language where a field or class or property could possibly be expected to allow a space in a name i.e. Measurement 0<\/code> and what makes it doubly bad is that json data is supposed to be universally usable in any language.<\/p>\n

To the designer: No Cigar<\/strong> not even an old wet stoggy!<\/p>\n

However this may at least set you on the right lines to solve your problem.<\/p>\n

Its written to run as a PHPCLI script but should work as a webpage as well.<\/p>\n

<?php\n\n\/\/ create the ridiculous json data you have to use\n$j = '{\n   \"Location\":{\n      \"name\":\"rauco\",\n      \"Sensor\":{\n         \"sensor_type\":\"oxygen\",\n         \"sensor_id\":0,\n         \"logger_id\":1,\n         \"Measurement 0\":{\n            \"timestamp\":1406865601,\n            \"oxygen\":10.2,\n            \"temperature\":12.4,\n            \"depth\":5,\n            \"salinity\":0,\n            \"status\":1\n         },\n         \"Measurement 1\":{\n            \"timestamp\":1406865661,\n            \"oxygen\":9.9,\n            \"temperature\":12.4,\n            \"depth\":5,\n            \"salinity\":0,\n            \"status\":1\n         },\n         \"Measurement 2\":{\n            \"timestamp\":1406865721,\n            \"oxygen\":10.2,\n            \"temperature\":12.4,\n            \"depth\":5,\n            \"salinity\":0,\n            \"status\":1\n         },\n         \"Measurement 3\":{\n            \"timestamp\":1406865781,\n            \"oxygen\":10.4,\n            \"temperature\":12.4,\n            \"depth\":5,\n            \"salinity\":0,\n            \"status\":1\n         },\n         \"Measurement 4\":{\n            \"timestamp\":1406865841,\n            \"oxygen\":10,\n            \"temperature\":12.5,\n            \"depth\":5,\n            \"salinity\":0,\n            \"status\":1\n         },\n         \"Measurement 5\":{\n            \"timestamp\":1406865961,\n            \"oxygen\":8.9,\n            \"temperature\":12.4,\n            \"depth\":5,\n            \"salinity\":0,\n            \"status\":1\n         }\n      }\n   }\n}';\n<\/code><\/pre>\n
Now the code<\/p>\n
$json = json_decode($j);\n\n$x = 0;\nwhile ( 1 ) {\n    $impossible_obj_name = \"Measurement $x\";\n    if ( isset( $json->Location->Sensor->{$impossible_obj_name}) ) {\n\n        echo sprintf( 'timestamp: %s, oxygen %s, temperature: %s, depth: %s, salinity: %s, status: %s'.PHP_EOL,\n                $json->Location->Sensor->{$impossible_obj_name}->timestamp,\n                $json->Location->Sensor->{$impossible_obj_name}->oxygen,\n                $json->Location->Sensor->{$impossible_obj_name}->temperature,\n                $json->Location->Sensor->{$impossible_obj_name}->depth,\n                $json->Location->Sensor->{$impossible_obj_name}->salinity,\n                $json->Location->Sensor->{$impossible_obj_name}->status);\n\n        $x++;\n    } else {\n        break;\n    }\n}\n<\/code><\/pre>\n
It should generate this as output, I realise this is probably not what you actually want the end result to be but it demonstrates the syntax you will have to use to get over the disasterous data structure design.<\/p>\n
timestamp: 1406865601, oxygen 10.2, temperature: 12.4, depth: 5, salinity: 0, status: 1\ntimestamp: 1406865661, oxygen 9.9, temperature: 12.4, depth: 5, salinity: 0, status: 1\ntimestamp: 1406865721, oxygen 10.2, temperature: 12.4, depth: 5, salinity: 0, status: 1\ntimestamp: 1406865781, oxygen 10.4, temperature: 12.4, depth: 5, salinity: 0, status: 1\ntimestamp: 1406865841, oxygen 10, temperature: 12.5, depth: 5, salinity: 0, status: 1\ntimestamp: 1406865961, oxygen 8.9, temperature: 12.4, depth: 5, salinity: 0, status: 1\n<\/code><\/pre>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            <\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved how to read Json values [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] Whoever designed ( and I dont know why I used the word designed ) this data structure should be taken out and given a basic education…. and then shot. I dont know of any language where a field or class or property could possibly be expected to allow a space in a name i.e. … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[356,339],"class_list":["post-25995","post","type-post","status-publish","format-standard","hentry","category-solved","tag-json","tag-php"],"yoast_head":"\n[Solved] how to read Json values [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] how to read Json values [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Whoever designed ( and I dont know why I used the word designed ) this data structure should be taken out and given a basic education…. and then shot. I dont know of any language where a field or class or property could possibly be expected to allow a space in a name i.e. ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-14T16:51:20+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] how to read Json values [closed]\",\"datePublished\":\"2022-12-14T16:51:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/\"},\"wordCount\":172,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"json\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/\",\"name\":\"[Solved] how to read Json values [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-14T16:51:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] how to read Json values [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] how to read Json values [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] how to read Json values [closed] - JassWeb","og_description":"[ad_1] Whoever designed ( and I dont know why I used the word designed ) this data structure should be taken out and given a basic education…. and then shot. I dont know of any language where a field or class or property could possibly be expected to allow a space in a name i.e. ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/","og_site_name":"JassWeb","article_published_time":"2022-12-14T16:51:20+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] how to read Json values [closed]","datePublished":"2022-12-14T16:51:20+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/"},"wordCount":172,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["json","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/","name":"[Solved] how to read Json values [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-14T16:51:20+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-read-json-values-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] how to read Json values [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/25995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=25995"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/25995\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=25995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=25995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=25995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}