php (35) javascript (31) phpjavascript (30) jquery (23) html (20) mysql (14) database (9) codeigniter (4) json (4) bar chart (2) calendar (2) column chart (2) framework (2) google maps (2) query (2) tables (2) url (2) dropdown (1)

Tuesday, February 27, 2018

Simple login form using PHP and MySQL.

The login form is very much essential in every kind of web application so here we are explaining a simple and best way of doing login system. which mainly includes 
1. Connecting to Database
2. Login(Session Start)
3. Logout(Session End)
4. Session Check
5. Login Form
6. CSS

1. Connecting to Database

$DatabaseServer = "localhost";
$DatabaseUsername = "root";
$DatabasePassword = "root";
$DatabaseName = "demo";

$Connection = mysqli_connect($DatabaseServer, $DatabaseUsername, $DatabasePassword, $DatabaseName);

if ($Connection === false) {
    die("ERROR: Could not connect. " . mysqli_connect_error());

2. Login

if (isset($_POST['username']) and isset($_POST['password'])) {
    $Username = $_POST['username'];
    $Password = $_POST['password'];
    $query = "SELECT * FROM `user` WHERE FirstName='$Username' and Password='$Password'";
    $result = mysqli_query($Connection, $query) or die(mysqli_error($connection));
    $count = mysqli_num_rows($result);

    if ($count == 1) {
        $_SESSION['username'] = $
    } else {
        $fmsg = "Invalid Login Credentials.";

3. Logout

header('Location: login.php');

4. Session Check

if (isset($_SESSION['username'])) {
    echo "<div class='session-box'>";
    echo 'Welcome Mr.'.$Username = $_SESSION['username'];
    echo "<br><a href='logout.php'>Logout</a>";
    echo "</div>";
    echo "<div class='session-box'>";
    echo "You are logged out.";
    echo "</div>";


5. Login Form

<form method="POST" class="login-box">

    <div class="form-header">Please Login</div>

    <div class="col-md-12">  
        <input type="text" name="username" class="form-control" placeholder="Username" required>

    <div class="col-md-12">
        <input type="password" name="password" class="form-control" placeholder="Password" required>

    <div class="col-md-6">
        <button class="btn btn-primary" type="submit">Login</button>



        <link rel="stylesheet" href="">
        <script src=""></script>
                position: absolute;
                width: 300px;
                height: 270px;
                z-index: 15;
                top: 50%;
                left: 50%;
                margin: -100px 0 0 -150px;
                border: 1px solid #8080804a;
                border-radius: 5px;
                background: #8080804a;
                position: absolute;
                width: 300px;
                height: 100px;
                z-index: 15;
                top: 10%;
                left: 50%;
                margin: 0px 0 0 -150px;
                border: 1px solid #8080804a;
                border-radius: 5px;
                background: #8080804a;
                padding: 30px;
                padding: 10px;
                margin-top: 5px;
                margin-top: 20px;
                width: 299px;
                background: #004f61;
                text-align: center;
                font-size: 20px;
                margin-bottom: 20px;
                padding: 5px;


Create Database Table

  `UserID` int(12) NOT NULL,
  `FirstName` varchar(48) NOT NULL,
  `LastName` varchar(48) NOT NULL,
  `Email` varchar(128) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `City` varchar(48) NOT NULL

INSERT INTO `user` (`UserID`, `FirstName`, `LastName`, `Email`, `Password`, `City`) VALUES
(7, 'Rahul', 'Rajshekaran', '', 'Rahul@123', 'Pune'),
(8, 'Mahesh', 'Krishna', '', 'Mahesh@123', 'Delhi');



  1. Well done! you do a good job. but)) where is the salt? where md5? Young should immediately get used to a certain order! I think so. subjectively of course))

  2. Glance complicated in order to much added in pleasant from you!Lighting Warehouse Sydney

  3. June Florist - Same day flower delivery singapore. Call June Florist for floral arrangements for wedding, decorations for conferences, hand banquet decorations, Flower Box, table flower arrangement & more. Tel: +65 6282 7555
    order flower bouquet online
    florist online shop

  4. We offer university assignment help fulfilling the specific and precise needs of students. Poor quality of an assignment drastically affects the score sheet of a student. Here at, the writers know how to proceed with an assignment writing task to make the end-result appreciable with world-class university assignment help online. We even welcome the feedback from the client’s end and try to sort out the shortcomings as soon as possible.

  5. Thanks for the great writeup. This the fact is once were some sort of pleasure bank account this.High Bay Led Lighting

  6. it’s great post.i learn something new.i’ll try it my own.
    sign in hotmail
    hotmail sign up login

  7. We provide you support to handle your roadrunner email account efficiently. Roadrunner Phone Number +1-888-338-6033 enable you to get associated with remote professionals effectively and in a flash. We give 24x7 days roadrunner client support service.

  8. Thank you so much for providing such a useful information.

    If you are a Kaspersky user and face with the technical problem that attacks the functionality presentation of this antivirus software on your desktop, then Kaspersky Technical Support is right here to support you online and resolve all the problem.

    kaspersky help support
    kaspersky help support
    Kaspersky Tech Help
    Kaspersky Antivirus Support
    Kaspersky Technical Support
    Kaspersky Online Tech Support
    Kaspersky Online Tech Support Number

  9. Your article is very unique and powerful for the new reader.

    HP Support Number +1-855-676-7123 is the ultimate destination for all your issues.

    HP Support Number

    HP Customer Care

    HP Technical Support

    HP Printer Support

    HP Laptop Support

    HP Printer Drivers Support

    HP Phone Number

  10. Nice Post...

    People groups are utilizing Quicken to oversee and design their fiscal conduct effortlessly. One of the principle reasons why Quicken has turned out to be up front of individuals' lives today I because of the exceptional highlights it gives.

    Quicken Tech Support
    Quicken Technical Support
    Quicken Toll-Free Number

    Quicken Help and Support
    Quicken Customer Care
    Quicken Help Number
    Quicken Customer Service
    Quicken Phone Number

    Quicken Customer Support Number
    Quicken Support for MAC
    Quicken Windows Support
    Quicken Premier Support

  11. Access Your Computer Update Your Security Software Fix ipad Disabled Issue Fix All iPad Errors Restart Your Device Plug Directly Into Your Computer Fix ipad Disabled Issue Update iTunes Update Your Computer
    Fix ipad Disabled Issue Switched Off Antivirus Firewall on Your Computer Update iTunes to the Latest Version Fix ipad Disabled Issue Check the Network Connection Verify Your Firewall Settings Fix ipad Disabled Issue

  12. Check this out :

  13. Are you having trouble with your printer? Looking for printer technical support with proper customer care? Call Dial Printer Support at +1-888-621-0339 for quick and effective printer support customer care. Dial Printer Support
    Printer Technical Support

  14. HP Pavilion Number
    HP Customer Support, download drivers, manuals and troubleshooting information for HP products, including pcs, laptops, desktops, printers, tablets, apps and services. Support for HP
    HP Support Printer


More Posts