WordPress already has both user and post meta data tables, and associated API for handling the data. Storing an array of post IDs for each user in user meta sounds like it would work for your application.
Related Posts:
- WordPress Unit Testing – Cannot Create Tables
- Using wpdb to connect to a separate database
- get_results using wpdb
- Get error messages when $wpdb->insert() returns false?
- Detecting errors generated by $wpdb->get_results()
- Does dbDelta delete columns as well?
- wpdb update add current timestamp not working
- Insert data in database using form
- Why does $wpdb return strings for mysql integer values?
- $wpdb->prepare() warning in WordPress 3.5
- When is it appropriate to create a new table in the WordPress database?
- Inserting data into custom tables
- How might I retrieve a featured post image from an external WP site and display it as a link back?
- Export wordpress table to excel
- How to close wpdb connection? [duplicate]
- Inserting Post Meta From SQL
- Why does dbDelta() not catch MysqlErrors?
- BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
- What causes the “max_user_connections” warning on WordPress frontend?
- $wpdb variable throw this error Call to a member function get_results() on a non-object in
- Safe way to find last inserted id in a table?
- stdObject stored in database. How does one convert it to usable format?
- Database slowdown after update to 3.4.1
- Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
- How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
- Get data from database using $WPDB
- Getting all the users who have author privilege
- Multiple postmeta with same name for one post in wp_postmeta table
- WP Database Table to CSV file
- Cannot update custom database table row
- Moving to another host; which tables to move in a database
- WordPress mysql table double prefixes
- Modify Database in Multi-Site wp_usermeta table
- Change WordPress prefix for only one table?
- Multiple wp_options tables to share content across installs
- Advanced SELECT query with condtional statements
- $wpdb doesn’t like to store arrays
- Select two sums with single get_var statement
- WordPress choose wrong database
- Redirecting to old domain after migration website
- Does WordPress $wpdb functions wait when table is locked?
- Create a table with wordpress plugin boilerplate
- How Can I Put Meta_Compare in the Database-Query?
- WordPress running SQL query to update database from form
- How to access custom WordPress database tables
- Change options table prefix only
- I’m not able to get access to $wpdb [duplicate]
- WPDB SQL query with prepare() returning variable, not db value
- $wpdb error (Call to a member function insert() on a non-object)
- Is it important to have integers inserted using %d rather than %s?
- Problem in using wpdb
- Best practice to limit results in get_row()?
- CreateOrUpdate in WordPress
- Clear Terms from Taxonomy for Specific Post IDs?
- Why does changing Database Table Prefixes result in loss of content?
- Trouble running $wpdb->query() with last_insert_id
- How to get a list of WordPress default database tables?
- Connecting to a different database
- Using $wpdb | checking entered email against existing emails in db
- Query Column of Specific ID from Database Table
- Optimizing function that automatically creates internal links based on post title string
- Update multiple rows in one query
- Can I customised default WP table
- How to connect and insert data in database of wordpress?
- Get results from wordpress data custom table
- Outputting query results
- add_post_meta — not working
- Select From wpdb – Author/User Directory page
- Will adding & modifying default WordPress table index break future WordPress update
- Creating and Using Tables in the WordPress Database
- What is wrong here? Issue with post_id and meta_value
- $wpdb->insert not inserting all rows
- wpdb Insert unknown post data dynamic foreach loop
- SELECT rows between two datetimes when the range is dynamic [closed]
- How to insert a value to decimal type field using wpdb->prepare?
- $wpdb->delete not working for me
- Insert NULL value using prepare()
- What is my error trying to create a new table in the database?
- Help with $wpdb on custom code
- “BS_” rows in postmeta table
- $wpdb->insert duplicating rows
- How to rerieve comments and their replies from DB
- Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
- Where is the HTML-handler part in the wpdb class?
- WordPress Database Query works in phpMyAdmin but not in the code
- How can I get $wpdb to show MySQL warnings?
- Correct and secure way to access a custom SQL database in a custom PHP template file
- About wp database hooks (error establishing connection)
- Using $wpdb to insert data into a table
- How To connect to the same WordPress database with different database user
- Call to a member function insert()
- I have include wp-config, should I add global $wpdb also?
- Processing a lot of $wpdb isn’t insert all the data
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- How can I retrieve data from alternate database using wpdb class?
- Creating Tables in WordPress Database
- How to use remote db tables in current config? [duplicate]
- $wpdb->prepare returns empty array
- How to delete field using WPDB?
- Uploading to WordPress Database