Databases
StackOverflow2013
Postsdbo
PORearranging Array of WP_Post Objects and Arrays
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORearranging Array of WP_Post Objects and Arrays
    text
    copied!<p>After much time, I created a function that outputs an array of recent posts from any site in a WP multisite network.</p> <p>Now, I'm having trouble with getting this array in a format to easily write out the posts.</p> <p><strong>SOURCE ARRAY</strong> (there are additional WP_Post Object elements, which I omitted for brevity).</p> <pre><code>Array ( [0] =&gt; Array ( [2013-07-15 04:19:59] =&gt; WP_Post Object ( [ID] =&gt; 1008 [post_author] =&gt; 52 [post_date] =&gt; 2013-07-15 04:19:59 [post_content] =&gt; This evening, we witnessed yet another travesty of justice in the ‘not guilty’ verdict on all counts against George Zimmerman the vigilante murderer of Trayvon Martin. [post_title] =&gt; Initial Statement on Verdict of George Zimmerman Trial From Occu-Evolve [guid] =&gt; http://occuevolve.web.net/?p=1 ) [2013-07-11 12:14:59] =&gt; WP_Post Object ( [ID] =&gt; 889 [post_author] =&gt; 1 [post_date] =&gt; 2013-07-11 12:14:59 [post_content] =&gt; Adam Weissman of OWS TradeJustice will be giving a talk on TPP (The Trans Pacific Partnership) on Sunday from 2-3 at Columbia. [post_title] =&gt; This Sunday, Come to hear a talk on TPP – The Bankster’s Secret Plan to Escape Regulation and Kill Public Banks [guid] =&gt; http://alternativebanking.web.net/?p=889 ) [2013-07-09 22:29:41] =&gt; WP_Post Object ( [ID] =&gt; 883 [post_author] =&gt; 1 [post_date] =&gt; 2013-07-09 22:29:41 [post_content] =&gt; It was just publicly and formally acknowledged, five years after AIG cost the US taxpayers billions of dollars that AIG is still a major problem. [post_title] =&gt; AIG is still a threat to financial stability [guid] =&gt; http://alternativebanking.web.net/?p=883 ) [2013-07-05 18:01:42] =&gt; WP_Post Object ( [ID] =&gt; 561 [post_author] =&gt; 12 [post_date] =&gt; 2013-07-05 18:01:42 [post_content] =&gt; [post_title] =&gt; The Good, The Bad, &amp; The Ugly - Week of 7/1/2013 [guid] =&gt; http://occupythesec.web.net/?p=561 ) [2013-07-01 13:21:40] =&gt; WP_Post Object ( [ID] =&gt; 965 [post_author] =&gt; 51 [post_date] =&gt; 2013-07-01 13:21:40 [post_content] =&gt; Crossposted from mathbabe.org. Opinions expressed are those of Cathy O'Neil. [post_title] =&gt; Payroll cards: "It costs too much to get my money" (#OWS) [guid] =&gt; http://alternativebanking.web.net/?p=880 ) [2013-06-28 18:36:27] =&gt; WP_Post Object ( [ID] =&gt; 553 [post_author] =&gt; 50 [post_date] =&gt; 2013-06-28 18:36:27 [post_content] =&gt; [post_title] =&gt; The Good, The Bad, &amp; The Ugly - Week of 6/24/2013 [guid] =&gt; http://occupythesec.web.net/?p=553 ) [2013-06-21 15:12:45] =&gt; WP_Post Object ( [ID] =&gt; 543 [post_author] =&gt; 50 [post_date] =&gt; 2013-06-21 15:12:45 [post_content] =&gt; [guid] =&gt; http://occupythesec.web.net/?p=543 ) ) [1] =&gt; Array ( [http://occuevolve.web.net/?p=1] =&gt; http://localhost/groups.occupy.net/web/occuevolve/2013/07/15/initial-statement-on-verdict-of-george-zimmerman-trial/ [http://occupythesec.web.net/?p=561] =&gt; http://localhost/groups.occupy.net/web/occupythesec/2013/07/05/the-good-the-bad-the-ugly-week-of-712013/ [http://occupythesec.web.net/?p=553] =&gt; http://localhost/groups.occupy.net/web/occupythesec/2013/06/28/the-good-the-bad-the-ugly-week-of-6242013/ [http://alternativebanking.web.net/?p=889] =&gt; http://localhost/groups.occupy.net/web/altbanking/2013/07/this-sunday-come-to-hear-a-talk-on-tpp-the-banksters-secret-plan-to-escape-regulation-and-kill-public-banks/ [http://alternativebanking.web.net/?p=883] =&gt; http://localhost/groups.occupy.net/web/altbanking/2013/07/aig-is-still-a-threat-to-financial-stability/ [http://alternativebanking.web.net/?p=880] =&gt; http://localhost/groups.occupy.net/web/altbanking/2013/07/payroll-cards-it-costs-too-much-to-get-my-money-ows/ [http://occupythesec.web.net/?p=543] =&gt; http://localhost/groups.occupy.net/web/occupythesec/2013/06/21/the-good-the-bad-the-ugly-week-of-61713/ ) [2] =&gt; Array ( [http://occuevolve.web.net/?p=1] =&gt; 4 [http://occupythesec.web.net/?p=561] =&gt; 3 [http://occupythesec.web.net/?p=553] =&gt; 3 [http://alternativebanking.web.net/?p=889] =&gt; 2 [http://alternativebanking.web.net/?p=883] =&gt; 2 [http://alternativebanking.web.net/?p=880] =&gt; 2 [http://occupythesec.web.net/?p=543] =&gt; 3 ) ) </code></pre> <p><strong>DESIRED RESULT</strong></p> <pre><code>Array ( [http://occuevolve.web.net/?p=1] =&gt; Array ( [ID] =&gt; 1008 [post_author] =&gt; 52 [post_date] =&gt; 2013-07-15 04:19:59 [post_content] =&gt; This evening, we witnessed yet another travesty of justice in the ‘not guilty’ verdict on all counts against George Zimmerman the vigilante murderer of Trayvon Martin. [post_title] =&gt; Initial Statement on Verdict of George Zimmerman Trial From Occu-Evolve [post_url] =&gt; http://localhost/groups.occupy.net/web/occuevolve/2013/07/15/initial-statement-on-verdict-of-george-zimmerman-trial/ [blog_id] =&gt; 4 ) [http://alternativebanking.web.net/?p=889] =&gt; Array ( [ID] =&gt; 889 [post_author] =&gt; 1 [post_date] =&gt; 2013-07-11 12:14:59 [post_content] =&gt; Adam Weissman of OWS TradeJustice will be giving a talk on TPP (The Trans Pacific Partnership) on Sunday from 2-3 at Columbia. [post_title] =&gt; This Sunday, Come to hear a talk on TPP – The Bankster’s Secret Plan to Escape Regulation and Kill Public Banks [post_url] =&gt; http://localhost/groups.occupy.net/web/occupythesec/2013/07/05/the-good-the-bad-the-ugly-week-of-712013/ [blog_id] =&gt; 3 ) [http://alternativebanking.web.net/?p=883] =&gt; Array ( [ID] =&gt; 883 [post_author] =&gt; 1 [post_date] =&gt; 2013-07-09 22:29:41 [post_content] =&gt; It was just publicly and formally acknowledged, five years after AIG cost the US taxpayers billions of dollars that AIG is still a major problem. [post_title] =&gt; AIG is still a threat to financial stability [post_url] =&gt; http://localhost/groups.occupy.net/web/occupythesec/2013/06/28/the-good-the-bad-the-ugly-week-of-6242013/ [blog_id] =&gt; 3 ) etc..... ) </code></pre> <p><em>Note:</em> </p> <ul> <li>$array[1] contains the post_url</li> <li>$array[2] contains the blog_id</li> </ul>
 

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