- No idea
- yes, use
$wpdb - seems like it should be. OTOH if this is something you want to do in a plugin, I am not sure if normal wordpress users (as defined in the DB) have trigger creation privilege.
just be careful with what you are trying to do, as if you have object caching and the data you create is read by wordpress APIs, you might end up with a mismatch between the cache and the DB.
Related Posts:
- Should I use wpdb prepare?
- Getting wrong relationship value in $args in wp_Query?
- Does using set_transient() function can lead to MySQL problems?
- How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
- How is the data stored in the database?
- How can I free up the memory used by update_post_meta?
- Passing array of strings to a SQL statement in a WordPress plugin
- Activation hook not creating table
- Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
- How to edit mySQL wp_posts table from plugin php?
- Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
- $wpdb -> Batch insert from XML File?
- query users by role
- WordPress database error for query INSERT INTO
- How to connect to AWS RDS external database (not for the core WordPress db)
- How to add user details to different tables immediately after user registration
- mysql_real_escape_string() vs. esc_sql() in WordPress
- How to get all queries’s results after they have executed?
- $wpdb->prepare with LIKE and sprintf
- Alternative functions for mysql_free_result and mysql_ping in wordpress functions
- Using AND and bracket grouping in SQL not working
- Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
- How can I programmatically change a MySql variable (foreign_keys_check)?
- Auto-complete or auto-suggest from stored data in database
- What might be the reason of Couldn’t fetch mysqli_result on another domain?
- $wpdb->prepare is not working like mysql_real_escape_string
- Brainstorm – Slow Query from Plugin Need to Speed It Up
- Create an user on external database
- What could cause a WP Option to get truncated?
- WordPress database error: [Query was empty] – using $wpdb->prepare()
- Foreign wp_users ID in custom plugin DB table?
- How to Get Last ID?
- Insert, update or remove data from database (usermeta)
- WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
- Why is that only the first row getting inserted into Mysql table when i import csv file on backend custom plugin?
- Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
- Is it possible to replace MySQL with JSON files for WordPress
- WordPress doesn’t create table on plugin activation
- WordPress delete mysql rows with string
- Organising and completing posts (mark as read and hide)
- pull data from wordpress database
- Plugin MySQL SELECT custom data and filter on user meta
- sql query not working in wp plugin
- Custom MySQL query to pull out Advanced Custom Fields?
- How to filter get_adjacent_post()?
- $wpdb how can i save my postmeta table before querying it
- Nothing happens on WordPress Update command
- Is get_option() faster than accessing get_transient()?
- How can I add a custom column to the “Manage Categories” table?
- Has anyone managed to integrate the wp_editor inside a widget?
- Using Primary Color in Plugin Block
- Backslashes being stripped from CSS
- Extending WP_List_Table seems getting wrong with $this->get_columns() – what’s wrong?
- Finding posts containing matching array elements in a meta field usign WP_Query
- how to use hook deleted_user into custom function to delete user from custom table
- Single sanitization callback for multiple fields
- How to filter users list on user_status field with get_users()
- How to add custom fields to the all users page
- Can Page Templates be Applied to Archive and Post Templates?
- Is there a plugin that will allow a tag cloud to be created from any mysql field?
- Custom login doesn’t work properly
- Translate slug in WPMU with PO files
- Allow users to add / remove settings in plugin
- Plugin – Make sure jquery is loaded in my settings page plus my JS file
- Getting a WordPress Debug Strategy
- Best way to include and use Zoho SDK in a wordpress plugin
- How to change WooCommerce loop product title HTML output in single product page and archive page
- How remove trashed WooCommerce orders from wc_get_orders() result?
- Unexpected T_FUNCTION
- How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?
- Plugin can’t be activated [closed]
- Is there an action_filter hook to add content before the post title?
- CSS not being applied using wp_enqueue_style
- Hide / show settings field based on other field’s value
- $_SESSION inside php function executed by AJAX
- Two same AJAX calls – one is working, other doesn’t
- Adding and handling custom settings tab to fusion element
- How to get option values without requiring wp-load?
- Problem with baseurl and interaction with plugin
- Why setcookie function redirecting to home page in wordpress?
- how to display my WordPress plugin on a chosen page?
- How to set/change another post author by custom fields or something else?
- How to change the headline title for an admin page in a plugin?
- Cannot update plugin
- Safe XML response from wordpress plugin
- Gutenberg: – Call a function after Server Side Component is rendered
- How are themes and plugins localized using the gettext GNU framework?
- Theme, Plugin or Both?
- Accept only PDF file for upload
- WordPress upload path decalration
- Add a custom image source
- filter on get_posts efficiently
- How to get custom user meta by id in custom Gutenberg block
- How to prepend a header section to all pages related to my WordPress Plugin
- How to access Elementor-navigation-elements via jQuery
- Hook a search form anywhere on the site, using a custom plugin
- Plugin forms overwrite each other’s options
- ACF – programmatically install and activate in pipeline to automate testing for custom plugin development?
- How can I include React useState in a custom gutenberg block plugin?
- Problem with Owl Carousel, infinite loop [closed]