Get data from stdclass Object - Count from mysql

Question

I was looking for over 3 hours on the internet how to get data from stdclass Object and none of these solution I found worked.

So what I have is simple mysql query

$park = $wpdb->get_row("SELECT COUNT(1) FROM wp_richreviews WHERE review_status='1'");

And then print it

if($park)
{
   print_r($park); 
}

Then it will show this

stdClass Object ( [COUNT(1)] => 2 )

But I want to recieve just "2" and not the stdclass object bla bla..

can anyone help me please ? thank you!

RiggsFolly · Accepted Answer · 2016-03-31 15:27:55Z

1

You have made life a little difficult for yourself by not giving the result column a nice easily accessible name

If you change your query so the column has a known name like this

$park = $wpdb->get_row("SELECT COUNT(1) as count 
                        FROM wp_richreviews 
                        WHERE review_status='1'");

then you have a nice easily accessible property called count

echo $park->count;

answered Mar 31, 2016 at 15:27

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

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

2 Comments

Thank you this worked !:) Unfortunely it says I cannot accept your answer, but this worked ! thanks again

You have to wait 20 minutes I believe before you can accept an answer

Jay Blanchard · Accepted Answer · 2016-03-31 15:41:12Z

1

Change your query to:

$park = $wpdb->get_row("SELECT COUNT(1) as count 
                        FROM wp_richreviews WHERE review_status='1'");

and get count value with something like $park['count'];

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

answered Mar 31, 2016 at 15:23

Durga Sharma

235 bronze badges

do you know please how? :)