WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 0 down vote accepted

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:

  1. when the option doesn't exist and $new_value != FALSE
  2. the option has no value and $new_value != FALSE
  3. 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:

  1. the option exists and has the same value as $new_value
  2. the option does not exist and the $new_value == FALSE
share|improve this answer

This is simpler- check if option doesnt exist (or empty). i.e.:

if(!get_option('speccc_nameee')){
    update_option('speccc_nameee', 'first_default_value');
}
share|improve this answer
1  
Please add an explanation to your answer: why could that solve the problem? – toscho Mar 13 '14 at 19:57

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

share|improve this answer

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.

share|improve this answer

Try This

  1. Function checking if $arg / string / exist in mySQL.

  2. $arg must be a string / the name of your option /

  3. 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 );
    }
}
share|improve this answer
1  
Please do not just dump code, but explain what you are doing and what it is good for - thanks. – ialocin Jan 20 at 15:06
    
downvoted as there is no reason at all to directly query the DB. In any case update_option will add the option if it do not exist so the whole code is pointless. – Mark Kaplun Jan 21 at 13:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.