How To Create Login Page In PHP/MySQL

Submitted by alpha_luna on Friday, April 29, 2016 - 17:04.

Related Code: How To Create Registration Page In PHP/MySQL In the previous tutorial, we create on How To Create Registration Page In PHP/MySQL. For the continuation of Registration Page Tutorial it should have a Login Page, that's why I create this tutorial on How To Create Login Page In PHP/MySQL. This program works by the user to enter their username or email and password to open the new page. This login page also has a log out function, where the user signs out their account after clicking the logout button on the home page. After the user clicks the logout button, the user cannot go back to the previous page. If the user wants to go back to the previous page, the user must log in again to go back on the previous page. So, let's do this. First, we are going to make our database.

Creating our Table

We are going to make our database. To create a database:

Open the PHPMyAdmin
Create a database and name it as "user_login".
After creating a database name, click the SQL and kindly copy the code below.

--
-- Table structure for table `user`
--
 
CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(100) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `username2` varchar(100) NOT NULL,
  `birthday` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `number` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `email2` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `password2` varchar(100) NOT NULL,
  `profile_picture` varchar(100) NOT NULL,
  `cover_picture` varchar(100) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

Second, we are going to make our form field.

Creating Form Field

This form field that the user types their username or email and password to log in.

        <form method="post" action="signin_form.php" enctype="multipart/form-data">
                        <table>
                        <h1>Welcome to Biobook</h1>
                        <h2>Log in</h2>
                                <tr>
                                        <td><label>Email</label></td>
                                        <td><input type="email" name="email" placeholder="[email protected]" class="form-1" title="Enter your email" required /></td>
                                </tr>
                                <tr>
                                        <td><label>Password</label></td>
                                        <td><input type="password" name="password" placeholder="~~~~~~~~~~" class="form-1" title="Enter your password" required /></td>
                                </tr>
                                <tr>
                                        <td></td>
                                        <td></td>
                                </tr>
                                <tr>
                                        <td></td>
                                        <td></td>
                                </tr>
                                <tr>
                                        <td></td>
                                        <td></td>
                                </tr>
                                <tr>
                                        <td colspan="2">
                                        <input type="submit" name="submit" value="Log in" class="btn-sign-in" title="Log in" />
                                        <input type="reset" name="cancel" value="Cancel" class="btn-sign-up" title="Cancel" />
                                        </td>
                                </tr>
                        </table>
        </form>

Third, we are going to make our database connection.

Database Connection

This PHP Script is our database. Copy and paste this then save it as "database.php".

<?php
mysql_select_db('user_login',mysql_connect('localhost','root',''))or die(mysql_error());
?>

Fourth, we are going to make our saving PHP Script.

Login Script - PHP

                                        
<?php
include('includes/database.php');
 
if(isset($_POST['submit']))
{
        $email=$_POST['email'];
        $password=$_POST['password'];
{
        $result = mysql_query("SELECT * FROM user WHERE email = '$email' and password='$password'")
        or die(mysql_error());
        
        $row = mysql_fetch_array($result);
        $count = mysql_num_rows($result);                               
                if ($count == 0) 
                        {
                        echo "<script>alert('Please check your username and password!'); window.location='signin.php'</script>";
                        } 
                else if ($count > 0)
                        {
                                session_start();
                                $_SESSION['id'] = $row['user_id'];
                                header("location:home.php");
                        }
}                               
}
?>

Fifth, we are going to make our Home Page.

Creating Home Page

<!DOCTYPE html>
<html>
 
        <head>
                <title>Welcome  To Biobook - Sign up, Log in, Post </title>
                <link rel="stylesheet" type="text/css" href="css/home.css">
        </head>
 
<body>
<?php include ('session.php');?>
 
        <div id="header">
                <div class="head-view">
                        <ul>
                                <li><a href="home.php" title="Biobook"><b>biobook</b></a></li>
                                <li></li>
                                <li></li>
                                <li></li>
                                <li></li>
                                <li></li>
                                <li></li>
                                <li><a href="timeline.php" title="<?php echo $username ?>"><label><?php echo $username ?></label></a></li>
                                <li><a href="home.php" title="Home"><label class="active">Home</label></a></li>
                                <li><a href="profile.php" title="Home"><label>Profile</label></a></li>
                                <li><a href="photos.php" title="Settings"><label>Photos</label></a></li>
                                <li><a href="logout.php" title="Log out"><button class="btn-sign-in" value="Log out">Log out</button></a></li>
                        </ul>
                </div>
        </div>
 
<center>
<h1>
        This is your Home Page
</h1>
</center>
 
</body>
 
</html>

Output of our Home Page Result - Home Page

So, this is it, just follow the steps to have this Login Page or you can download the full source code below by clicking the "Download Code" button below. Related Code: How To Create Registration Page In PHP/MySQL Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Add new comment

618 views