The Options API is a simple and standardized way of storing data in the database. The API makes it easy to create, access, update, and delete options.

learn more… | top users | synonyms

18
votes
2answers
3k views

Are all options loaded to memory on each request?

Are all options variables fetched from the database and loaded to cache on each request?
10
votes
2answers
2k views

How come `wp_options` table does not have an index on `autoload`?

In the beginning of each page served by WordPress, there is a MySQL call to fetch options: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'; Because there's no index on ...
10
votes
1answer
959 views

Using jQuery to delete data stored in wp_options

I wonder if anyone could advise me further on my problem. Part of my plugin stores log files for debugging purposes. I have successfully displayed them in a (div#log) in my admin page using jquery ...
9
votes
4answers
213 views

This CSS Stuffing Works, But Is This A Good Practice?

I am trying to include a dynamic css in my plugin, I have been searching anywhere but doesn't find any case that is similar to what I do. And what I use to do it is by adding a css file directly into ...
6
votes
3answers
161 views

Where to store plugin settings fields

I am developing plugin right now, and I have one questions about best practices and conventions. What I need ? My plugin is going to store some predefined object, list of objects (or just ...
6
votes
1answer
2k views

Best practices for a Style/CSS based theme options page?

I would like to create a theme options page based only on changing the site wide CSS styling. For instance body/container background colors, font-sizes, font colors, etc. I have accomplished this by ...
5
votes
2answers
9k views

Slow Query for the wp_options table

I have been tracking the slow queries log of the WP based site (with the default value of the a long_query_time set to 10), and I have noticed that the following query is often getting logged - # ...
4
votes
5answers
14k views

Will it break my site if I delete all transient records in wp_options table?

My site currently has an outrageous 500k+ transient records in the wp_options table. This causes the table to be crashed frequently and so be my site. I thought transient records will all expired ...
4
votes
2answers
536 views

What is the advantage of the wp_options design pattern?

As we all know, a design pattern that is used frequently in Wordpress' DB code is the idea of persisting data for a particular object (blog/post/comment), indexed with a particular name or key. We ...
3
votes
2answers
3k views

Transient RSS feeds in wp_options not removed automatically?

I just noticed 55.000 entries(!) in my wp_options table. I had not been there for a while. So I ran: delete from `wp_options` where `option_name` like '_transient_timeout_rss%' delete from `...
3
votes
2answers
4k views

How to change option recently_edited?

WP recently_edited option can be very useful - it tracks last 5 files that you've made changes to. Only problem is - well, that's all, 5 files. What if I've been made numerous changes to Wordpress ...
3
votes
1answer
720 views

Site Title and Tagline in Theme Options Page

I'm using the Options Framework Theme to put together an options page. The user(s) I'm building this for would like to be able to edit a few settings directly from this page, including of which - the ...
3
votes
1answer
302 views

wp_options table value

I am trying to understand a wordpress behaviour. When I add a tag in the admin panel mysql does a sequence of queries. Essentially: update wp_terms update wp_term_taxonomy and udate wp_options with ...
3
votes
2answers
912 views

How do you permanently remove default rewrite rules from the wp_options table?

We have tons of rewrite rules saved in our wp_options table and I'd like to permanently remove any entries that we're not using on our site (such as comment feeds, page attachments, etc.). What's the ...
3
votes
1answer
71 views

Environment Specific Options Token

Is it possible to add a token to any wp-option that could be replaced on get where the token being defined in a plugin’s option or the configure file? E.g. http://[[[env_token]]].sitename.com/some-...
3
votes
2answers
49 views

How do I output a database option that is an array into a get_posts array?

This must be fairly simple, but I'm puzzled. And I may be going about it backwards. How do I output a database option that is an array into a get_posts array? I have an option in the database that ...
3
votes
1answer
189 views

Site Title and Tagline in Pagelines DMS Options Panel

I'm using the Pagelines DMS Theme and I'm wanting to extend the functionality of the front end admin panel. The user(s) I'm building this for would like to be able to edit a few settings directly from ...
2
votes
1answer
1k views

How to properly sanitize strings for update_option()

I've tried to import an option value via update_options($name, $value) where $value has special characters (like apostrophe's for example) and I've noticed that the apostrophe gets stripped out of the ...
2
votes
1answer
2k views

Delete option value from array using update_option()

I have a user profile field which subscribes the user to forum posts by email. This adds the user's email address to an array in wp-options. Naturally I want the user to be able to unsubscribe, in ...
2
votes
1answer
217 views

Deploying Updated or New Plugins That Modify the wp_options Table

I have a WordPress site under local version control with Git. I deploy it to the production server using Capistrano. For the initial deployment, I manually import the SQL database to the production ...
1
vote
4answers
794 views

How To View Site from Non-Logged-In User's Perspective

I am working on anew blog. I am logged in as administrator, and above every post there is a option to 'edit this entry'. Can I have WordPress set up so that even is I am logged in as administrator, I ...
1
vote
1answer
3k views

Working with an Array inside Your Theme Options Array - Multiple Values

I apologize if this is covered extensively elsewhere, I'm not sure how to phrase my searches on the topic. Basically, instead of the following standard code to store data in WP-options... $options = ...
1
vote
4answers
124 views

Cleaning “cron” from options table, will affect anything?

I have some scheduled events in my WordPress site. For that I use a cron job, so it has created an option in the wp_options table. After some days, my site is getting slow. When I check my database, ...
1
vote
1answer
34 views

Is it possible to sort metabox teaxtarea values?

Textarea is on an options page, is it possible to sort the values within that textarea by alpha? I looked in the Codex but do not see any mention of sorting these values.
1
vote
1answer
67 views

Storing HTML in wp_options

I'm giving my users the option to store HTML in an option with a wp_editor(), using the wp settings api to handle the form. I currently do not apply any data sanatization to it, but realize I probably ...
1
vote
1answer
924 views

What is _transient_random_seed for?

This is a very short question. _transient_random_seed is in wp_options. What is it for?
1
vote
1answer
1k views

Save wp_editor() content as option

I'm having some troubles with a extra feature i'm writing for my theme. The admin should be able to make some special posts, those posts are stored as an option. The options are atored as an array ...
1
vote
1answer
1k views

Wordpress Options Page not working

So, I need to add a custom options page, and based on as many tutorials I could find, I came up with the following code to create an officers & chairs options page for my group, mainly, so I can ...
1
vote
2answers
4k views

Some Plugin Settings Are Kept After Removal and Reinstall of the Plugin

I have uninstalled and then reinstalled all my plugins hoping to restore my WordPress installation to its original state because I have problem with the funtion of RevieAzon plugin. For example, ...
1
vote
1answer
125 views

Are there risks associated with using wp_options table using wpdb to update theme options

I am making a theme and it has so many options that need to be updated via jquery's ajax.Having looked at ways of updating wp_options via ajax,i have hypothesised that updating the wp_options table ...
1
vote
2answers
5k views

clean wp_options table unused rows

In my Wordpress Blog site i have installed too much plugin and remove also many plugins. In database table "wp_options" size increases approx 13MB and there are many rows which are unused at this time....
1
vote
1answer
702 views

Wordpress Plugin Dev: Using array for WP options

I am busy dabbling with writing a WP plugin and hitting a bit of a problem. I believe its best practice to store wp options to an array rather than individually which is great no probs. I have two ...
1
vote
1answer
265 views

get_option() is not working even db contains the corresponding option_name and option_value

First of all, this is not a plugin specific problem. I wonder why this might happen? I am using @bainternet's Tax Meta Class for saving Taxonomy Meta using the options table. I uploaded my contents ...
1
vote
1answer
91 views

Creating a one click demo importer

edit: I've re-written this because it is unclear, apologies it was written rushed on a Friday afternoon. Wordpress has import/export functionality for posts within wordpress, I am a theme developer ...
1
vote
2answers
45 views

Would it be dangerous to send all the wp_options to javascript file?

I've noticed that wordpress allows me to send the wordpress options to javascript via wp_localize_script: wp_localize_script( $this->plugin_slug . '-plugin-script', 'wp_options', ...
1
vote
1answer
2k views

wp_user_roles and Advanced Manipulation

I removed a line from my wp_user_roles to manually remove a role I had created and now the sites administration gives me an "You do not have sufficient permissions to access this page." error. I ...
1
vote
1answer
36 views

Editing options pages?

I'm trying to find a way of adding a single checkbox to one of the existing options pages, most likely options-reading.php programmatically. Unfortunately, I haven't found any good references on this. ...
1
vote
1answer
3k views

store simple data in get_option()

I am trying to store simple data, a few links inside wp_options. Basically using the following way: update_option( 'simple_links', '<a href="">link 1</a>' ); my question is if it is ...
1
vote
2answers
298 views

Help running a MySQL query to update all wp_#_options tables in a Multisite install

I'd like to run a query through my WordPress database that updates the blog_public values on all individual sites. I'm stuck on how to have the statement look for wp_2_options, wp_3_options, etc. I ...
1
vote
1answer
163 views

Classes and functions involved in serialization and unserialization

I want to know all the classes and functions(individual .php files) in a wordpress installation that handle serialization and unserialization.
1
vote
1answer
69 views

Best possible way to get all options

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 ...
1
vote
1answer
49 views

Character Encoding for wp_options

I've been looking for a solution to my problem for a while now. Under my wp_options page I have the following serialized entry saved: a:17:{s:11:"date_format";s:5:"d/m/Y";s:15:"currency_symbol";s:1:"...
1
vote
0answers
11 views

Why is MySQL receiving such a large serialized object?

I have gotten a 20GB error log that has an entry of repetitive serialized objects that look like this: a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:0:{}}}i:1440184624;a:1:{s:32:\"...
1
vote
0answers
78 views

Cannot update my options using wp_ajax

I have implemented wp_ajax in on my options page but the value of my options are not getting saved or updated. Here is my form: public function email_settings_form(){ // Set class property $...
1
vote
0answers
37 views

update object options on option form

I have an object on an option called 'option_voc'. Now I would like to update only one field of this object through form i created on menu page i created (The plugin's settings page). I do not find ...
1
vote
0answers
443 views

Wordpress Deadlock Error

I see more of this error these days in error_log. I see that someone asked this question here a year ago but no solution. Please advise what is causing this issue. Already, tried deactivating some ...
1
vote
0answers
49 views

Saving plugin options page

As I understood, default mechanism of saving options on plugin admin settings page (submitting form to options.php) allows to update only WordPress options (get_option, etc). But I have 2 values to ...
1
vote
1answer
62 views

Does auto_load to 'no' in wp_options improve performance

I am trying to improve the performance of a wordpress based blog. I am looking at wp_options table and am thinking to set the column auto_load to 'no'. Does it have any side-effect on the site ...
1
vote
0answers
13 views

After migration of an old WP blog on my local web server I obtain white screen, why? is it a wp_options DB table problem? [duplicate]

I am pretty new in WP (I came from Joomla) and I am finding some difficulties in the migration of an old WP website (made inWP 3.5) on my local web server. I have performed the following operation: ...
1
vote
4answers
650 views

Updating wp_options with an array on save_post results in duplicated entries

I'm not entirely sure this is Wordpress' fault, but I figure I'd ask anyway and see if anyone else has experienced any problems like this before. I'm trying to save an array to a wp_options table row....