如何从$ wpdb-> get_results

 foreach( $wpdb->get_results("SELECT * FROM your_table_name WHERE id LIKE' . $id . ';") as $key => $row) {
// each column in your row will be accessible like this
$my_column = $row->column_name;}
 

更多信息此处

foreach( $wpdb->get_results("SELECT * FROM your_table_name WHERE id LIKE' . $id . ';") as $key => $row) {
// each column in your row will be accessible like this
$my_column = $row->column_name;}

More info here

始终尝试WordPress Codex: http://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results

本质上给出了默认语法,此处的$ row变量是一个包含您的结果的对象.您可以交替指定结果的类型(数字数组,关联数组).

假设只有一个结果,那么$ row->id和$ row->name应该会为您提供信息.

如果返回不只一个结果,则希望遍历对象中的条目.

如果只希望返回一行,请尝试使用$ wpdb->get_row http://codex.wordpress.org/Class_Reference/wpdb#SELECT_a_Row

Always Try the WordPress Codex: http://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results

Essentially given the default syntax, the variable $row here is an object containing your results. You could alternately specify the TYPE of result (numeric array, associative array).

Assuming just one result, then $row->id and $row->name should give you the information.

If you get back more than one result, you'd want to loop over the entries in the object.

If you are expecting just one row back, then try using $wpdb->get_row http://codex.wordpress.org/Class_Reference/wpdb#SELECT_a_Row

用作关联数组:

 $obj=[];
$rows =  $wpdb->get_results( 'SELECT * FROM `tbl_name` WHERE `id` = '.$obj_id , ARRAY_A);
foreach($rows as $row){  $obj=$row; break; }

// $obj is now the selected row if a match was found
 

用法

 $something = $obj['column_name'];
foreach($obj as $col => $val)
    echo $col . ': ' . $val . PHP_EOL . '<br />';
 

要获取其他格式,只需根据ARRAY_A "> $wpdb->get_results() 的文档. Pippin的答案适用于大多数对象.

要将一行用作数字索引数组

 $rows =  $wpdb->get_results( 'SELECT * FROM `tbl_name` WHERE `id` = '.$obj_id , ARRAY_N);
foreach($rows as $row){  $obj=$row; break; }

//Usage
foreach($obj as $col_value) echo $col_value . ' ';
 

要使用其键是数据库中的主键的数组中的一行(通常是id列).可能比关联数组方法更有效.

 $rows =  $wpdb->get_results( 'SELECT * FROM `tbl_name` WHERE `id` = '.$obj_id ,  OBJECT_K);
$obj = $rows[ $obj_id ];

//Usage

$something = $obj->column_name;

//Remember you can loop over objects too
foreach($obj as $col => $val)
    echo $col . ': ' . $val . PHP_EOL;
 

To use as an associative array:

$obj=[];
$rows =  $wpdb->get_results( 'SELECT * FROM `tbl_name` WHERE `id` = '.$obj_id , ARRAY_A);
foreach($rows as $row){  $obj=$row; break; }

// $obj is now the selected row if a match was found

Usage

$something = $obj['column_name'];
foreach($obj as $col => $val)
    echo $col . ': ' . $val . PHP_EOL . '<br />';

To get other formats, simply change ARRAY_A based on the documentation for $wpdb->get_results(). Pippin's answer is appropriate for most object use.

To use one row as an numerically indexed array

$rows =  $wpdb->get_results( 'SELECT * FROM `tbl_name` WHERE `id` = '.$obj_id , ARRAY_N);
foreach($rows as $row){  $obj=$row; break; }

//Usage
foreach($obj as $col_value) echo $col_value . ' ';

To use one row in an array whose keys are the primary key from your database(often an id column). Possibly more efficient than the associative array method.

$rows =  $wpdb->get_results( 'SELECT * FROM `tbl_name` WHERE `id` = '.$obj_id ,  OBJECT_K);
$obj = $rows[ $obj_id ];

//Usage

$something = $obj->column_name;

//Remember you can loop over objects too
foreach($obj as $col => $val)
    echo $col . ': ' . $val . PHP_EOL;

此代码最适合我:

 global $wpdb;
$table_name = "my_table_name";
$myrows = $wpdb->get_results( "SELECT `id`, `name` FROM ".$table_name);
    foreach ($myrows as $details) {
      echo $details->id;
      echo $details->name;}    
 

This code work perfect for me:

global $wpdb;
$table_name = "my_table_name";
$myrows = $wpdb->get_results( "SELECT `id`, `name` FROM ".$table_name);
    foreach ($myrows as $details) {
      echo $details->id;
      echo $details->name;}