If you have been using WordPress for a long time, it is possible that you have many spam comments, revisions, transients cache, etc. on your WP database. In this post, I listed the most useful SQL queries you can use to clean up your WordPress […]
Mark Jaquith announced that wordpress will no more support PHP4 & MySQL4. If you are (your host is) using PHP 4 or MySQL 4 you may not be able to catch the next wordpress update. Don’t know which version you have? Mark created a health check […]
Sometimes SQL knowledge is critical for WordPress developers to run mass updates on your posts. In this post, we are sharing an example SQL query to get posts using a category name. This requires database access and some basic SQL knowledge. To get all posts […]
Managing backups and restoring your WordPress site is an essential task for any website owner. Backups allow you to recover your site in the event of a disaster, such as a hacker attack or a server crash. It is also a good practice to keep […]
WordPress Hosting packages differ a lot between hosting providers. But to call a Hosting, “WordPress Hosting”, that provider should meet certain requirements. Otherwise, it will fail badly and you will notice it fairly late. You can find our top WordPress Hosting Requirements for 2023 in […]
WordPress needs PHP extensions to generate page content, update core and plugins and also for handling of file and image uploads. In this post, we have compiled a complete list of required PHP extensions for operating WordPress on a linux server. Critical PHP Extensions Critical […]
htaccess is the main entry point for any WordPress website. When you enter an url to a WordPress website, url request is sent to the server and it is then handled by WordPress using rewrite rules defined in the htacess file. Often, htaccess file is […]
Sometimes you may need to hide certain tags and categories from your widgets. In this post, I will explain you how to hide unwanted terms using wordpress filters. First open your functions.php file in your theme folder. This is the main script file where we […]
When you are creating a custom loop, generally query_posts or WP_Query is more than enough for the job. But if you want to work on an API project that depends on WordPress tables, then you will need to use custom MySQL queries. Here is a […]
To get a list of WordPress Posts using meta query in MySQL, you can use the following SQL query: SELECT p.ID, p.post_title, m.meta_id, m.meta_key, m.meta_value FROM `wp_posts` p LEFT JOIN `wp_postmeta` m ON p.ID = m.post_id WHERE m.meta_key = ‘wpcf-show-status’ AND m.meta_value ” ORDER BY […]