Login Page in PHP with Database Source Code

December 15, 2021October 28, 2019 by itsourcecode

Login Page in PHP with Database Source Code

Login Page in PHP with Database Source Code is the main focus of this course based on our previous tutorial called “How to Create a Secure Login page using PHP/MySQL“. But this time we will simply modify some of our codes to convert MySQL to MySQLi in Object-Oriented approach. If you don’t have any idea about MySQLi, you can visit and start your basic understanding here for more examples and demonstrations.

Let’s Start Coding the Projects

To do this, open the root folder called “logintuts” and using any text editor open the file named “connect.php”. Then replace all the codes by the following code:

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "studentdb";
 
// Create connection
$conn = new mysqli($server, $username, $password, $database);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>

Continuation Coding the “processlogin.php” file

Next, we will modify the “processlogin.php” file and here’s the modified code:

<?php

require('connect.php');
require('session.php');
if (isset($_POST['btnlogin'])) {


  $email = trim($_POST['email']);
  $upass = trim($_POST['password']);
  $h_upass = sha1($upass);
if ($upass == ''){
     ?>    <script type="text/javascript">
                alert("Password is missing!");
                window.location = "login.php";
                </script>
        <?php
}else{
//create some sql statement             
        $sql = "SELECT * FROM  `tblmember` WHERE  `email` =  '" . $email . "' AND  `password` =  '" . $h_upass . "'";
        $result = $conn->query($sql);

        if ($result){
        //get the number of results based n the sql statement
        //check the number of result, if equal to one   
        //IF theres a result
            if ( $result->num_rows > 0) {
                //store the result to a array and passed to variable found_user
                $found_user  = mysqli_fetch_array($result);

                //fill the result to session variable
                $_SESSION['MEMBER_ID']  = $found_user['id']; 
                $_SESSION['FIRST_NAME'] = $found_user['fName']; 
                $_SESSION['LAST_NAME']  =  $found_user['lName']; 
           
             ?>    <script type="text/javascript">
                      //then it will be redirected to index.php
                      window.location = "index.php";
                  </script>
             <?php        
           
        
            } else {
            //IF theres no result
              ?>    <script type="text/javascript">
                alert("Username or Password Not Registered! Contact Your administrator.");
                window.location = "index.php";
                </script>
        <?php

            }

         } else {
                 # code...
        echo "Error: " . $sql . "<br>" . $conn->error;
        }
        
    }       
} 
 $conn->close();
?>

After modifying these PHP files, you can now test it on your browser.