PHP SQL Login Script

This Application illustrates how to create a php validation script for login application.

This Application illustrates how to create a php validation script for login application.

PHP SQL Login Script

This Application illustrates how to create a php validation script for login application.

In this example we create a login application where we put all php script for validation. In this application whether user is unauthorized then a error message will be display to inform that user is invalidate but if an authorized user login then a success message will be display. All script is on the checklogin.php where we create a connection between database table and application to check, user is valid or not.

Source Code of login.php

<html>
<head><title>Login Form</title></head>
<body>
  <table width="300" border="0"
align="center" cellpadding="0"
cellspacing="1" bgcolor="#CCCCCC">
  <tr>
    <form name="form1" method="post" action="checklogin.php">
    <td>
      <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
        <tr>
          <td colspan="3"><strong>Please Login Here</strong></td>
        </tr>
        <tr>
          <td width="78">Username</td>
          <td width="6">:</td>
          <td width="294">
<input name="username" type="text" id="username"></td>
        </tr>
        <tr>
          <td>Password</td>
          <td>:</td>
          <td>
<input name="password" type="password" id="password"></td>
        </tr>
        <tr>
          <td> </td>
          <td> </td>
          <td>
<input type="submit" name="Submit" value="Login"></td>
        </tr>
      </table>
    </td>
    </form>
  </tr>
  </table>
</body>
</html>

Source Code of checklogin.php

<?php
  $host="localhost";
  $username="root";
  $password="root";
  $db_name="test";

  mysql_connect("$host", "$username", "$password")or die("cannot connect");
  mysql_select_db("$db_name")or die("cannot select DB");

  $username=$_POST['username'];
  $password=$_POST['password'];

  $username = stripslashes($username);
  $password = stripslashes($password);
  $username = mysql_real_escape_string($username);
  $password = mysql_real_escape_string($password);

  $flag="OK";
  $msg="";

  if(strlen($username) < 1){
    $msg=$msg."Please enter the user name<br>";
    $flag="NOTOK";
  }

  if(strlen($password) < 1 ){
    $msg=$msg."Please enter the password<br>";
    $flag="NOTOK";
  }

  if($flag <>"OK"){
    echo "<left>$msg <br>
<input type='button' value='Retry' onClick='history.go(-1)'></left>";
  }else{
    $sql="SELECT * FROM users
WHERE username='$username' and password='$password'";
    $result=mysql_query($sql);

    $count=mysql_num_rows($result);

    if($count==1){
      session_register("username");
      session_register("password");
      header("location:loginsuccess.php");
    } else {
      echo "Incorrect User Name OR Password Found";
      echo "<left><br>
<input type='button' value='Retry' onClick='history.go(-1)'></left>";
    }
  }
?>

Source Code of loginsuccess.php


<?

  session_start();

  if(!session_is_registered(username)){

    header("location:login.php");

  }

?>



<html>

<body>

Login Successful

</body>

</html>

Download Source Code

Output:

Ads