How To Make Login Page In Php And Mysql

PHP Programming

Creating a login page is a fundamental aspect of web development, especially when it comes to building secure websites. In this article, I will guide you through the process of creating a login page using PHP and MySQL. As an experienced web developer, I have found this combination to be powerful and reliable when it comes to handling user authentication.

To begin with, let’s talk about PHP. PHP is a server-side scripting language that is widely used for web development. It allows us to dynamically generate web pages and interact with databases. By combining PHP with MySQL, a popular open-source database management system, we can create a robust login system that securely stores user credentials.

First, we need to set up our MySQL database. Start by creating a new database and a table to store the user information. The table should have columns for the user’s ID, username, password, and any other relevant information you want to collect.

CREATE DATABASE login_system;
USE login_system;

username VARCHAR(50) NOT NULL,
password VARCHAR(255) NOT NULL

Once our database is set up, we can move on to creating the login page itself. We’ll start by creating the HTML form that allows users to input their credentials. The form should have fields for the username and password, along with a submit button.

<form method="POST" action="login.php">
<input type="text" name="username" placeholder="Username"><br>
<input type="password" name="password" placeholder="Password"><br>
<input type="submit" value="Login">

Now let’s move on to the PHP code that handles the login process. In a separate file, let’s call it ‘login.php’, we’ll write the code to check whether the entered credentials match any records in our database.

// Establish a database connection
$conn = mysqli_connect('localhost', 'username', 'password', 'login_system');

// Retrieve the entered username and password
$username = $_POST['username'];
$password = $_POST['password'];

// Query the database to check if the user exists
$query = "SELECT * FROM users WHERE username='$username'";
$result = mysqli_query($conn, $query);

// Check if a record is returned
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$hashedPassword = $row['password'];

// Verify the entered password with the stored hash
if (password_verify($password, $hashedPassword)) {
echo "Login successful! Welcome, $username!";
// Perform any additional actions or redirect to a different page
} else {
echo "Invalid password. Please try again.";
} else {
echo "User not found. Please check your credentials.";

// Close the database connection

Finally, let’s add some personal touches to our login page. You can enhance the design using CSS to make it visually appealing. Additionally, you may want to implement features like password reset functionality or remember me options to improve the user experience.


In this article, we explored how to create a login page using PHP and MySQL. We discussed the importance of secure user authentication and the role of PHP and MySQL in achieving this. We covered the steps involved in setting up the database, creating the HTML form, and handling the login process with PHP code. By personalizing the design and adding extra features, you can create a robust and user-friendly login page for your website.

Now that you have the knowledge, it’s time to put it into action and create your own login page. Remember, security should always be a priority, so make sure to implement the necessary measures to protect user data. Happy coding!