As per GentlemanMax’s comment, you’ll want a table.
There’s a really useful guide in the Codex (which also goes into how to do DB upgrades / migrations.)
One thing I’d emphasise: make sure to use $wpdb->prefix
in the table name because not all sites will have tables beginning wp_*
.
Also, if you’re ever planning to distribute your plugins to other people, remember not every WordPress cloud hosting services will allow their customers to use custom tables (some of the larger ones allow the standard WordPress tables or preapproved plugins only – which is irritating but worth bearing in mind.)
Related Posts:
- How to auto login user again after change user_login
- How to Join two tables from separate databases within WordPress
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- WPDB: how to get the value of a field in a custom database table
- How to generate page content from database the right way?
- phpMyAdmin displays error when importing database
- Transferring working local PHP site to wordpress – with database (MySQL)
- Databases – Submitting data from inputs to database [closed]
- Is it best to avoid using $wpdb for security issues?
- Lost in trying to create user database system
- Filter results from a serialized string to use on statistics
- wordpress site – using custom database and PHP
- add role on WordPress in PHP on a second database
- Front end/Database connection in WP
- direct query to post_meta table
- can’t delete a row from post_meta table
- Querying multiple meta_keys in WordPress SQL query
- Retrieve data from external database and insert back in
- How to check if image is already stored in a site’s post database? (network)
- How to get the list of WooCommerce product image of a certain category from database?
- Alter query on edit.php
- Changing user_nicename
- WordPress will not operate correctly
- Import 10,000 Users into WordPress WITH a specific ID for each user
- if statement on database query
- Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
- my function doesn’t return my post from today
- Enhanced WordPress Search
- register_activation_hook isn’t adding table to DB
- Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
- Preferred Method of debugging a wordpress SQL calls?
- How to get the POST TITLE using the POST ID?
- Why is the post meta[] empty when I make a call to the wordpress rest api?
- WordPress Scheduled Event Request Blocking
- Trying to establish connection to External Database
- How to insert a single row to WP database table?
- Importing Geo data into wordpress database
- $wpdb->update with multiple parameters gives error
- wp search-replace on database returns PHP fatal error: Array and string offset access syntax with curly braces is no longer supported
- Is it possible to create a wordpress database with php code?
- Store a default value for a transient on plugin activation
- Split reads to a different connection string
- custom user role wordpress – grant guest access to edit.php without insert/update/delete
- inserting a post from an extern php file but post content doesn’t show on wp site
- Not connecting to database in file with multiple MySQL connections
- Building a REST API for your web app exposes primary keys of DB records?
- Saving data from custom form in wordpress database
- wpdb Cannot Update column in Database
- Pull MySQL data from multiple tables and merge into 1 PHP array
- Get wp_current_user_id using PHP and MySQL
- WPDB – Read and write value from / to database
- How do I make this Metabox show current DB value?
- How to Generate a list of Most Commented post?
- Adding data to custom wordpress database table
- mySQL queries are executed twice on wordpress website
- select a single val though a table in wordpress
- quotes problem in very simple sql
- Add posts to custom table in database instead of wp_posts
- get_terms with specific id order
- Tracking Visitor LatLng with WordPress using JS, PHP. How to put data which was extract using JS into DB
- $_POST returning empty values
- How to send custom form submissions to WordPress Database?
- Submiting with problems on one of the options php wprdpress
- Confuse between forms and tables
- code that I can run, or a plug in to show what sql tables something pulls information from
- Adding column to wpex_users
- Using wpdb to connect to a different database is not working
- Editing the term_order field
- How do I get data from my database into my Custom Export Field
- WordPress database error only while loading page for 1st time
- Multiple WordPress sites with different theme and plugin sharing the same content
- How to grab data from input and store it into custom table in database?
- custom search query database in child theme
- Insert data from form to database
- How do I fetch a data from an external database into my wordpress homepage
- Full search and replace isn’t enough to make all pictures to be loaded with https
- Generate random access token to a post page
- Plugin Modification Change Functionality For Logged User Only
- I changed the password for the database user of my website, updated wp-config.php and wordpress asks to be reinstalled
- I want to use wordpress database in android app using json encode?
- Child theme functions.php file change database entries
- Can form entries from a WordPress form go to a database
- Conditional statement within WP SQL query
- How to merge 2 WordPress sites?
- two wordpress sites, two themes, one database, same content
- Insert double entry in DB
- Check if values exists DB
- MySQL database migration to WordPress
- Host does not allow remote connection, so how do I transfer data to my WordPress site?
- MySQL Engine vs. Charset
- Custom query_posts() parameter
- How to check if a value exists in one of two database tables
- How to edit the default database of WordPress [closed]
- Insert into db with foreach problem
- notify users when changed database
- Display total count of products in orders of a specific order status
- save array of objects with update_option
- Execute multiple PHP Snippets causes error?
- How to sort search result by post_title, then by post_content
- Can’t insert into a database wordpress