Add Option if Not Exists

Question

Add Option if Not Exists

Chris

2021年7月28日 12:54

I need to see if an option, and if does, get the value. If not, I need to add it.

The Codex provides:

?php
$option_name = 'myhack_extraction_length' ;
$new_value = '255' ;

if ( get_option( $option_name ) != $new_value ) {
    update_option( $option_name, $new_value );
} else {
    $deprecated = ' ';
    $autoload = 'no';
    add_option( $option_name, $new_value, $deprecated, $autoload );
}

Which supposedly updates the option name myhack_extraction_length with the value 255. If the option does not exist then use add_option and set autoload to no.

However, it seems to me that the second half could be called in two ways, if the option does not exist OR if the new value==the option

Is this correct?

Topic codex options Wordpress

Category Web

T.Todua · Accepted Answer · 2021年7月28日 12:54

I don't recommend to use if (!(get_option("XXXX")) approach to check for existence, as it fails with false/null/0/empty legitimate value.

I suggest:

if (!option_exists("XXXX")) {
     add_option("XXXX", "valueee");
}

code:

public function option_exists($name, $site_wide=false){
    global $wpdb; return $wpdb->query("SELECT * FROM ". ($site_wide ? $wpdb->base_prefix : $wpdb->prefix). "options WHERE option_name ='$name' LIMIT 1");
}

(I had also submitted this feature as CORE request)

PeeR · Accepted Answer · 2019年7月12日 16:03

I struggled a bit with these kind of options management and did it with a different approach...

// create or update the token in DB

    switch ( get_option( 'ngitc_token' ) ) {
        case false: 
            echo "<p>Added token to DB</p>";
            delete_option( 'ngitc_token' ); //get_option() will send false if option doesn't exist OR if it's empty. So I take no chances, I delete it before adding it.
            add_option( 'ngitc_token', $token->token );
            break;
        case $token->token:
            echo "<p>No change to DB</p>";
            break; 
        case true:
            echo "<p>Updated token to DB</p>";
            update_option( 'ngitc_token', $token->token );  
            break;   

    }

@Steve is answering you perfectly, I'm just adding a possibility on how to approach options managing.

Technogeek · Accepted Answer · 2016年6月13日 06:28

I believe that the best approach to this issue is to create IF-ELSE logic like this one:

   if(get_option('some_option')){
         update_option('some_option', 'value_we_want_to_add');
    }
    else {
      add_option('some_option', 'value_we_want_to_add');
    }

Logic: get_option() will return TRUE if that option does exist. In this case we can simply update that option with some value we want to add. This is done by update_option('some_option','value_we_want_to_add'). On the other hand, if some_option doesn't exist, get_option will return FALSE and activate ELSE block. Inside else block we gave instruction to create this "some_option" and assign value we want to it.

Optionally, this logic can be changed to match more advanced requirements.

Paskal Novakov · Accepted Answer · 2016年1月21日 13:30

Try This

Function checking if $arg / string / exist in mySQL.
$arg must be a string / the name of your option /
If the function returns true -> option exist; returns false -> there is no option with this name.

/** * Check If Option Exist; * @param String * @return boolean; */

function exist_option( $arg ) {

    global $wpdb;
    $prefix = $wpdb->prefix;
    $db_options = $prefix.'options';
    $sql_query = 'SELECT * FROM ' . $db_options . ' WHERE option_name LIKE "' . $arg . '"';

    $results = $wpdb->get_results( $sql_query, OBJECT );

    if ( count( $results ) === 0 ) {
        return false;
    } else {
        return true;
    }
}

Example:

var_dump( exist_option( 'your_option' ) );

Result:

true / false

Example: ( create option if not exist ):

if( exist_option( 'your_option' ) == false ) {
    add_option( 'your_option', '255', '', true );
}

And your answer may be is:

$new_value = '255';

if( exist_option( 'myhack_extraction_length' ) == false ) {
    add_option( 'myhack_extraction_length', '255', '', true );
} else {
    if ( get_option( 'myhack_extraction_length' ) == $new_value ) {
        // Your Code Here: or
        return;
    } else {
        update_option( 'myhack_extraction_length', $new_value );
    }
}

Steve · Accepted Answer · 2012年11月5日 15:04

The logic on the IF THEN ELSE does seem a bit wonky. If I'm reading it correctly...

The call to get_option( $option_name ) will return FALSE if the option does not exist or if it has no value.

So the IF would be executed:

when the option doesn't exist and $new_value != FALSE
the option has no value and $new_value != FALSE
the option exists and has a value that is != $new value

The update_option() call would then update the value or create the option with $new_value.

The ELSE would be called if:

the option exists and has the same value as $new_value
the option does not exist and the $new_value == FALSE

s_ha_dum · Accepted Answer · 2012年11月3日 14:19

Is this correct?

If you mean "when does the 'if' execute and when does the 'else' execute, then "No". Look at the condition: if ( get_option( $option_name ) != $new_value ) {

If the option does not exist-- false != '255' is true-- then the first part executes. It also executes if the option exists and the values don't match --'123' != '255' is true.

The else executes only if the values do match-- '255' != '255' is false, so the else part runs. They could match on anything, numbers, strings, booleans-- aka true or false

Add Option if Not Exists

About