How do I parse this PHP stdClass Object?

Question

The raw output of my object is when I do a print_r is:

Array ( [0] => stdClass Object ( [COUNT(*)] => 3 ) )

How do I get to the 3?

This object is the result of a sql query inside wordpress with the $wpdb class.

I am a noob at PHP objects. Also would like to know

UPDATE: here's the source code:

global $wpdb;
$post_count = $wpdb->get_results("SELECT COUNT(*) FROM $wpdb->posts");
print_r($post_count);

Wouldn't it make more sense to alias it in the query: SELECT count(*) AS total FROM .... — tereško
– tereško, Commented Apr 1, 2012 at 9:53

Michael · Accepted Answer · 2012-04-01 09:50:38Z

3

It's not an object. It's an array containing an object. In that specific example, assuming that the variable is named $variable, you'd do this:

echo $variable[0]->{'COUNT(*)'};

answered Apr 1, 2012 at 9:50

Michael

12.9k6 gold badges57 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

P.S. I wouldn't want to work with data like that, but does anyone else think it looks sort of pretty? :)

Is this the kind of structure that is usually returned by a sql query?

I don't use Wordpress, so I don't know how it pulls out result sets.

I didn't know you could use curly braces like that in PHP (other than in code blocks). What is this structure called?

I don't know if it has a name, but using curly brackets and quoting it allows you to use characters that would otherwise not be allowed.

|

Amit Erandole · Accepted Answer · 2012-04-01 09:53:46Z

1

I found the solution:

global $wpdb;
$post_count = $wpdb->get_results("SELECT COUNT(*) as postcount FROM $wpdb->posts");
print_r($post_count[0]->postcount);

I needed to use an alias.

answered Apr 1, 2012 at 9:53

Amit Erandole

12.3k23 gold badges72 silver badges103 bronze badges