Dataset that contains some quotes:

Add that array to the current user's metadata:

update_usermeta($user_ID, $testkey, $testarray)

That should have just triggered a DB error.

Okay, that's fine. I can just escape the data before it's used:

Add the new array to the current user's metadata:

update_usermeta($user_ID, $testkey, $testarray)

Attempt to retrieve the array from the usermeta:

get_usermeta($user_ID, $testkey)

What the heck? A string? I gave it an array! That's a problem.

Delete the testkey:

query("DELETE FROM $wpdb->usermeta WHERE user_id = '$user_ID' AND meta_key = '$testkey'") ) ?>

escape($meta_value); $cur = $wpdb->get_row("SELECT * FROM $wpdb->usermeta WHERE user_id = '$user_id' AND meta_key = '$meta_key'"); if ( !$cur ) { $wpdb->query("INSERT INTO $wpdb->usermeta ( user_id, meta_key, meta_value ) VALUES ( '$user_id', '$meta_key', '$meta_value' )"); } else if ( $cur->meta_value != $meta_value ) { $wpdb->query("UPDATE $wpdb->usermeta SET meta_value = '$meta_value' WHERE user_id = '$user_id' AND meta_key = '$meta_key'"); } else { return false; } $user = get_userdata($user_id); wp_cache_delete($user_id, 'users'); wp_cache_delete($user->user_login, 'userlogins'); return true; } /** PART TWO **/ function inject_panel2() { global $wpdb; $testarray = array("This is one", "This is 'two'", "This is \"Three'"); $testkey = 'kccricket_bugtest2_20060220'; ?>

Dataset that contains some quotes:

Add that array to the options:

update_option($testkey, $testarray)

Delete the dataset from the cache:

wp_cache_delete($testkey, 'options')

Attempt to retrieve the array from the options:

get_option($testkey)

Works as expected.

Delete the testkey:

delete_option($testkey)