While building and testing WooCommerce addons, I find myself in need of quickly deleting all WooCommerce products from the database. WPCLI is the easiest way to go, as you can achieve the desired results via a single line. NOTE: if your database prefix isn’t the default wp_, you’ll need to change it with your actual database … Read full article →
Installatron allows you to easily with a few clicks install any application in your hosting account, and the installation process is the same for many applications. To install WordPress, follow these steps: Step 1. In the “Software” section of the cPanel, click the Installatron icon. Step 2. Click on the “Application Browser” > WordPress Step … Read full article →
For the WordPress mixed content error: “This request has been blocked; the content must be served over HTTPS” the best solution is to search&replace all links in files and the database using Regex with WP CLI. But if you are looking for a quick fix, just add the following code to .htaccess file to automatically forward … Read full article →
Here is a WordPress Twenty-Three Child Theme that you can download and add to your website so that you can add custom CSS or PHP code to the child theme. Install and activate the theme the same way as any other WP theme. If you also want to copy all style (patterns) from the main … Read full article →
Security is a result of security “practices” rather than plugin “functionality”. No security plugin is perfect, but we make do, and that, like everything else in life, is what defines the outcome. Here’s a simple diagram of how an attacker tries to get inside your website. There are 4 levels that each request has to … Read full article →
For some operations such as database export, WP-CLI uses PHP exec() function which is disabled on most shared hosting servers. So if you do wp db export and no file was created, make sure to check your error_log file and if you notice this error: PHP Fatal Error: Uncaught Error: Call to undefined function exec() … Read full article →
This WordPress snippet will add an “edit page” link on the WordPress posts and pages. Only users who are logged in and have the necessary rights to edit that page will be able to see this link (administrator or author). Add the snippet to the theme page where you want the link to appear, for … Read full article →
There are several ways you can optimize the MySQL database used by your WordPress site: Optimize tables Optimize all tables in your database: OPTIMIZE TABLE wp_posts, wp_comments, wp_options, wp_usermeta, wp_term_relationships, wp_term_taxonomy, wp_termmeta; Replace wp_ with the database prefix that you are using for your WordPress installation. Repair tables Repair any damaged tables in your database: … Read full article →
The SAVEQUERIES wp-config constant saves database queries to an array and We can use that array to display queries. The information saves each query, what function called it, and how long that query took to execute. To enable SAVEQUERIES add this to the wp-config.php file: Then in the footer of your theme put this: <?php … Read full article →
Here is an example of a simple WordPress plugin that uses the [phpinfo] shortcode to display PHP information similar to what the phpinfo() function does: <?php /* Plugin Name: PHP Info Shortcode Description: Displays PHP information using the [phpinfo] shortcode. */ function phpinfo_shortcode_handler( $atts ) { // Build the HTML for the data $html = … Read full article →