我有以下几点：
$query = \'SELECT * FROM wp_pod_tbl_add_questions WHERE id LIKE \'. $id;
$row = $wpdb -> get_results($query);
如何解析来自$wpdb->GET_RESULTS的行结果
4 个回复
最合适的回答,由SO网友:Pippin 整理而成
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
SO网友:Garet Claborn
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
$something = $obj[\'column_name\'];
foreach($obj as $col => $val)
echo $col . \': \' . $val . PHP_EOL . \'<br />\';
ARRAY_A 基于documentation for $wpdb->get_results(). 皮平的回答适用于大多数对象使用。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 . \' \';
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;
SO网友:Jismon Thomas
此代码非常适合我：
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;}
SO网友:Jeff Rose
始终尝试WordPress Codex：http://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results
基本上给定了默认语法，这里的变量$row是一个包含结果的对象。您也可以指定结果的类型（数字数组、关联数组）。
假设只有一个结果，那么$row->id和$row->name应该为您提供信息。
如果返回多个结果，则需要循环对象中的条目。
如果您只希望返回一行，请尝试使用$wpdb->get\\u rowhttp://codex.wordpress.org/Class_Reference/wpdb#SELECT_a_Row
结束