How to query / DB requests?

Question

what is the correct way to query the a Wordpress database, meaning to pull row and column info, and then place it into a corresponding table in the Wordpress admin?

I'm wanting to do a query similar to that of the "links" section in the Wordpress admin, being able to both "edit" and "delete" the rows/columns individually.

I've already found plenty of articles on setting up tables, and have the edit/delete front end in place, but just need a solid example of how to make a database query pull the info to edit/delete/add the info to the table.

Answer 1

Querying in WordPress is done by using the the wpdb variable. Be sure to always prepare your sql so WP can make it database safe.

Example:

global $wpdb;
$rows = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM `{$wpdb->prefix}TABLE_NAME` WHERE `var` = %d", 1) );

Then you can loop through the data and output it as for example a table (table formatting not included).

foreach($rows as $row) 
{
  echo $row->post_title;
}

Please note that the SQL query above doesn't work because it contains dummy data. Please change it so it fits your needs.