All TalkersCode Topics

Follow TalkersCode On Social Media - A Social Media Network for developers Join Now ➔

Simple Login Page In PHP With Database Source Code

Last Updated : Mar 11, 2024

Simple Login Page In PHP With Database Source Code

In this article we will show you the solution of simple login page in PHP with database source code, the purpose of this topic is to learn how to create a PHP MySQL Login System with PHP and a MySQL database.

In this article, you will find a few steps that you need to follow in order to create a login system using MySQL.

The prerequisites for creating the login module need to be discussed before we can create the login system.

We will now discuss the idea of how to login page simply in php with database source code with example.

Step By Step Guide On Simple Login Page In PHP With Database Source Code :-


   define('DB_SERVER', 'localhost:3036');
   define('DB_USERNAME', 'root');
   define('DB_PASSWORD', 'rootpassword');
   define('DB_DATABASE', 'database');


      // username and password sent from form
      $myusername = mysqli_real_escape_string($db,$_POST['username']);
      $mypassword = mysqli_real_escape_string($db,$_POST['password']);
      $sql = "SELECT id FROM admin WHERE username = '$myusername' and passcode = '$mypassword'";
      $result = mysqli_query($db,$sql);
      $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
      $active = $row['active'];
      $count = mysqli_num_rows($result);
      // If result matched $myusername and $mypassword, table row must be 1 row
      if($count == 1) {
         $_SESSION['login_user'] = $myusername;
         header("location: welcome.php");
      }else {
         $error = "Check Your Login Username or Password is invalid";
      <title>Login Page</title>
      <style type = "text/css">
         body {
            font-family:Arial, Helvetica, sans-serif;
         label {
         .box {
            border:#666666 solid 1px;
   <body bgcolor = "#FFFFFF">
      <div align = "center">
         <div style = "width:300px; border: solid 1px #333333; " align = "left">
            <div style = "background-color:#333333; color:#FFFFFF; padding:3px;"><b>Login</b></div>
            <div style = "margin:30px">
               <form action = "" method = "post">
                  <label>UserName :</label><input type = "text" name = "username" class = "box"/><br /><br />
                  <label>Password :</label><input type = "password" name = "password" class = "box" /><br/><br />
                  <input type = "submit" value = " Submit "/><br />
               <div style = "font-size:11px; color:#cc0000; margin-top:10px"><?php echo $error; ?></div>


      <title>Welcome </title>
      <h1>Welcome <?php echo $login_session; ?></h1>
      <h2><a href = "logout.php">Sign Out</a></h2>
   if(session_destroy()) {
      header("Location: login.php");


   $user_check = $_SESSION['login_user'];
   $ses_sql = mysqli_query($db,"select username from admin where username = '$user_check' ");
   $row = mysqli_fetch_array($ses_sql,MYSQLI_ASSOC);
   $login_session = $row['username'];
  1. A connection between the database and the PHP script is established in the first line of the configuration file.
  2. An existing session can be resumed or a new one initiated with the session_start() function.
  3. A POST request is confirmed if the if block checks if it's POST.
  4. SQL injection is prevented by escaping any special characters in the username and password variables that are returned by the mysqli_real_escape_string() function.
  5. By using the username and password entered in the admin table, a SQL query searches for the id field within the admin table.
  6. SQL queries are executed using the mysqli_query() function, and the results are stored in the $result variable.
  7. Associative array data is received as an input to mysqli_fetch_array() and stored in the $row variable using the mysqli_fetch_array() function. In MySQL, the MYSQLI_ASSOC parameter specifies the association between elements in the array.
  8. A $row array key named 'active' is assigned to the $active variable.
  9. By calling mysqli_num_rows(), you count the number of rows returned by the SQL query and record them in a variable called $count.
  10. A valid login credentials are determined when $count equals 1, resulting in the user being directed to welcome.php using the header() function. Using the session_register() function, the user name is also registered with the session, and is stored in the $_SESSION superglobal array.
  11. Whenever $count doesn't equal 1, an error message indicates that the login credentials are invalid.
  12. A login form is created by using HTML code that contains two text boxes: one for username and one for password.
  13. In this case, the action attribute is set to an empty string and the form is submitted to the same page.
  14. Using a font size of 11px and a color of #cc0000, the error message is displayed within a div element. Whenever the login credentials are incorrect, the $error variable is populated.

Conclusion :-

As a result, we have successfully learned how to login page simply in php with database source code.

The purpose of this tutorial was to show you how to create a simple login page using PHP and MySQL.

By initializing the $_SESSION variable when the user traverses to other pages and destroying it when he or she logs out, you can detect the user's intent.

I hope this article on simple login page in PHP with database source code helps you and the steps and method mentioned above are easy to follow and implement.

Author Image About Anjali

Experienced Computer Programmer with a broad range of experience in technology. Strengths in application development and Object Oriented architecture design, front end programming, usability and multimedia technology. Expert in coding languages such as C, C++ Java, JavaScript, PHP and more.

Follow Anjali On Linkedin 🡪