Get 25% More Free Bitcoin! freebitco.in

How to connect HTML Registration Form using PHP and MySQL

April 2, 2022January 30, 2021

Learn, How to connect HTML Registration Form to MySQL Database with PHP with simple coding and easy video.
First, you have to make a form using HTML code which I provide below.

HTML form (form.html)

<!DOCTYPE HTML>
<html>
<head>
  <title>Register Form</title>
</head>
<body>
 <form action="insert.php" method="POST">
  <table>
   <tr>
    <td>Name :</td>
    <td><input type="text" name="username" required></td>
   </tr>
   <tr>
    <td>Password :</td>
    <td><input type="password" name="password" required></td>
   </tr>
   <tr>
    <td>Gender :</td>
    <td>
     <input type="radio" name="gender" value="m" required>Male
     <input type="radio" name="gender" value="f" required>Female
    </td>
   </tr>
   <tr>
    <td>Email :</td>
    <td><input type="email" name="email" required></td>
   </tr> 
   <tr>
    <td>Phone no :</td>
    <td>
     <select name="phoneCode" required>
      <option selected hidden value="">Select Code</option>
      <option value="977">977</option>
      <option value="978">978</option>
      <option value="979">979</option>
      <option value="973">973</option>
      <option value="972">972</option>
      <option value="974">974</option>
     </select>
     <input type="phone" name="phone" required>
    </td>
   </tr>
   <tr>
    <td><input type="submit" value="Submit" name="submit"></td>
   </tr>
  </table>
 </form>
</body>
</html>

Inside the above code, you can see <form action="insert.php" method="POST">where, in action, I write insert.php which means we are sending our form data to insert.php.

The output of the above code

How to connect HTML Register Form to MySQL Database with PHP — Registration form in HTML

Server-side code (insert.php)

<?php
if (isset($_POST['submit'])) {
    if (isset($_POST['username']) && isset($_POST['password']) &&
        isset($_POST['gender']) && isset($_POST['email']) &&
        isset($_POST['phoneCode']) && isset($_POST['phone'])) {
        
        $username = $_POST['username'];
        $password = $_POST['password'];
        $gender = $_POST['gender'];
        $email = $_POST['email'];
        $phoneCode = $_POST['phoneCode'];
        $phone = $_POST['phone'];

        $host = "localhost";
        $dbUsername = "root";
        $dbPassword = "";
        $dbName = "test";

        $conn = new mysqli($host, $dbUsername, $dbPassword, $dbName);

        if ($conn->connect_error) {
            die('Could not connect to the database.');
        }
        else {
            $Select = "SELECT email FROM register WHERE email = ? LIMIT 1";
            $Insert = "INSERT INTO register(username, password, gender, email, phoneCode, phone) values(?, ?, ?, ?, ?, ?)";

            $stmt = $conn->prepare($Select);
            $stmt->bind_param("s", $email);
            $stmt->execute();
            $stmt->bind_result($resultEmail);
            $stmt->store_result();
            $stmt->fetch();
            $rnum = $stmt->num_rows;

            if ($rnum == 0) {
                $stmt->close();

                $stmt = $conn->prepare($Insert);
                $stmt->bind_param("ssssii",$username, $password, $gender, $email, $phoneCode, $phone);
                if ($stmt->execute()) {
                    echo "New record inserted sucessfully.";
                }
                else {
                    echo $stmt->error;
                }
            }
            else {
                echo "Someone already registers using this email.";
            }
            $stmt->close();
            $conn->close();
        }
    }
    else {
        echo "All field are required.";
        die();
    }
}
else {
    echo "Submit button is not set";
}
?>

Explaining server-side code

Declaring variables and check, are they empty or not

In line 3, we check ( $username, $password, $gender, $email, $phoneCode and $phone) are not set or not. If these are not set then we go all the way down to line 55. If these are set then code from line 7 will execute.

By using a code from line 7 to 12, we are grabbing data from HTML form and store it into PHP variables ( $username, $password, $gender, $email, $phoneCode and $phone).

Make a database connection

From line 14 to line 17 we declare a variables ( $host, $dbUsername, $dbPassword and $dbname) and assign a value for connecting a database.

Then, in line 19 we make a database connection and assign it into a $conn

After that, in line 21 we check that, is our database connected. If there is no connection then we display error and exit. If a database is connected we continue from line 24.

Declare SQL query in a variable

In, line 25, there is a SELECT query to select data from a database and in line 26, there is an INSERT query to insert user record into a database.

Using the prepared statement

After that, we are using the prepared statement to run our query and protect our database from SQL injection.

28. We Run SELECT query

29. We are Passing an email value into a SELECT query and we define “s” because email is a string. You can see below and know, which parameter you should use your data type.

i – integer
d – double
s – string
b – BLOB

You can learn more about above i, d, s, and b in Prepared Statements

In a SELECT query, we are selecting only email so, in line 31, we catch that email value.

In, line 34, we store the number of row in a variable $rnum from our result.

Insert user’s data

Then in, line 36, we check is our result contains 0 rows, if yes then we continue running our coding if not, we jump into line 48 and give a message “Someone already registers using this email”.

If there are zero rows in a result then that means, this user’s data is not already stored in our database. So we can store this record in our database as a new user. But first, we need to close a prepared statement for the SELECT query and start a prepared statement for an INSERT query.

And after data is inserted into a database, we give a message “New record inserted successfully”. And, that’s it.

This is how you connect how to create registration form in HTML with database.

You may also like to read:

4.6 15 votes

Article Rating

88 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments