Calling an object that has a protected property that you need access to? This function will allow you to quickly access data stored in protected properties of PHP objects. Note: I tested this on PHP 7.4. It will likely work on other versions, but may need tweaking. Good developers will protect the internals of their

Ever received a large MySQL dump file and only needed one table out of it? I ran across just this issue. The full database took significant time to import and I only needed a small subsection of the DB, just one single table. Rather than waiting for it all to import, I pulled together a

I was recently asked for the total number of posts on a WordPress website. Normally as simple as looking at the number in the dashboard, however in this instance the WordPress install was a Multisite with nearly 100 sites. That would have taken far too long to do manually, but what about having MySQL do

I have a use case where I need to disable comments on posts in WordPress where the last comment was more than one year, or 365 days, ago. Posts can be found with this query: SELECT p.ID, p.post_title, p.post_date, p.comment_status, p.`ping_status` FROM wp_posts AS p WHERE p.ID IN ( SELECT c.comment_post_ID FROM wp_comments AS c

If you need to count the number of tables that exist in a MySQL database you can do so with the following query. Just remember to swap out the database name! SELECT count(*) FROM information_schema.tables WHERE table_schema = ‘YOUR_DB_NAME’