How to Prevent SQL Injection in PHP (MySQL + PDO)
Learn how to prevent SQL injection in PHP using MySQL and PDO. This guide explains how attacks work with simple examples and shows how to secure your queries using prepared statements.
What is a Robots.txt File? A Simple Guide for Your Website
In this guide, I’m going to show you what a robots.txt file is, how to create a robots.txt file for your website, and what content you should or shouldn’t include in it. I’ll also provide a quick example of a basic robots.txt file that you can easily set up for any simple website and covers …
How to transfer your data from an old iPhone to a New iPhone
In this short guide, we are going to see how to transfer your data from an old iPhone to a New iPhone, or it could be any other iPhone because this process applies to iPhone-to-iPhone regardless of new or old. A to the point video is also available. Bu In case, you are interested to read the process step by step, you can surely read instead.
How to install WordPress (Simple Steps)
In this simple tutorial, we are going to see how to install WordPress. We are going to use two methods. First we are going to install it through One-Click simple solution (cPanel Softaculous) which is mostly provided by today’s modern hosting companies. Secondly, we are going to install it manually by completing steps all by ourselves.
Manage user redirect on the website (HTML, PHP, JavaScript, and .HTACCESS)
Today, we are going to see how can we manage user redirect on the website using HTML, PHP, JavaScript, and .HTACCESS. There will be several times or reasons where you would need to redirect a user to another page in your website or any web application.
Generate unique random ID in PHP MySQL
In this short guide, I am going to show you how to generate a unique random ID in PHP MySQL. What is a unique ID? There will be a time when you or your client would need to have a random and especially unique ID (identification) in a web application. For example, for an ecommerce site, there will be order IDs assigned to each order.
Prepare passwords to store in database in PHP
For all the websites which offer any kind of registration on their websites, they have to store user’s information into their database. So, in this short guide, I am going to show you how to prepare passwords to store in database in PHP using the recommended, efficient, and a secure method. The main concern is the security, because we cannot…
Connecting to MySQL Database in PHP
Connecting to MySQL database in PHP is a very initial step for developing any web applications or website. I am going to mention the most common and efficient way for connecting to MySQL database in PHP. Amazingly, PHP provides three ways (API) to connect and interact with database (MySQL). MYSQL, MySQLi, and PDO (PHP Data Objects).
MySQL vs MySQLi in PHP
If you are looking for a simple answer for MySQL vs MySQLi in PHP, then here is the explanation in simple words. MySQL is outdated and deprecated in the newer versions of PHP. MySQL is completely removed in PHP 7. I strongly recommend to use MySQLi from now on. MySQLi stands for MySQL improved extension. Let’s see the differences…
How to Flush DNS Cache on Windows
In this quick tutorial, we are going to see how we can flush DNS cache on Windows 10. This short guide includes a quick solution along with further steps and images as well. The process is the same for Windows 10 or Windows 11. To begin with, open command prompt which you will find on the left bottom corner and then use the following…