How To Get Some Data From WordPress Database Using WordPress $wpdb Query?

Question

I am trying to get some data from WordPress database tables in a plugin. For that, I am using the below code...

global $wpdb;
$findID = $wpdb->get_var("SELECT ID FROM wp_posts WHERE post_name = 'hello-world'");
echo $findID;

But it not giving me the post ID in echo? Is there anything wrong...???

I checked again and found that it was my coding problem and after fixing that, the upper one is also working. You can also use the below answer one too... — Muhammad Hassan
– Muhammad Hassan, Commented Sep 29, 2014 at 4:29

Nicolai Grossherr · Accepted Answer · 2014-09-27 17:57:53Z

6

Just to clarify the get_var() method of $wpdb does work just fine in this context:

global $wpdb;
$helloworld_id = $wpdb->get_var("SELECT ID FROM wp_posts WHERE post_name = 'hello-world'");
echo $helloworld_id;

Actually it is more practical in this context, because a single variable is returned, which is what is actually wanted.

answered Sep 27, 2014 at 17:52

Nicolai Grossherr

18.9k8 gold badges65 silver badges111 bronze badges

Muhammad Hassan · Accepted Answer · 2014-09-27 15:00:37Z

3

I found the solution and the correct query to fetch one data from WordPress database is below one.

global $wpdb;
$findID = $wpdb->get_results("SELECT ID FROM wp_posts WHERE post_name = 'hello-world'");
echo $findID[0]->ID;

answered Sep 27, 2014 at 15:00

Muhammad Hassan

5514 gold badges8 silver badges23 bronze badges

2 Answers 2