How to:A Simple PHP Login Form Using Mysql

Objective: To create simple PHP Login Form .

Prerequisite :

In order to create simple PHP login form , we are going to use following tools .

• Notepad ++
• Xammp
• Google Chrome /Any Browsers

Step by Step Tutorial :

Step 1:  Go to  following link  and click PhpmyAdmin is which under Tools menu .

http://localhost/xammp

Step 2 : Create Database ‘test_db’

Step 3 : Create table ‘test’ with three fields .

Three fields are :

• Id
• Username
• Password

After creating Table ‘test’ with three fields , Click save button .

Step 4: Till step3 we have created Database and table name . Next we are going to insert the values in the table.(username and password).

We can insert in two ways :

• One way is directly which is same as we created the table .
• Second way is by inserting the SQL query.

Step 5 :Create four PHP files as mentioned below &  Open notepad ++ and paste following php codes into it . Finally dont forget to save these files into htdocs folder .(It is present in XAMMP folder)

• main_login.php
• check_login.php
• login_success.php
• logout.php

Let’s create a folder say Login in htdocs folder , in which we will save all these php files which is mentioned above .

main_login.php

Output : 

check_login.php

login_success.php

logout.php

How to run :

Go to browser and type

Note : Here ‘Login’ is folder name .

Now type the username and password (as we gave in the database) .

If username and password is correct then it will display :

otherwise it will show :

That’s it done .

Thank you for visiting my tutorial .