Linux MySQL commands
SET FOREIGN_KEY_CHECKS = 0;<br>DROP TABLE IF EXISTS <code>table1, table2, table3, …;SET FOREIGN_KEY_CHECKS = 1;</code> Take Backup of Database
How to create dynamic HTML sitemap in WordPress with a shortcode (and exclude post types)
An HTML sitemap is a simple way to display all your website’s content in one place. It helps visitors and search engines quickly navigate your site’s structure. In this tutorial, we’ll show you how to create a WordPress shortcode that generates an HTML sitemap displaying Pages, Posts, and Custom Post Types (CPTs) – with an […]
How to add a GST number field to WooCommerce checkout and order emails
If you’re running a WooCommerce store in India or working with B2B clients, you may need to collect GST numbers during checkout. In this tutorial, you’ll learn how to add an optional GST number field on the WooCommerce checkout page, save it with the order, and display it in the admin panel as well as […]
How to generate Facebook & Google product XML feed in WooCommerce without a plugin
If you’re running a WooCommerce store and want to connect your products to Facebook Catalogue or Google Merchant Center, you usually rely on a plugin. However, plugins can add bloat, slow down your website, or offer limited control. This guide shows you how to generate a dynamic XML product feed from WooCommerce without installing any […]
WordPress custom YouTube feed plugin
The Custom YouTube Feed plugin allows WordPress site owners to display videos from multiple YouTube channels and individual videos in an attractive grid layout. The plugin features pagination, popup video playback, and automatic caching for improved performance. Key Features Installation Requirements Usage Shortcode: Add videos to any post or page using the shortcode: Admin Settings […]
Fetch data from Google Sheet and show in HTML using PHP
This documentation explains how to use the provided PHP code to fetch data from Google Sheets and display it in a custom layout using HTML/CSS. Setup Instructions Step 1: Get Your Google Sheet ID Open your Google Sheet in a web browserLook at the URL in the address bar – it will look like:https://docs.google.com/spreadsheets/d/BmzaSyBzQ0cRTrbf_vxrB75nh8AoV3BtawPiiCQ/edit#gid=0The long […]
Disable WordPress Comment System Completely
Here’s a comprehensive function to completely disable the WordPress comment system. Add this code to your theme’s functions.php file or in a custom plugin. The function will: Additional Steps for Stubborn Comment Forms {.wp-block-heading}If the comment form still appears after adding this code. Check your theme files: Some themes hard-code the comment form. Look in […]
Block HTtrack or any other web scrapper
There are several web scrappers tools are available by which your website can be do nloaded as static files. The simplest way to block these web scrap ers is to add the following blocking bots code in your website .htaccess file.
WordPress change default from name and email id
When you get any email from your self hosted WordPress website, form name of that email will be WordPress which is quite annoying to you or your clients. You can overwrite this by adding this small piece of code in the functions.php file of your theme.
WordPress custom menu page, fetch data from custom MySQL table and export to CSV
To create a custom menu page in WordPress, retrieve custom table data from MySQL, and display it with the ability to export to CSV/Excel, you can follow these steps: Step 1: Create a custom table in your WordPress database to store your data. You can use the $wpdb global variable to interact with custom tables […]