构建Wordpress插件

Question

我正在制作一个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']这样的东西，但都不起作用，我现在迷路了

Answer 1

看起来您有一个stdClass对象数组，所以您可以像这样访问它：

$id = $dbContent[0]->option_id;

// or in a loop

foreach($dbContent as $index => $result) {
    echo $result->option_id;
    echo $result->option_name;
    // etc
}