How can I take my table I created like this:

global $wpdb; //Get all the wordpress database stuff
$table_prefix = $wpdb->base_prefix; //Get the global prefix for all sites (on a multisite installation)
$table_name = $table_prefix.'wpaa';//Add   wpaa   behind the prefix 

$sql = "CREATE TABLE IF NOT EXISTS `".$table_name."` (....) "; //Create table and its rows. (Rows are ...'d out)

require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); //Require something you have to include
dbDelta( $sql ); //Make the actual query

and get all the data out from it in form of an array.

I know how I would do in regular PHP (without wordpress):

$sql = 'SELECT id,foo,bar FROM wp_wpaa';
$result = mysql_query($sql) or die('Error at looking up in database');
$array = mysql_fetch_array($result);
  • You are familiar with $wpdb. Check the Codex. Everything you need for this is there. – s_ha_dum Mar 9 '13 at 22:26

$wpdb->get_results(); has a second parameter for the return format:

 * Retrieve an entire SQL result set from the database (i.e., many rows)
 * Executes a SQL query and returns the entire SQL result.
 * @since 0.71
 * @param string $query SQL query.
 * @param string $output Optional. 
 * Any of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K constants. 
 * With one of the first three, return an array of rows indexed from 0 by SQL 
 * result row number.
 *  Each row is an associative array (column => value, ...), a numerically 
 *      indexed array (0 => value, ...), or an object. ( ->column = value ), 
 *      respectively.
 *  With OBJECT_K, return an associative array of row objects keyed by the 
 *      value of each row's first column's value. Duplicate keys are discarded.
 * @return mixed Database query results
function get_results( $query = null, $output = OBJECT ) {

So this will return an array:

$result = $wpdb->get_results( $sql, ARRAY_A );
| improve this answer | |
  • Tank you! I just didn't know how to get the output as an array – LukasFT Mar 10 '13 at 9:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.