In this article we will see how to get data from database using SQL Query in WordPress.
We are going to use get_results() function to execute the query.
$table_name = 'wp_users'; $results = $wpdb->get_results( " SELECT * FROM $table_name " ); echo "<pre>"; print_r($results); echo "</pre>";
Here in the above example I have gotten data of wp_users table using get_results function.
You can see I have used $wpdb variable.
$wpdp is a database access abstraction class.
Here I have added code and I even haven’t define $dpdb but still I am getting the results because I have added this code in my theme’s function file.
If you will not able to access the $wpdb then you need to assign this as global $wpdb;
If you have any difficulty you can reach out to me through comment.