Part 1 - Registration system using PHP and MYSQL Database
In this tutorial we are going to create full registration system using HTML, PHP and MYSQL database. here in this system user can create account by providing name, mail, mobile and password. I will also show you how you can make some pages accessible only to
logged-in users. Any other user not logged in will not be able to access
XAMPP Application required.
Note pad++ recommended.
First we need to create Database:
Create a database called learning. In the learning database, add a table called user. The users table will take the following four fields.
user_id (auto increment)
user_username - varchar(255)
user_mail - varchar(255)
user_mobile - varchar(255)
user_password - varchar(255)
You can create this using a MySQL client like PHPMyAdmin.
You can Create database by watching this following video :
Steps to create "learning" database
Open Xampp application and start Apache and MYSQL.
then, open any browser and type localhost and press Enter Key.
then choose phpmyadmin option.
click on SQL, and type query CREATE DATABASE learning;
then, click on Go button.
once Database is created then choose it from left side panel.
then, Enter Table name (user) and total number of column (5).
click on Go button.
then, Enter Column name, Choose its type and Enter length of filed. refer above image or video.