构建一个Wordpress插件
问题描述:
我正在制作一个wordpress插件,并且我使用查询从数据库获取所需的所有数据,但之后我无法弄清楚如何解析它。构建一个Wordpress插件
我的查询是:
$dbContent = $wpdb->get_results("SELECT option_id, option_name, option_value FROM wp_options WHERE option_name LIKE '%Customizer%'");
,我展示它使用:
$retval .= "<pre>";
$retval .= print_r($dbContent);
$retval .= "</pre>";
我得到这个,我认为是一个数组的数组:
Array ([0] => stdClass Object ([option_id] => 119587 [option_name] => bfhCustomizer_price_1 [option_value] => 2.85) [1] => stdClass Object ([option_id] => 119584 [option_name] => bfhCustomizer_option1 [option_value] => Leave-In Moisturizer) [2] => stdClass Object ([option_id] => 119585 [option_name] => bfhCustomizer_option2 [option_value] => Conditioner/Cleansing Conditioner) [3] => stdClass Object ([option_id] => 119586 [option_name] => bfhCustomizer_option3 [option_value] => Pure Oil Mixture) [4] => stdClass Object ([option_id] => 119588 [option_name] => bfhCustomizer_price_2 [option_value] => 3.45) [5] => stdClass Object ([option_id] => 119589 [option_name] => bfhCustomizer_price_3 [option_value] => 1.99) [6] => stdClass Object ([option_id] => etc...
莫非
有人告诉我如何正确访问这个?我试图用类似$dbContent->option_id
或$dbContent['option_id']
但既不工作,我在这里失去了现在
答
看起来你有stdClass的对象的数组,这样你就可以像这样访问:
$id = $dbContent[0]->option_id;
// or in a loop
foreach($dbContent as $index => $result) {
echo $result->option_id;
echo $result->option_name;
// etc
}