Updating options via pure SQL is wrong.
-
If you feel you have too many options to use the regular API you probably have too many options at all. A theme should not do the job a plugin can do. In fact, it should do as little as possible and let the user choose a plugin for simple tasks.
Examples are fields for tracking codes or sharing meta data. -
Store your options in one array under a single option name. The API will serialize it for you. Exceptions are options you need on de/activation only like the theme version.
-
If you use the API plugins can hook into
pre_get_option_*and extend or change what you do. Don’t break that, you cannot know what your users need.
Related Posts:
- What is _transient_random_seed for?
- get unserialized array without using get_option()
- $wpdb->get_row() only returns a single row?
- what is the way to see the currently executing query in wordpress?
- Fetch array with $wpdb
- $wpdb->insert() and Values for Datetime Columns?
- $wpdb->last_error doesn’t show the query on error
- Theoretical Multi-Server WordPress Setup with Shared Users
- Delete/replace img tags in post content for auto published posts [closed]
- What does wp_update_post() do that the $wpdb class does not?
- wpdb-> not adding prefix to custom table
- WordPress insert NOW() in TIMESTAMP column returns all zeros
- $wpdb prepare issue with mysql DATE_FORMAT
- How-To: wpdb Insert Record With Date
- How to pass NULL in where array for $wpdb->update
- Get random row from custom table
- store custom WP table names in a global variable
- I am not understandinhg $wpdb->prepare correctly
- Wpdb query for comment meta for current post
- How to save html and text in the database?
- XOR functionality for meta_query
- How to Modify this $wpdb query to accept an array of post statuses
- Using WPDB class
- How can I migrate mysql_fetch_array to $wbpdb?
- WP Sql query multiple where clause
- Problem displaying inserted form
- Get published posts and pages?
- wpdb get_results() and prepare when to use prepare?
- Syntax for $wpdb->prepare when searching in two columns
- Foreach loop using $wpdb not results from rows
- How to get a value-only flat array from $wpdb->get_results when selecting a single column, without foreach()?
- How to Instantiate wpdb Object in New File
- How do you build a wpdb query dynamically?
- Would this WPDB setup result in potential race conditions?
- How to update a row in a table in WordPress
- What’s the proper way to add users to my site in order to test things?
- WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
- Optimizing WordPress Queries – Removing Group By ID
- External DB Connection [closed]
- Codex: Database Description: meaning of Cardinality
- Code only works every other time its run
- Can’t pass variable in wordpress wpdb->get_results
- WordPress db prepare
- How do I count columns on a custom WPDB query?
- how to get db values without using an loop with wpdb->get_results()
- Custom SQL query ORDER BY term_order
- Trouble inserting string containing quotations marks with wpdb in save_post hook
- How to run wp_insert_post() & wpdb on the background?
- Trying to get variable from WP table and toggle its value
- Set MySQL variables in WPDB
- get_results query with accent
- How to prepare an array of values with $wpdb
- Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
- $wpdb->insert() doesnt work anymore
- $wpdb query outputs php code instead of executing it
- wpdb query not working
- Where can I see MySQL hostname and port for wp-config.php
- WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
- Using “->” in a page to exceute $wpdb query gives error
- Exclude specific terms from all queries using posts_where or something similar
- $wpdb->get_results not returning an array
- query a newly created table using $wpdb
- Get all sticky posts from one user through user ID
- WPDB Query Question with Category Only
- wpdb result arrray inside an array
- $wpdb->num_rows doesn’t work
- How can I change my meta_query to SQL wpdb query?
- How capturate wpdb exceptions?
- Limit left join
- “This message was added in version X” showing a later version than current one
- Get records from Formidable Table using $wpdb->get_col
- Prepare WPDB with meta key and meta value
- How to get row value from wpdb
- I am using wpdb but it not working perfectly.but if I dont use form data its work
- wont add form details to database or send me mail
- Create a stored procedure on plugin activation
- Get last element from wpdb as a string
- Missing argument 2 for wpdb::prepare() [duplicate]
- wpdb->update update the entire table instead of one row
- WPDP related functions look to work but they don’t
- Custom database query to validate data
- Save customizer default values to DB on theme activation
- Plugin with connection to database – Single function
- Alter the main search query to search posts by coauthor user name
- Protect custom form from SQL injection
- why nl2br() is adding an extra ?
- How to add more custom fields in user meta table simultaneously
- wpdb->update error
- SQL Query to select post title & post ID from a particular category
- Create Table Failed Column Date DateType
- Using $wpdb to update current post
- Checking if meta_value exists for any user
- Jeditable Plugin working as it should – scope issue?
- Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
- DBDelta: “table doesn’t exist” for a table that was just created
- query using wpdb in wordpress gets me no result
- How do I change the datetime format from ( ‘y-m-d’ ) to ( ‘d m y’ ) [closed]
- Get count of rows based if column exists in two different tables
- Table wont load into WPDB
- WPDB prepare – like % – placeholders?