Create Registration Form Using PHP
Registration form is a way to get the basic information of a user like their name, email contact no, gender etc. Mostly Registration form is used on dynamic websites to store the users information into database. In Future these data are used for many purposes like online business user login (user authentication) to send newsletter etc.
Creating a registration form in php is very easy. Do not need to worry If you don’t know how to create it in php . After reading this article you can easily create a registration form in PHP without having any trouble. Basically there are five steps to create it.
- Create a Database.
- Create a Registration Table in Database.
- Establish a Database Connection.
- Create a Registration Form Using Html.
- Use PHP scripts to store it in Database.
Example to Create a Registration Form in PHP
In this example, the focus is on how to create a fully functional Registration form (Not on CSS) using PHY/MYSQL with validation.
The first step is to create a database and a table in PHYMYSQL
Example of Database and Table
Create a Database in MYSQL(phpmyadmin)
Now Create a Table in MYSQL(phpmyadmin)
OR you can create a table using PHP MYSQL script. The table has the following fields
- ID datatype – int(11)
- username datatype – varchar(100)
- email datatype – varchar(100)
- password datatype – varchar(100)
ID int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
username varchar(100) NOT NULL,
email varchar(100) NOT NULL,
password varchar(100) NOT NULL
) ;
The next step is to create a registration form
<!DOCTYPE html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Registration Form Using PHP</title> <link rel="stylesheet" type="text/css" href="style.css"> </head> <body data-rsssl=1> <div class="registration-form-block"> <div class="registration-form-work"> <h2 class="form-title">Registration Form</h2> <form method="post" action="register.php" name="registration_form" class="registration_form"> <div class="form-row"> <label>Username</label> <input type="text" name="username" placeholder="enter your name"> </div> <div class="form-row"> <label>Email</label> <input type="email" name="email" placeholder="enter your email"> </div> <div class="form-row"> <label>Password</label> <input type="password" name="password" placeholder="enter your password"> </div> <div class="form-row"> <button type="submit" class="submit-button" name="submit_button">SUBMIT</button> </div> </form> </body> </html>
After writing these html code you create a style.css file . The link of how to add css file into html already written in above code.
* {
margin: 0px;
padding: 0px;
}
body {
background: #d5d5d5;
}
.registration_form{
padding-top: 15px;
}
.registration-form-block{
width: 30%;
margin: 0px auto;
padding: 15px;
border: 1px solid #B0C4DE;
border-radius: 0px 0px 10px 10px;
background:#fff;
}
.form-title{
text-align:center;
background: #f58220;
color:#fff;
padding:10px;
border-radius: 0px 0px 10px 10px;
border:8px;
}
label {
display: block;
text-align: left;
margin: 6px;
font-size: 18px;
}
input {
height: 28px;
width: 94%;
border-radius: 4px;
border: 1px solid #ccc;
padding: 5px 8px;
font-size: 15px;
}
.submit-button {
padding: 10px;
font-size: 15px;
border: none;
border-radius: 5px;
width: 100%;
margin-top: 5px;
background: #f58220;
color:#fff;
}
.registration-form-work{
padding:20px;
}
Create Database Connection and PHP Script
Now create the database connection. And write the phpcode on the register.php which stores the form values into database. Create connection.php and use the code which is given below.
$mysqli=new mysqli('localhost','root','','users');
if($mysqli->connect_error){
echo $mysqli->connect_error;
}
- localhost – Use the server name
- root – Username
- Use password at the place of thrid blank value
- Uers – Database Name
After creating the database connection use the phpscript on register.php
include('connection.php');
$error=array();
$username=$_POST['username'];
$email=$_POST['email'];
$password=$_POST['password'];
if($username=='')
{
$error[]="username field is required";
}
if($email=='')
{
$error[]="Email field is required";
}
if($password=='')
{
$error[]="Password field is required";
}
$count=count($error);
if($count>0)
{
foreach($error as $value)
{
echo $value."
";
}
}
$mysqli->query("INSERT INTO users(username,email,password) VALUES('$username','$email','$password')");
if($mysqli->error)
{ echo $mysqli->error;
}
else{
echo "
Successfully Registered
"; }
}
