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, 1185👍, 0💬
Popular Posts:
How to add or change the footer on a layout in PowerPoint? I want my slide footers to have the same ...
What is outlook.office365.com? Our IT tells us to migrate to outlook.office365.com. outlook.office36...
How to download FrameMaker 2017 Release for my Windows computer? I want to try it. You can follow th...
What browser to use to cast Website and video to Chromecast devices on my Android phone? On your And...
Why the "dir" command hangs when using the FTP command-line tool on Windows? when you run the "dir" ...