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, 1321🔥, 0💬
Popular Posts:
What is "Microsoft SharePoint Server Colleague Import Add-in" COM Add-in in Outlook 2013? Should I d...
What is the difference between a Web page and a filtered Web page? Word supports 2 Web page formats:...
How to make my presentation beautiful by applying a built-in theme provided by Office PowerPoint 200...
How to Uninstall Skype Meetings App on Windows? I don't need it anymore. You can following this tuto...
How to download and install Facebook for my Android phone? I heard it's free and I want to try it. Y...