PHP MySQL / WordPress Function / Ninja Forms

Question

我正在尝试使用对外部数据库连接的查询和函数中的自定义代码.php，使用WordPress插件"Ninja Forms"填充供应商名称的下拉列表。

表单上的下拉列表似乎填充了正确数量的结果(即 800+ 项(，但显示 [对象对象] 而不是供应商名称。

下面的代码是我开始的地方，任何关于添加查询的供应商名称 (SUP_Name( 而不是 [对象对象] 的支持都将非常有用。

add_filter('ninja_forms_render_options','my_pre_population_callback', 10, 2);
function my_pre_population_callback($options, $settings) {
if( $settings['key'] == 'supplier_list' ) {
$connection = mysqli_connect( "IP:port", "username", "password", "db" );
if (!$connection) {  die('Not connected : ' . mysqli_error());}
$db_selected = mysqli_select_db($connection,"db");
if (!$db_selected) {
die ('Can't use db : ' . mysqli_error());
}
$query = "SELECT SUP_Name FROM db.sup_supplier";
$results = mysqli_query($connection,$query);
if (!$results) {
die('Invalid query: ' . mysqli_error());
}
$options = array(); 
$options[] = array("label" => "Select the supplier", "value" => "");
foreach ($results as $result) {
$options[] = array("label" => $result, "value" => $result);
}
wp_reset_postdata();
}
return $options;
mysqli_close($con);
}

提前致谢

Answer 1

我已经设法实现了我所追求的

$options = array();
while($row = mysqli_fetch_assoc($results))
{
$options[] = array (
'label' => $row['SUP_Name'],
'value' => $row['SUP_Name'] );
}