Author: GeeksLab Technology

To create a multi-level menu with primary categories and subcategories using PHP and MySQL, you can follow these steps: Copy <ul> <?php // Parent Category Menu Query $sql = “SELECT cat_id AS ‘pCatID’, cat_name AS ‘pCatName’ FROM category WHERE is_parent = 0 AND status = 1 ORDER BY cat_name ASC”; $parentMenu = mysqli_query($db, $sql); while( $row = mysqli_fetch_assoc($parent_Menu) ) { extraxt($row); //print_r($row); $subCat = “SELECT cat_id AS ‘sCatName’ FROM category WHERE is_parent = ‘$pCatID’ AND status = 1 ORDER BY cat_name ASC”; $subMenu = mysqli_query($db, $subCat); $countSubMenu = mysqli_num_rows($subMenu); if ( $countSubMenu == 0 ){ ?> <li> <a href=”category.php?category=<?php echo…

Monitoring the status of your WordPress site is vital in order to maintain its performance, protection, and use. In WordPress, there are tools and recommendations aimed at improving the website’s health. By following the below steps, you can check WordPress website health status and also you can improve it.Plugin setup: Log in to your wordpress dashboard.Go to Plugin > Add new plugin.Search for Health Check & Troubleshooting by The WordPress.org community.Install and activate the plugin.Once installed and activated, go to Tools > Site Health. Health check and Troubleshoot: From the site health menu, go to the info tab as in the image.In the…

To create a smooth connection between PHP and a MySQL database for effective data storage, retrieval, and management, we can use PHP’s mysqli or PDO (PHP Data Objects) extension. The aim is to build a secure, scalable, and functional backend system. This involves setting up database credentials, managing any connection errors, and running SQL queries for CRUD operations. It’s important to use prepared statements to guard against SQL injection, ensuring the application stays secure. This goal is centered on enhancing the interaction between PHP and MySQL to support strong, dynamic, and data-driven web applications.By following the below steps, you can connect…

Tables are very useful tools in websites. For an interactive data sheet we can use tables to present information to users in a clear and organized way. We can use tables for particular reasons like organizing data, creating pricing tables, comparison charts, creating resource libraries and many more.Elementor and its pro version doesn’t natively support creating tables. So, we need to use some plugins or elementor addons to create tables in elementor. Here is a list of some plugins with tables and their features.Some popular plugins with table feature:1. Essential Addons for ElementorDrag-and-drop table builder.Basic tables.External file import.2. WP Table…

Contact Form 7 is one of the most popular form plugins for WordPress website. Its default styling does not look attractive and eye-catching. That’s why we need to re-style the contact form 7 for different websites. By following the below steps, you can add custom style in your contact form 7. Step-by-Step guide: Install and activate plugin: Log in to your WordPress dashboard. Go to Plugins > Add New. Search for “Contact form 7”. Install and activate the plugin. Form Creation: You can use or import premade forms. Or you can create a new form with your required fields. Place…

In our wordpress woocommerce websites, we can use QR code for a better and smooth user experience. We can share product links, order details, shipping or payment information through the QR code. By following the below steps, you can add QR code in  your website. Features: Product Information Sharing Faster Checkout Order Summary Digital Payments Marketing and Promotions Order Tracking Store Navigation Social Media and Reviews Integration with Emails and Invoices Security and Verification Step-by-Step setup guide: 1. Install and activate plugin: Log in to your WordPress dashboard. Go to Plugins > Add New. Search for “Kaya QR Code Generator…

Some WordPress websites require multiple languages for global users. In this case we have to create our website multilingual. GTransate is one of the best translation plugins with Google power and makes wordpress websites multilingual. It can translate your website to more than 100 languages for global users. Using the GTranslate plugin, we can move away from the language barrier for global internet users. By following the below steps, you can use the GTranslate plugin and make  your website multilingual. Step-by-Step setup guide: 1. Install GTranslate plugin: Log in to your WordPress dashboard. Go to Plugins > Add New. Search…

If you want to add a CAPTCHA to your Contact form 7, you can select Google reCAPTCHA or any other CAPTCHA service. Following this, we guide you how to add Google reCAPTCHA to Contact form 7. By following the below steps, you can add Google reCAPTCHA to your website. Step-by-Step Guide: 1. Get Google reCAPTCHA API Keys: Go to the Google reCAPTCHA website. Sign in with your Google account and register your site. Depending on your needs, select the reCAPTCHA v2 or reCAPTCHA v3 options. Once you have registered, the next step is to note down the two keys; Site…

If you want to add a CAPTCHA to your Elementor form, you can select Google reCAPTCHA or any other CAPTCHA service. Following this, we guide you how to add Google reCAPTCHA to an Elementor form. By following the below steps, you can add Google reCAPTCHA to your website. Step-by-Step Guide: 1. Get Google reCAPTCHA API Keys: Go to the Google reCAPTCHA website. Sign in with your Google account and register your site. Depending on your needs, select the reCAPTCHA v2 or reCAPTCHA v3 options. Once you have registered, the next step is to note down the two keys; Site Key…

Most of the time, this problem happens when your website can’t connect to its database. We’ll look into why this happens and how to fix it properly. What Causes of This Error?  There are many reasons included for this error: Incorrect Database Credentials: If your database name, username, password, or host credentials are incorrect. You will show this error. Database Server Issues: If your hosting provider’s database server has an error or is down at this time. High Website Traffic: This occurs when the number of visitors to your website is so high that the database server is unable to…