The DB_
constant prefix in WordPress is generally considered reserved for DB_NAME
, DB_HOST
, DB_USER
and DB_PASS
. Using it for plugin-specific constants is, in my opinion, not a great idea. The only implication it might pose is if other plugins try to use the constants, but that’s purely theoretical.
The proper way to do this is to store the table names in the WPDB object stored in the global $wpdb
.
global $wpdb;
if ( ! isset( $wpdb->myplugin_artists ) && ! isset( $wpdb->myplugin_releases ) ) {
$wpdb->myplugin_artists = $wpdb->prefix . 'myplugin_artists';
$wpdb->myplugin_releases = $wpdb->prefix . 'myplugin_releases';
}
It’s important to use a proper prefix (in this case myplugin_
for your plugin). For example, for Advanced Custom Fields, this is usually acf_
(more on prefixing).
Related Posts:
- $wpdb->get_row() only returns a single row?
- How to parse row results from $wpdb -> get_results
- what is the way to see the currently executing query in wordpress?
- Fetch array with $wpdb
- $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
- wpdb prepare: passing varible number of fields as second argument
- I am not understandinhg $wpdb->prepare correctly
- Wpdb query for comment meta for current post
- How to Modify this $wpdb query to accept an array of post statuses
- Using WPDB class
- WPDB Update using Conditional Arrays
- $wpdb->get_results returns empty but value exists
- WP Sql query multiple where clause
- Problem displaying inserted form
- What is _transient_random_seed for?
- Get published posts and pages?
- Call External Object in Class Function During Callback
- 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
- Confused by $wpdb->prepare
- 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?
- Optimizing WordPress Queries – Removing Group By ID
- External DB Connection [closed]
- How to get entry by title by using wpdb
- 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 left join meta in queries [closed]
- 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?
- how to list all post that are in the custom taxonomy using $wpdb
- 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
- 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
- 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 ?
- $wpdb->get_results in not an array
- How to make iteration on wpdb->update or query statement?
- How to add more custom fields in user meta table simultaneously
- wpdb->update error
- get unserialized array without using get_option()
- 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
- 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
- Get count of rows based if column exists in two different tables
- Table wont load into WPDB
- WPDB prepare – like % – placeholders?