Registration form in PHP and MySQL with validation; In this tutorial, i am going to show you how to build user/student/customer registration form in PHP and MySQL with validation.
In this tutorial, i will create registration html form with bootstrap 4 library and add server side validation on it. Then store user/student registration form data into MySQL database.
And through this tutorial; you can download free source code of user/student registration form in php and mysql with validation.
Registration Form in PHP and MySQL with Validation
Follow the below given steps and build student/user registration form in php and mysql with validation:
- Step 1 – Create PHP Project
- Step 2 – Create Database Table And Connect App to DB
- Step 3 – Create Registration PHP File
Step 1 – Create PHP Project
In step 1, Navigate to your local web server directory. And inside this directory, create one directory. And you can name this folder anything.
Here, I will “demo” the name of this folder. Then open this folder in any text editor (i will use sublime text editor).
Step 2 – Create Database Table And Connect App to DB
In step 2, you need to create database and table. So run the following sql query to create database and table:
CREATE DATABASE my_db; CREATE TABLE users( id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, name varchar(255) NOT NULL, email varchar(255) NOT NULL, contact varchar(255) NOT NULL, password varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Then create a php file that named mydbCon. Which is used to connect phpmyadmin mysql database to project (demo).
So, now create mydbCon file and add the below given code into your file:
<?php $hName='localhost'; // host name $uName='root'; // database user name $password=''; // database password $dbName = "my_db"; // database name $conn= mysqli_connect($hName,$uName,$password,"$dbName"); if(!$conn){ die('Could not Connect MySql Server:' .mysql_error()); } ?>
Step 3 – Create Registration PHP File
In step 3, create a php file that named register.php. This file will display PHP registration form and store user/student registration from data to MySQL database. Now, you need to add the following registration form code into register.php file:
<?php require_once "mydbCon .php"; if (isset($_POST['signup'])) { $name = mysqli_real_escape_string($conn, $_POST['name']); $email = mysqli_real_escape_string($conn, $_POST['email']); $mobile = mysqli_real_escape_string($conn, $_POST['mobile']); $password = mysqli_real_escape_string($conn, $_POST['password']); $cpassword = mysqli_real_escape_string($conn, $_POST['cpassword']); if (!preg_match("/^[a-zA-Z ]+$/",$name)) { $name_error = "Name must contain only alphabets and space"; } if(!filter_var($email,FILTER_VALIDATE_EMAIL)) { $email_error = "Please Enter Valid Email ID"; } if(strlen($password) < 6) { $password_error = "Password must be minimum of 6 characters"; } if(strlen($mobile) < 10) { $mobile_error = "Mobile number must be minimum of 10 characters"; } if($password != $cpassword) { $cpassword_error = "Password and Confirm Password doesn't match"; } if (!$error) { if(mysqli_query($conn, "INSERT INTO users(name, email, mobile ,password) VALUES('" . $name . "', '" . $email . "', '" . $mobile . "', '" . md5($password) . "')")) { header("location: register.php"); exit(); } else { echo "Error: " . $sql . "" . mysqli_error($conn); } } mysqli_close($conn); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Simple Registration Form in PHP with Validation | laratutorials.com</title> <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <div class="container"> <div class="row"> <div class="col-lg-8 col-offset-2"> <div class="page-header"> <h2>Registration Form in PHP with Validation</h2> </div> <p>Please fill all fields in the form</p> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> <div class="form-group"> <label>Name</label> <input type="text" name="name" class="form-control" value="" maxlength="50" required=""> <span class="text-danger"><?php if (isset($name_error)) echo $name_error; ?></span> </div> <div class="form-group "> <label>Email</label> <input type="email" name="email" class="form-control" value="" maxlength="30" required=""> <span class="text-danger"><?php if (isset($email_error)) echo $email_error; ?></span> </div> <div class="form-group"> <label>Mobile</label> <input type="text" name="mobile" class="form-control" value="" maxlength="12" required=""> <span class="text-danger"><?php if (isset($mobile_error)) echo $mobile_error; ?></span> </div> <div class="form-group"> <label>Password</label> <input type="password" name="password" class="form-control" value="" maxlength="8" required=""> <span class="text-danger"><?php if (isset($password_error)) echo $password_error; ?></span> </div> <div class="form-group"> <label>Confirm Password</label> <input type="password" name="cpassword" class="form-control" value="" maxlength="8" required=""> <span class="text-danger"><?php if (isset($cpassword_error)) echo $cpassword_error; ?></span> </div> <input type="submit" class="btn btn-primary" name="signup" value="submit"> Already have a account?<a href="login.php" class="btn btn-default">Login</a> </form> </div> </div> </div> </body> </html>
Conclusion
Registration form in PHP and MySQL with validation; In this tutorial, You have learned how to build user/student/customer registration form in PHP and MySQL with validation.
Be First to Comment