How To Make Login Page Php Mysql

PHP Programming

Creating a login page with PHP and MySQL can be a powerful tool for any web developer. Being able to secure your web applications and provide access to authenticated users is essential for many websites. In this article, I will guide you through the process of creating a login page using PHP and MySQL, sharing my personal tips and insights along the way.

Setting Up the Database

The first step in creating a login page with PHP and MySQL is to set up the database. You can start by creating a new database in MySQL, or you can use an existing one if you have it already. I recommend creating a new database specifically for your login page to keep things organized.

Once you have your database set up, you will need to create a table to store the login information. The table should have columns for the username, password, and any additional user information you want to store. For this example, let’s create a table named “users” with columns “id”, “username”, and “password”.

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

Creating the Login Form

Now that we have our database set up, we can start building the login form. The login form will typically include two input fields, one for the username and one for the password. We will also need a submit button to send the login data to the server for processing.

Here is an example of a basic login form:

<form action="login.php" method="post">
<label for="username">Username:</label>
<input type="text" name="username" id="username" required>

<label for="password">Password:</label>
<input type="password" name="password" id="password" required>

<input type="submit" value="Login">

Validating the Login

Once the user submits the login form, we need to validate the entered credentials against the data stored in the MySQL database. For security reasons, we should never store passwords in plain text. Instead, we will store the hashed version of the password.

Here is an example of how you can validate the login credentials:

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

// Retrieve the user's data from the database based on the entered username
$query = "SELECT * FROM users WHERE username='$enteredUsername'";
$result = mysqli_query($connection, $query);
$user = mysqli_fetch_assoc($result);

// Compare the entered password with the hashed password stored in the database
if ($user && password_verify($enteredPassword, $user['password'])) {
// Login successful, redirect to the home page
header('Location: home.php');
} else {
// Login failed, show error message
echo "Invalid username or password";

Adding Personal Touches with CSS and Design

Now that we have the basic functionality of our login page, we can add some personal touches and improve the design. You can use CSS to style the login form and make it visually appealing. Consider using a responsive design to ensure your login page looks good on all devices.

Here is an example of how you can style the login form:

.login-form {
max-width: 400px;
margin: 0 auto;
padding: 20px;
background: #f0f0f0;
border-radius: 5px;

.login-form label, .login-form input[type="text"], .login-form input[type="password"] {
display: block;
width: 100%;
margin-bottom: 10px;

.login-form input[type="submit"] {
width: 100%;
background: #4CAF50;
color: white;
padding: 10px;
border: none;
border-radius: 5px;
cursor: pointer;

.login-form input[type="submit"]:hover {
background: #45a049;


Creating a login page with PHP and MySQL is an essential skill for web developers. It allows you to secure your web applications and provide a personalized experience for your users. By following the steps outlined in this article, you can create a secure and visually appealing login page that enhances the overall user experience.

If you want to learn more about PHP and MySQL, I highly recommend checking out the official documentation and exploring online tutorials and resources. Happy coding!