Latest Articles

How to Add Drop Unique Key in MySQL

A unique key is a key that can be a column or a group of a column that defines the uniqueness of that record/row in the table. A unique key is different from the Primary key. The unique key can be a NULL value, whereas the Primary key cannot be a NULL value.  Add and […]

MySQL Queries and some Operators

This article will teach some basic MySQL queries, which are important to master MySQL database. Also, we will learn some supporting operators for MySQL queries. MySQL Queries MySQL provides some basic queries like CREATE, INSERT, SELECT, UPDATE, and DELETE to execute CRUD operations in the database. Here, we will learn each query with a brief […]

Simple Registration and Login form with PHP and MySQL

Here we are discussing how to create simple login form in PHP and MySQL. You have to follow below basic steps for that. Before starting, you should know how to use PHPMyAdmin and some basic knowledge of PHP. Step 1: Create a Database Create a database in PHPMyAdmin. Create Table using id, username, email, password […]

MySQLi Functions Introduction in PHP

MySQLi functions allow you to access the MySQL database server. Here we take a quick look at some basic functions of them. If you are not familiar to use phpMyAdmin please refer to the phpMyAdmin quick tutorial. MySQLi Functions in PHP There are lots of MySQLi functions in PHP. MySQLi functions are useful to connect […]

How to Create a Table in PHPMyAdmin

Here we discuss some basic steps on how to use phpMyAdmin. Before we started, let’s get some basic information about phpMyAdmin. What is PHPMyAdmin? PHPMyAdmin is a software tool that is basically used to handle the administration of MySQL over the web. It supports a wide range of operations on MySQL that can be performed […]