Fix: WordPress.DB.PreparedSQL.NotPrepared Plugin Check (PCP)
Fix: WordPress.DB.PreparedSQL.NotPrepared Plugin Check (PCP)
sql
WP_Options tabel randomly increasing in size indefinetly
WP_Options tabel randomly increasing in size indefinetly
WP_Query equivalent of SQL UNION ALL
You can run 2 wp_query, get the ids and pass those as the post__in parameter to a 3rd wp_query. Not efficient but will do the job. Or you can use a subquery and do it all with just one wp_query. Something like the following: add_filter( ‘posts_where’, ‘myprefix_posts_where’, 10, 2 ); new WP_Query([ ‘post_status’ => ‘publish’, … Read more
Recursion using year loop in sql
Recursion using year loop in sql
How to verify/test that a custom built wordpress theme is as secure as possible?
Theme Check is a tool published by the WP.org Themes team to scan your theme against the wp.org security standards. There’s also one for plugins. Any default functionality like comment forms will already be escaped/sanitized.
How does wordpress link columns from different tables without using FOREIGN KEY or JOIN?
It doesn’t. WordPress doesn’t use foreign keys to link tables together that way. There are also lots and lots of other reasons to declare keys and primary keys in a table that have nothing to do with this type of linkage/referencing. For example telling MySQL/MariaDB the ID column is a primary key give critical clues … Read more
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
Publishing failed error due to “CAST()” in post
Publishing failed error due to “CAST()” in post
How to properly prepare a column name if passed to a stored procedure?
How to properly prepare a column name if passed to a stored procedure?
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’;