• +91-8376990324
  • amitdsy@gmail.com
Home • • Create Simple Login Page with PHP and MySQL

Create Simple Login Page with PHP and MySQL

Using login page registered users sign in to the website and manage its account.

On the user successful login attempt need to define $_SESSION.

This helps to detect the user is actually logged in or not when going to another web pages and it also helps to display content according to the user.

In this tutorial, I show how you can create a Login page with PHP and MySQL.

1. Table structure

I am using users table in the tutorial example.

CREATE TABLE `users` (
  `username` varchar(80) NOT NULL,
  `name` varchar(80) NOT NULL,
  `password` varchar(80) NOT NULL

2. Configuration

Create a new config.php file.

Completed Code

$host = "localhost"; /* Host name */
$user = "root"; /* User */
$password = ""; /* Password */
$dbname = "tutorial"; /* Database name */
$con = mysqli_connect($host, $user, $password,$dbname);
// Check connection
if (!$con) {
 die("Connection failed: " . mysqli_connect_error());


Create a login page layout which has two input type elements for entering username and password and a button to submit the form.

Completed Code

<div class="container">
    <form method="post" action="">
        <div id="div_login">
                <input type="text" class="textbox" id="txt_uname" name="txt_uname" placeholder="Username" />
                <input type="password" class="textbox" id="txt_uname" name="txt_pwd" placeholder="Password"/>
                <input type="submit" value="Submit" name="but_submit" id="but_submit" />

4. CSS

/* Container */
    margin:0 auto;
/* Login */
    border: 1px solid gray;
    border-radius: 3px;
    width: 470px;
    height: 270px;
    box-shadow: 0px 2px 2px 0px  gray;
    margin: 0 auto;
#div_login h1{
    margin-top: 0px;
    font-weight: normal;
    padding: 10px;
    background-color: cornflowerblue;
    color: white;
    font-family: sans-serif;
#div_login div{
    clear: both;
    margin-top: 10px;
    padding: 5px;
#div_login .textbox{
    width: 96%;
    padding: 7px;
#div_login input[type=submit]{
    padding: 7px;
    width: 100px;
    background-color: lightseagreen;
    border: 0px;
    color: white;

5. PHP

On form submit check the username and password entered or not. If entered then execute a SELECT query to count records on the basis of username and password.

If query returns greater than 0 then initalize $_SESSION[‘uname’] = $uname and redirect to home.php.

If it returns 0 then display the “Invalid username and password message”.

Complete Code

include "config.php";
    $uname = mysqli_real_escape_string($con,$_POST['txt_uname']);
    $password = mysqli_real_escape_string($con,$_POST['txt_pwd']);
    if ($uname != "" && $password != ""){
        $sql_query = "select count(*) as cntUser from users where username='".$uname."' and password='".$password."'";
        $result = mysqli_query($con,$sql_query);
        $row = mysqli_fetch_array($result);
        $count = $row['cntUser'];
        if($count > 0){
            $_SESSION['uname'] = $uname;
            header('Location: home.php');
            echo "Invalid username and password";


Create new home.php file.

First, check whether the user is logged or not by checking the $_SESSION[‘uname’] variable. If its not set then redirect the user to index.php for login.

Created a logout button which destroy the $_SESSION[‘uname’] variable and redirect to index.php web page on click.

Complete Code

include "config.php";
// Check user login or not
    header('Location: index.php');
// logout
    header('Location: index.php');
<!doctype html>
        <form method='post' action="">
            <input type="submit" value="Logout" name="but_logout">

7. Conclusion

In this tutorial, I showed how you can create a simple login page with PHP and MySQL.

You must have to initialize the $_SESSION variable to detect the user when traversing to other pages and destroy it when the user clicks the logout buttons.

Apply For Trainer