How To Make Login Page In Php Using Database

Creating a login page in PHP using a database is an essential part of developing a secure website. In this article, I will guide you through the process of building a login page that will allow users to authenticate themselves using their unique credentials. With a solid understanding of PHP and database management, you can create a robust login system that will protect your website from unauthorized access.

Setting Up the Database

The first step in creating a login page in PHP is to set up the database that will store user information. Start by creating a new database using a tool like phpMyAdmin or the command line. Let’s call it “login_system”. Inside the database, create a table named “users” with the following columns:

  1. id – an auto-incrementing integer to serve as the primary key
  2. username – a unique field to store the user’s username
  3. password – a field to store the user’s password (make sure to encrypt it for security)

Creating the Login Page

Next, create a new PHP file for the login page. Let’s call it “login.php”. Start by including the necessary HTML and CSS to style the page. You can customize the design to match the theme of your website.

In the body of the “login.php” file, create a form that will allow users to enter their username and password. The form should have two input fields: one for the username and one for the password. Additionally, include a “Login” button to submit the form.

When the form is submitted, the data should be sent to a PHP script for processing. In the PHP script, retrieve the username and password entered by the user and perform the following steps:

  1. Connect to the database using the appropriate credentials.
  2. Query the database to check if the entered username exists.
  3. If the username exists, retrieve the corresponding password from the database.
  4. Compare the entered password with the password retrieved from the database.
  5. If the passwords match, the user is authenticated and can be redirected to the desired page. If the passwords do not match, display an error message.

Adding Personal Touches

While building the login page and the associated functionality, it’s important to add your personal touches to make it unique and user-friendly. Consider the following ideas:

  • Design a visually appealing login form with an intuitive layout.
  • Add form validation to ensure that all required fields are filled out before submission.
  • Include a “Forgot Password” feature that allows users to reset their password.
  • Implement a “Remember Me” feature to remember the user’s login credentials for future visits.


Creating a login page in PHP using a database is a fundamental step towards building a secure website. By following the steps outlined in this article, you can create a robust login system that ensures only authorized users can access your website’s protected content. Remember to add your personal touches to make the login page user-friendly and visually appealing. Happy coding!