The main problem is how you’re specifying the custom table name (e.g., $wpdb->cf7dbplugin_submits). $wpdb only knows about the “built-in” tables when accessing a table name via $wpdb->xxx. To specify access a custom table name, use {$wpdb->prefix}custom_table_name. The other thing I notice is that, for security purposes, you should never use interpolated variables in an SQL … Read more
I would discourage using raw SQL for moving a post to a trash or back, especially since there’s a build in function for it: wp_trash_post( $post_id ); More about the wp_trash_post() function. The opposite is: wp_untrash_post( $post_id ); wp_untrash_post() also untrashes trashed comments. In WP there are functions for many things – for instance you … Read more
You can just run the wp_update_term_count_now php function after doing this: https://developer.wordpress.org/reference/functions/wp_update_term_count_now/ Which calls the private _update_post_term_count https://developer.wordpress.org/reference/functions/_update_post_term_count/ If you look at the source of that you will see how term counts are updated (which is done when you save a post on backend): function _update_post_term_count( $terms, $taxonomy ) { global $wpdb; $object_types = (array) … Read more
Unfortunately there’s not really an easy way to achieve what you’re looking for because you’re using ACF to manage the relationships. ACF stores its data as serialized arrays in wp_postmeta, so you can’t use SQL. A more performant way to manage the relationships between posts and FAQs would be to use a taxonomy.
The theme is most likely altering the main query via the pre_get_posts hook, chaning the posts_per_page argument to -1 for all posts, or another higher number. You can search your theme folder for pre_get_posts to see all the times this hook is used. A better solution would be to install the Query Monitor. With this … Read more
Method 1, SQL Notes about your SQL [Unknown column ‘wp_usermeta.meta_key’ in ‘where clause’] This is solved by adding this to the JOIN part of the query: JOIN wp_usermeta ON ( wp_usermeta.user_id = wp_users.ID ) You could check the value of the JOINS and, if false === strpos( ‘wp_usermeta’, $joins ), adding it yourself. When getting … Read more
Run the following SQL query in PHPMyAdmin or similar. UPDATE wp_users SET user_login = user_nicename; wp_users is the table for users (make sure it matches yours)
No, there is no inherent security flaw in $wpdb, or using it within a shortcode. However, you can introduce vulnerabilities if you aren’t careful how you use it. There are primarily two issues that you should be thinking about. The first is escaping. You need to make sure that any potentially user-controlled values are escaped … Read more
You can use wpdb to setup a new connection. Add something similar to this below in your functions.php and you can then query just like you would normally but using the new connection. $second_db = new wpdb(DB_USER, DB_PASSWORD, $database_name, DB_HOST); $results = $second_db->get_results($your_query); references: https://wordpress.stackexchange.com/a/1673/86845 https://stackoverflow.com/a/36759606/3204142
You can’t pass SQL directly as query parameters. The only valid values for orderby are covered in the docs for WP_Query. If you want to directly modify the SQL, you need to use the posts_* filters, in this case posts_orderby.