I’m quite new to wordpress.
I’m trying to build a tableview within a wordpress page. Therfore I need a custom SQL Query to my MySQL Database.
- Query data from my MySQL Database
- Get the result somehow in a HTML format in order to display it in a table view within a wordpress page.
My question is:
How can I use the wpdb_class in a wordpress page when it is not an option to put php code in a page?
The
wpdb
object can be used to run arbitrary queries against the WordPress database. Let’s say you want to list the most recent 4 posts:The
$wpdb->posts
variable will output the table name for posts. It’s usuallywp_posts
, but if you’re using a custom database prefix this could be different.However, if you’re trying to grab post data (or custom post data or meta information or user data or … anything built-in to WordPress), you should really be using
WP_Query
.Here’s the same query above, re-written for
WP_Query
:The advantage of using
WP_Query
is that it will automatically join against the post meta table and return an array ofWP_Post
objects that you can work with and loop through.Define global variable $wpdb then make custom query and pass $wpdb->get_results();