Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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);
share|improve this question
    
You are familiar with $wpdb. Check the Codex. Everything you need for this is there. –  s_ha_dum Mar 9 '13 at 22:26
add comment

1 Answer

up vote 1 down vote accepted

$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 );
share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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