How to Create Login Page in PHP using MySQL?

In this tutorial you will learn how to create login page in php using mysql in very easy way. Here I will explain each and everything in step by step so that you can understand easily.

If you found any difficulty in my tutorial please post the comment in comment box or post in contact us page.

What we are doing in this tutorial?

Step 1.

First we will create a login page design in PHP so that we can login. My PHP page name is index.php.

Design your login page like below.

Login Page in PHP

Copy the below complete HTML code and paste it in index.php page. 


	<html>
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, intial-scale=1.0"/>
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
	<title>Campuslife Login Page</title>
	<style>
	
		body{
			background: #ececec;
			color: #333;
		}
		#main{
			text-align: center;
			margin-top: 20px;
		}
	
		#main .login-box{
			margin-top: 20px;
		}
	
		#main .tb{
			width: 100%;
			height: 40px;
			margin-bottom: 5px;
			padding-left: 5px;
		}
	
		#main .btn{
			width: 100%;
			background: #AD193E;
			color: #f7f7f7;
		}
	
		#main .msg{
			color: red;
		}
	
	</style>
	</head>

	<body>
	<!-------------------Main Content------------------------------>
	<div class="container" id="main">
		<div class="col-sm-4"></div>
		<div class="col-sm-4">
			<h2>Login Page in PHP</h2>
			<form name="logfrm" action="" method="post">
				<div class="col-sm-12 login-box">
					<input type="text" placeholder="Enter user name" name="user_name" class="tb" />
					<input type="text" placeholder="Enter password" name="password" class="tb" />
					<input type="submit" value="Login Now" name="login_btn" class="btn" />
				</div>
			</form>
			<div class="msg"><strong><?php echo $message; ?></strong></div>
		</div>
		<div class="col-sm-4"></div>
	</div>
	</body>
	</html>

Step 2.

Now create a database and table in MySQL. My database name is master and table name is login. You can give your own name to your database and table. To create the database in MySQL, go to in your MySQL and write the below command. Now execute your command by pressing Ctrl + Enter or you can execute it from tool bar.

Below is database command:

MySQL Create Database Command

After creating the master database now we have to use that database. In that database we will create our table. See the below command to use the database and press Ctrl + Enter.

MySQL Use Database Command

Now create the table in master database. See the below command to create a table.

MySQL Create Table

Now database and table creation has been completed. Our table is empty and it’s time to insert the some records (user name and password) in table so that we can login from database using MySQL. Execute the below insert command in MySQL.

MySQL Insert Query Command

Step 3.

I am creating separate connection file so that I can access it anywhere in page. Now create a connection.php file. In this we will add connection information of MySQL so that we can create connection between PHP to MySQL for login.

Why separate connection file?

Because we can call that file in many pages. If we can’t create separate file for connection then we have to write same code in every pages manually. It is good for single or two pages, but not good for 10 or more pages.

Connection file contain below information like (host name, MySQL user name, MySQL password, database name). Change the connection information as your MySQL login information in connection.php file. 

	
	$host ="localhost";
	$uname = "root";
	$pwd = '123456';
	$db_name = "master";

Now we will use connection.php file in step 4.

Step 4.

Now create a PHP login script page that allow to login us. My PHP login script page name is login.php.

Copy the below login script and paste it in your login.php page or write yourself for better practise by understanding it. 

	
	<?php

	//this variable for show the error or success message on page
	$message="";

	if(isset($_POST['login_btn'])) 
	{	
		include "connection.php";

		$conn = mysqli_connect($host,$uname,$pwd) or die("Connection errors.".mysqli_error());
		mysqli_select_db($conn,$db_name);
		$result = mysqli_query($conn,"SELECT * FROM login WHERE uname='" . $_POST["user_name"] . "' and pwd = '". $_POST["password"]."'");
		$row  = mysqli_fetch_array($result);
		if(is_array($row)) 
		{
			header("location: index.php");
		}
		else 
		{
		$message = "Invalid Username or Password!";
		}

	}
	
	?>

Step 5.

Now add login.php page in index.php page at the top like below. Just copy the below code and paste it in your index.php page at the top. 

	
	<?php
	
		include('login.php'); // Includes Login Script
		
	?>
Php login page

Step 6. Final Step

Our login page tutorial has been completed. Now test your page on browser.

PREVIOUS
NEXT

Do you want Youtube channel of Campuslife

Please provide your suggestion on feedback page.

Subscribe Now

Post Your Comment

↑