Labels

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

session_start();
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'] = $
Username;
    } else {
        $fmsg = "Invalid Login Credentials.";
    }
}


3. Logout

session_start();
session_destroy();
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>";
}else{
    
    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">  
        <label>Username</label>
        <input type="text" name="username" class="form-control" placeholder="Username" required>
    </div>

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

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

</form>

6.CSS

 <head>
        <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>
        <style>
            .login-box{
                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;
            }
            .session-box{
                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;
            }
            .form-control{
                padding: 10px;
                margin-top: 5px;
            }
            .btn-primary{
                margin-top: 20px;
            }
            .form-header{
                width: 299px;
                height:40px;
                background: #004f61;
                color:white;
                text-align: center;
                font-size: 20px;
                margin-bottom: 20px;
                padding: 5px;
            }
        </style>

    </head>

Create Database Table

CREATE TABLE `user` (
  `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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







Result




26 comments:

  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))

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

    ReplyDelete
  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

    ReplyDelete
  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 Calltutors.com, 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.
    https://www.calltutors.com/Articles/Writing-Assignment-for-University

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

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

    ReplyDelete
  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.

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  12. Check this out : https://www.skptricks.com/2018/07/working-with-textinput-in-react-native.html

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete

More Posts

FOLLOW