Categories:
Cloud (204)
Entertainment (11)
Facebook (43)
General (50)
Life (31)
Programming (64)
Technology (398)
Testing (4)
Tools (488)
Twitter (5)
Wearable (26)
Web Design (44)
Collections:
Other Resources:
php json array problems
I am creating a json array in PHP like this (it's inside a class):
$STH = $DBH->query("SELECT ID,title,content FROM table WHERE ID= '".$ID."' "); $querycount = $STH->rowCount(); if($querycount!=0): $STH->setFetchMode(PDO::FETCH_OBJ); while( $row = $STH->fetch()) : $thread[$row->ID]['title'] = $row->title; $thread[$row->ID]['content'] = $row->content; endwhile; $this->querycount = $querycount; $this->thread = json_encode($thread); else: $this->querycount = $querycount; endif;
But I seem to get "strange" decodes the other end. I cannot actually reference the array by key's;
So far it will let me do this: (Where af_threads is the class name and $key id the ID in the table query)
$threads = new af_threads($key,$DBH); $threads = json_decode($threads->thread); foreach($threads as $key1=>$thread): foreach($thread as $key2=>$val): echo $key2; echo $val; endforeach; echo '
'; endforeach;
But what it will not let me do is something like this
$threads[$key]['title']
I'm not sure why. As the class builds i.e. with more rows etc. I will need to call specific rows in specific places. i.e. $threads[$key]['newrow'], $threads[$key]['newrow2'], and or to manipulate a row with say substr(); etc.
Yes I know I could just echo out an array without json, but eventually I want to add cross domain functionality with JQuery getJSON() ...
✍: Guest
By default, json_decode() returns stdClass, modify second line with
$threads = json_decode($threads->thread, true)
and you will get an associative array and be able to reference it by keys, $threads[$key]['title'] for example.
2015-05-21, 1256🔥, 0💬
Popular Posts:
Sometimes I see special symbols are showing up at the end of each paragraph in my Microsoft Word doc...
What browser to use to cast Website and video to Chromecast devices on my iPhone and iPad? On your i...
How to unzip a Word Document .docx file? According to Microsoft documentation, a .docx file is reall...
How to make continuous page numbering in a FrameMaker book? I want to see the page number continues ...
"Muss i denn" is a German folk song in the Swabian German dialect. The present form dates back to 18...