In every website the user need to create the account and login to that account to access the services of that website. In this guide, I will teach you how to build a php login page using mysql as a database.
Next, you need to create a table in a database called “consumer.”
I am using user table in the tutorial example.
CREATE TABLE 'user' ( 'id' int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, 'fname' varchar(80) NOT NULL, 'lname' varchar(80) NOT NULL, 'email' varchar(80) NOT NULL, 'password' varchar(80) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Create a new connect.php file for database connectivity.
<?php
session_start();
$host = "localhost"; /* Host name */
$user = "root"; /* User */
$password = ""; /* Password */
$dbname = "Registration"; /* Database name */
$con = mysqli_connect($host, $user, $password,$dbname);
// Check connection
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
}
Create a <form method='post' action='' >.
If $error message is not empty and the value of $error message is shown on the screen. Similarly, if $success message is not null, the value of $success message will be shown on the computer.
NOTE – Value is allocated to the vector $error message and $success message.
Submit in accordance with the conditions.
Add input fields for entering – first name, last name, username , password, and password validation.
Also, add a submit button
<?php
include "connect.php";
?>
<!DOCTYPE html>
<html>
<head>
<title>Registration form with MySQL and PHP</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<!-- Bootstrap JS -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class='container'>
<div class='row'>
<div class='col-md-6' >
<form method='post' action=''>
<h1>Registration Form</h1>
<?php
if(!empty($error_message)){
?>
<div class="alert alert-danger">
<strong>Error!</strong> <?= $error_message ?>
</div>
<?php
}
?>
<?php
// Display Success message
if(!empty($success_message)){
?>
<div class="alert alert-success">
<strong>Success!</strong> <?= $success_message ?>
</div>
<?php
}
?>
<div class="form-group">
<label for="fname">First Name:</label>
<input type="text" class="form-control" name="fname" id="fname" required="required" maxlength="80">
</div>
<div class="form-group">
<label for="lname">Last Name:</label>
<input type="text" class="form-control" name="lname" id="lname" required="required" maxlength="80">
</div>
<div class="form-group">
<label for="email">Email address:</label>
<input type="email" class="form-control" name="email" id="email" required="required" maxlength="80">
</div>
<div class="form-group">
<label for="password">Password:</label>
<input type="password" class="form-control" name="password" id="password" required="required" maxlength="80">
</div>
<div class="form-group">
<label for="pwd">Confirm Password:</label>
<input type="password" class="form-control" name="confirmpassword" id="confirmpassword" onkeyup='' required="required" maxlength="80">
</div>
<button type="submit" name="btnsignup" class="btn btn-default">Submit</button>
</form>
</div>
</div>
</div>
</body>
</html>
Add the following code in <head> section.
On <form > submit assign $_POST values in variables.
Validate the values –
To check the input values are valid or not created a $isValid = true variable. When any validity is incorrect, then allocate incorrect to $isValid and the record is not added.
- First, check if all values are entered or not. If not entered then assign
falseto$isValidand"Please fill all fields."to$error_message. - Check if entered password and confirm password are equal or not. If not equal then assign
falseto$isValidand"Confirm password not matching."to$error_message. - Check if
$emailvariable value has a valid email or not. If not valid then assignfalseto$isValidand"Invalid Email-ID."to$error_message. - Check if email-id already exists in
userstable or not. If available then assignfalseto$isValidand"Email-ID is already existed."to$error_message.
If $isValid has real value, add a new record in the user table and add “Successed account” to $success message.
Complete code for this
<?php
$error_message = "";$success_message = "";
// Register user
if(isset($_POST['btnsignup'])){
$fname = trim($_POST['fname']);
$lname = trim($_POST['lname']);
$email = trim($_POST['email']);
$password = trim($_POST['password']);
$confirmpassword = trim($_POST['confirmpassword']);
$isValid = true;
// Check fields are empty or not
if($fname == '' || $lname == '' || $email == '' || $password == '' || $confirmpassword == ''){
$isValid = false;
$error_message = "Please fill all fields.";
}
// Check if confirm password matching or not
if($isValid && ($password != $confirmpassword) ){
$isValid = false;
$error_message = "Confirm password not matching";
}
// Check if Email-ID is valid or not
if ($isValid && !filter_var($email, FILTER_VALIDATE_EMAIL)) {
$isValid = false;
$error_message = "Invalid Email-ID.";
}
if($isValid){
// Check if Email-ID already exists
$stmt = $con->prepare("SELECT * FROM user WHERE email = ?");
$stmt->bind_param("s", $email);
$stmt->execute();
$result = $stmt->get_result();
$stmt->close();
if($result->num_rows > 0){
$isValid = false;
$error_message = "Email-ID is already existed.";
}
}
// Insert records
if($isValid){
$insertSQL = "INSERT INTO users(fname,lname,email,password ) values(?,?,?,?)";
$stmt = $con->prepare($insertSQL);
$stmt->bind_param("ssss",$fname,$lname,$email,$password);
$stmt->execute();
$stmt->close();
$success_message = "Account created successfully.";
}
}
?>
