Using custom sql query in wp_query function

People asked me fetching data from wordpress database with simple database query. You can use get_results() method for custom sql query in wp_query function.

Using custom sql query in wp_query function

Is this facility provided by wordpress API. Yes, that is provided by wordpress api. You just need to use the get_results() method. Here I am going to give some example about using the custom sql query in wp_query method.

You need to define the gobal $wpdb variable that important in your code. here is working example for fetching the posts.

1global $wpdb;
2 
3$querystr = "SELECT wp_posts.* FROM $wpdb->posts wp_posts, $wpdb->postmeta
4WHERE wp_posts.post_status = 'publish' AND wp_posts.post_type = 'post'
5ORDER BY wp_posts.post_date DESC LIMIT 10";
6$pageposts = $wpdb->get_results($querystr, OBJECT);

For fetching the Admin or user information thorough query use following code. following code is useful for fetching the single record or row.

1$querystr = "SELECT wp_users.* FROM $wpdb->users
2WHERE wp_users.user_email = 'info@domain.com' ";
3$userinfo = $wpdb->get_row($querystr);

For detail information you should use the following URL:

http://codex.wordpress.org/Function_Reference/wpdb_Class

Using custom sql query in wp_query function

Published by

Purab

I am Purab from India, Software development is my profession and teaching is my passion. Programmers blog dedicated to the JAVA, Python, PHP, DevOps and Opensource Frameworks. Purab's Github Repo Youtube Chanel Video Tutorials Connect to on LinkedIn View all posts by Purab

3 thoughts on “Using custom sql query in wp_query function”

useful tip for wordpress plugin developer

So this is returning an entire HTML webpage for me via my AJAX call. I’m also aiming to make a standard JSON call with an SQL query like this. Any advice would be appreciated.

Purab Kharat says:

January 30, 2015 at 8:40 am

Use JSON API wordpress plugin for this.

Reply