How to return count number from a wordpress database
It is recommended to use the $wpdb->get_var() method when retrieving a count of rows. This method will return the count directly, rather than inside of an array or object like wpdb::get_results().
phpmyadmin
Database table prefix different between wp-config.php and in database
WordPress can only use the tables with the same prefix as listed in the wp-config.php file. Many times when a database has been used for sometime it will hold several version of the site in the same database by adding different table prefixes to the site versions. This is likely what you are seeing. It … Read more
Deleting WordPress posts and media files based on author via MYSQL database
This is what I wanted to achieve, I hope it helps somebody DELETE wp_posts FROM wp_posts INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID WHERE post_author = 1 AND post_date BETWEEN ‘2024-01-01 00:00:00’ AND ‘2024-03-28 23:59:59’;
How to manually delete post from database without causing conflicts?
Drop this into a file in your plugin directory and you should be able to do this from your WP installation using a query string. /* Plugin Name: Delete Specific Post Description: Rid the post forever! Version: 0.1 Author: WPSE License: GPL2 */ add_filter(‘query_vars’, ‘delete_post_query_var’); function delete_post_query_var($vars){ $vars[] = ‘delete_post’; return $vars; } add_action(‘admin_init’, ‘manually_delete_post’, … Read more
404 Error after URL update
You might have already done this, but while logged into the admin of your site, go to Settings > General and then review the urls in WordPress Address (URL) and Site Address (URL). If they do not read with the new domain name, then they need to be updated. Once you have the correct urls … Read more
SQL phpmyadmin remove posts from cat id exclude condition
finally I find right code with helping by ChatGPT DELETE p FROM wp_posts p INNER JOIN wp_term_relationships tr1 ON (p.ID = tr1.object_id AND tr1.term_taxonomy_id = 2) LEFT JOIN wp_term_relationships tr2 ON (p.ID = tr2.object_id AND tr2.term_taxonomy_id = 20) WHERE p.post_type=”post” AND p.post_status=”publish” AND DATEDIFF(NOW(), p.post_date) > 180 AND tr2.term_taxonomy_id IS NULL; Lets try another way … Read more
is it possible to get a list of URLs from post_content directly in a mysql query via phpadmin?
is it possible to get a list of URLs from post_content directly in a mysql query via phpadmin?
After Import: Insert “Use” Statement in Database
It appears, at least in cPanel, the lines in question were not required in the export, with the unsurprising consequence of the other encapsulated sql statements defaulting to reference the current database only. Turns out to be convenient when more than one database is configured, so long as there are no statements that select objects … Read more
How to set autoload from “yes” to “no” _transient_wp_core_block_css_files
Don’t bother messing the with autoload on the transient. If you’re truly not using blocks at all, just unhook the function that creates the transient and uses it to register the style handles: remove_action( ‘init’, ‘register_core_block_style_handles’, 9 ); Just be aware that if you do use blocks, their stylesheets will not load until you let … Read more
Importing data from excel sheet on webpage rather than from within phpMyAdmin
Importing data from excel sheet on webpage rather than from within phpMyAdmin