Best possible way to get all options

Question

I need to provide a list of all options set via plugins etc to remote calls. There is a plugin WP API Options but it hardly does the job.

There are two possible ways (that I know of) to get a list of all options set in the blog/site:

• Use $wpdb to run a query like so:

  $option_names = $wpdb->get_col( "SELECT DISTINCT option_name FROM $wpdb->options WHERE option_name NOT LIKE '_transient_%'" );

• Use wp_load_alloptions()

Which one of these two would be the best way to retrieve all the options? Is there a cleaner way than either of these two?

Edit: In a perfect world, I would like to use an inbuilt function for this, instead of writing MySql queries. Also, by all options I am implying any option set by a plugin using add_option or update_option functions.

Answer 1

I think it is always better to use the API, the functions of WP in this context. The function wp_load_alloptions() is under maintain and a custom select must always tested and maintain. Also the function use the Cache, if the installation support this. A good point for performance. The function supports also the Multisite installation, maybe this also a point for maintain effort.

But the function have no filters to enhance the sql statement or output. That's the point, that you must filter after the returned values.

Answer 2

There is a solution to query all the options that can be set by the plugin, if these are registered settings.

I assume you register the settings as follows:

register_setting( 'plugin-settings-group', 'plugin_option_1' );
register_setting( 'plugin-settings-group', 'plugin_option_2' );

Then you can use the following function:

/**
 * Get all plugin option name
 * @return array
 */
function wp_nq2vjrn_get_all_plugin_option_name() {
    global $wp_registered_settings;

    $plugin_settings = array_filter( $wp_registered_settings, function ( $setting ) {
        return 'plugin-settings-group' == $setting['group'];
    } );

    return array_keys( $plugin_settings );
}

The function returns the names of the options, which are stored in the array id, so I use the array_keys() function.

The big advantage of this type of query is that you can not only query the name of the option, but also access other parameters of the setting, such as type or description. In this case, use return $plugin_settings;, for example:

/**
 * Get all plugin settings
 * @return array
 */
function wp_nq2vjrn_get_all_plugin_settings() {
    global $wp_registered_settings;

    $plugin_settings = array_filter( $wp_registered_settings, function ( $setting ) {
        return 'plugin-settings-group' == $setting['group'];
    } );

    return $plugin_settings;
}