MD5 Registration using PDO in PHP

Submitted by azalea zenith on Friday, October 14, 2016 - 12:29.

In this tutorial, we are going to learn on how to create MD5 Registration using PDO in PHP. This simple project helps you to create registration with an MD5 function to encrypt the password field. The feature of this simple project is to save all the data from the field then the password will be encrypted it’s because of the MD5 function that we set in the PDO query. We construct simple registration form.

<div style="width:50%;">
   <form method="POST" action="insert-query.php">
      <div>
         <label>First Name</label>
         <input type="text" name="first_name" placeholder="First Name . . . . ." required>
      </div>
      <div>
         <label>Last Name</label>
         <input type="text" name="last_name" placeholder="Last Name . . . . .">
      </div>
      <div>
         <label>Email Address</label>
         <input type="email" name="email" placeholder="Email Address . . . . ." required>
      </div>
      <div>
         <label>Password</label>
         <input type="password" name="password" placeholder="Password . . . . ." required>
      </div>
      <div>
         <label>Re-type Password</label>
         <input type="password" name="re_password" placeholder="Re-type Password . . . . ." required>
      </div>
      <button type="submit" name="btn_submit">Submit</button>
   </form>
</div>

And, we have to create the query to insert data into the database using PDO in PHP. Copy and paste to your editor and save it as "insert-query.php". Those variables below, used this to get the information from the form field given by the user to register a new record of data. As you can see, it has MD5 code in the password and re-type password. The purpose of this is to encrypt the password, so that, in the database the password would be encrypted.

<?php
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$email = $_POST['email'];
$password = md5($_POST['password']);
$re_password = md5($_POST['re_password']);
?>

We create a simple trapper, like, we have password and re-type password. If the user type their desired password but the re-type password field does not match in the password field, this simple trapper will give an alert message to the user that their information is incorrect.

<?php
 
if ($password != $re_password)
        {
        echo "<script>alert('Your Password does not match . . .'); window.location = 'index.php' </script>";
        }
?>

PHP query below, this source code used to insert new record of data in the database. Using INSERT Statement. After that, if the data was inserted to the database, the query give an alert message to the user that their data inserted was successful.

<?php
$database->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$insert_query = "INSERT INTO tbl_user (first_name, last_name, email, password, re_password)
VALUES (?, ?, ?, ?, ?)";
$insert = $database->prepare($insert_query);
$insert->execute(array(
        $first_name,
        $last_name,
        $email,
        $password,
        $re_password
));
echo "<script>alert('Account successfully added!'); window.location='index.php'</script>";
?>

This is the full source code for PHP query.

<?php
require_once ('database.php');
 
if (isset($_POST['btn_submit']))
        {
        $first_name = $_POST['first_name'];
        $last_name = $_POST['last_name'];
        $email = $_POST['email'];
        $password = md5($_POST['password']);
        $re_password = md5($_POST['re_password']);
        if ($password != $re_password)
                {
                echo "<script>alert('Your Password does not match . . .'); window.location = 'index.php' </script>";
                }
          else
                {
                $database->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                $insert_query = "INSERT INTO tbl_user (first_name, last_name, email, password, re_password)
VALUES (?, ?, ?, ?, ?)";
                $insert = $database->prepare($insert_query);
                $insert->execute(array(
                        $first_name,
                        $last_name,
                        $email,
                        $password,
                        $re_password
                ));
                echo "<script>alert('Account successfully added!'); window.location='index.php'</script>";
                }
        }
 
?>

Database Name: db_md5 Here's the output. Result

This tutorial suit for the beginners who really want to know how to construct PHP query using PDO and to insert data into the database. If you have a question in this tutorial, don't hesitate to leave a comment below. Thank you.

Add new comment

1310 views