Databases
StackOverflow2013
Postsdbo
POHandling data in a PHP JSON Object
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHandling data in a PHP JSON Object
    text
    copied!<p>Trends data from Twitter Search API in JSON.</p> <p>Grabbing the file using:</p> <pre><code>$jsonurl = "http://search.twitter.com/trends.json"; $json = file_get_contents($jsonurl,0,null,null); $json_output = json_decode($json); </code></pre> <p>How do I work with data from this object. As an array? Only really need to extract data from the [name] values.</p> <p>JSON object contains:</p> <pre><code>stdClass Object ( [trends] =&gt; Array ( [0] =&gt; stdClass Object ( [name] =&gt; Vote [url] =&gt; http://search.twitter.com/search?q=Vote ) [1] =&gt; stdClass Object ( [name] =&gt; Halloween [url] =&gt; http://search.twitter.com/search?q=Halloween ) [2] =&gt; stdClass Object ( [name] =&gt; Starbucks [url] =&gt; http://search.twitter.com/search?q=Starbucks ) [3] =&gt; stdClass Object ( [name] =&gt; #flylady [url] =&gt; http://search.twitter.com/search?q=%23flylady ) [4] =&gt; stdClass Object ( [name] =&gt; #votereport [url] =&gt; http://search.twitter.com/search?q=%23votereport ) [5] =&gt; stdClass Object ( [name] =&gt; Election Day [url] =&gt; http://search.twitter.com/search?q=%22Election+Day%22 ) [6] =&gt; stdClass Object ( [name] =&gt; #PubCon [url] =&gt; http://search.twitter.com/search?q=%23PubCon ) [7] =&gt; stdClass Object ( [name] =&gt; #defrag08 [url] =&gt; http://search.twitter.com/search?q=%23defrag08 ) [8] =&gt; stdClass Object ( [name] =&gt; Melbourne Cup [url] =&gt; http://search.twitter.com/search?q=%22Melbourne+Cup%22 ) [9] =&gt; stdClass Object ( [name] =&gt; Cheney [url] =&gt; http://search.twitter.com/search?q=Cheney ) ) [as_of] =&gt; Mon, 03 Nov 2008 21:49:36 +0000 ) </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload