Dynamic select box field values from another database

• microtag

• November 14, 2014 at 1:34 am

I’d like to know if I can populate a select box dynamically from another database.

Thanks.
Regards,
Microtag

• microtag

• November 16, 2014 at 11:28 pm

function dynamic_dropdown( $field ){

$wpdbtest_otherdb = new wpdb('password', 'user', 'db', 'host');
$wpdbtest_otherdb->show_errors();
$user_logins = $wpdbtest_otherdb->get_results("SELECT * FROM wp_users");

	if(!empty($user_logins)){
		foreach($user_logins as $user_login){
			$field['choices'][$user_login->ID] = $user_login->display_name;
		}
	}

    return $field;
}
 
add_filter('acf/load_field/key=field_xxxxxxx', 'dynamic_dropdown');