Now a day’s Multi Step Forms are more popular due to more users friendly. The Multi Step Form provides easy step by step procedure to complete long FORM. When there is long FORM with too many fields, you can break the large FORM into multiple smaller Forms with few input fields on each Form to make it more convenient for users. So in this tutorial you learn how to implement Multi Step Form with Progress Bar using jQuery. We will design Multi Step Form with Progress Bar using Bootstrap and handle steps to display different forms using jQuery and store from data into MySQL database using PHP.
So let’s start the coding.
Before begin, take a look on files structure. We have used following files for this tutorial.
Step1: Database Table For User Account
In this tutorial we will implement functionality to create user account with multiple forms. For this we need a database table to store user details. So we will create table user to store user account details using below MySQL query.
Step2: Make MySQL Database Connection
We will create db_connect.php file to make connection with MySQL database to store user information.
Steps3: Design Multiple FORM HTML
We will design FORM HTML and Progress Bar using Bootstrap in index.php.
We will also need CSS code in head tag in index.php to hide forms that kept inside <fieldset> to show and hide using jQuery.
Steps4: Multi Form Steps with jQuery
In JavaScript file form.js, we will handle functionality to display next/previous FORM on button click using jQuery. We will also handle Form submit and validation using jQuery. Below is code to handle multiple form display, form submit and validation using jQuery.
Steps5: Save Multi Form Data to MySQL Database
Now finally in multi_form_action.php, we will handle functionality to save user Form submitted values into MySQL database.
You can view the live demo from the Demo link and can download the script from the Download link below.
Demo [sociallocker]Download[/sociallocker]
So let’s start the coding.
Before begin, take a look on files structure. We have used following files for this tutorial.
- db_connect.php
- index.php
- multi_form_action.php
- form.js
Step1: Database Table For User Account
In this tutorial we will implement functionality to create user account with multiple forms. For this we need a database table to store user details. So we will create table user to store user account details using below MySQL query.
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`mobile` int(11) NOT NULL,
`address` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Step2: Make MySQL Database Connection
We will create db_connect.php file to make connection with MySQL database to store user information.
<?php
/* Database connection start */
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "demos";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
?>
Steps3: Design Multiple FORM HTML
We will design FORM HTML and Progress Bar using Bootstrap in index.php.
<div class="container">
<h2>Example: Multi Step Form using jQuery, Bootstrap and PHP</h2>
<div class="progress">
<div class="progress-bar progress-bar-striped active" role="progressbar" aria-valuemin="0" aria-valuemax="100"></div>
</div>
<div class="alert alert-success hide"></div>
<form id="register_form" novalidate action="form_action.php" method="post">
<fieldset>
<h2>Step 1: Add Account Details</h2>
<div class="form-group">
<label for="email">Email address*</label>
<input type="email" class="form-control" required id="email" name="email" placeholder="Email">
</div>
<div class="form-group">
<label for="password">Password*</label>
<input type="password" class="form-control" name="password" id="password" placeholder="Password">
</div>
<input type="button" class="next-form btn btn-info" value="Next" />
</fieldset>
<fieldset>
<h2> Step 2: Add Personal Details</h2>
<div class="form-group">
<label for="first_name">First Name</label>
<input type="text" class="form-control" name="first_name" id="first_name" placeholder="First Name">
</div>
<div class="form-group">
<label for="last_name">Last Name</label>
<input type="text" class="form-control" name="last_name" id="last_name" placeholder="Last Name">
</div>
<input type="button" name="previous" class="previous-form btn btn-default" value="Previous" />
<input type="button" name="next" class="next-form btn btn-info" value="Next" />
</fieldset>
<fieldset>
<h2>Step 3: Add Contact Information</h2>
<div class="form-group">
<label for="mobile">Mobile*</label>
<input type="text" class="form-control" name="mobile" id="mobile" placeholder="Mobile Number">
</div>
<div class="form-group">
<label for="address">Address</label>
<textarea class="form-control" name="address" placeholder="Communication Address"></textarea>
</div>
<input type="button" name="previous" class="previous-form btn btn-default" value="Previous" />
<input type="submit" name="submit" class="submit btn btn-success" value="Submit" />
</fieldset>
</form>
</div>
We will also need CSS code in head tag in index.php to hide forms that kept inside <fieldset> to show and hide using jQuery.
<style type="text/css">
#register_form fieldset:not(:first-of-type) {
display: none;
}
</style>
Steps4: Multi Form Steps with jQuery
In JavaScript file form.js, we will handle functionality to display next/previous FORM on button click using jQuery. We will also handle Form submit and validation using jQuery. Below is code to handle multiple form display, form submit and validation using jQuery.
$(document).ready(function(){
var form_count = 1, previous_form, next_form, total_forms;
total_forms = $("fieldset").length;
$(".next-form").click(function(){
previous_form = $(this).parent();
next_form = $(this).parent().next();
next_form.show();
previous_form.hide();
setProgressBarValue(++form_count);
});
$(".previous-form").click(function(){
previous_form = $(this).parent();
next_form = $(this).parent().prev();
next_form.show();
previous_form.hide();
setProgressBarValue(--form_count);
});
setProgressBarValue(form_count);
function setProgressBarValue(value){
var percent = parseFloat(100 / total_forms) * value;
percent = percent.toFixed();
$(".progress-bar")
.css("width",percent+"%")
.html(percent+"%");
}
// Handle form submit and validation
$( "#register_form" ).submit(function(event) {
var error_message = '';
if(!$("#email").val()) {
error_message+="Please Fill Email Address";
}
if(!$("#password").val()) {
error_message+="<br>Please Fill Password";
}
if(!$("#mobile").val()) {
error_message+="<br>Please Fill Mobile Number";
}
// Display error if any else submit form
if(error_message) {
$('.alert-success').removeClass('hide').html(error_message);
return false;
} else {
return true;
}
});
});
Steps5: Save Multi Form Data to MySQL Database
Now finally in multi_form_action.php, we will handle functionality to save user Form submitted values into MySQL database.
<?php
if (isset($_POST['submit'])) {
$email = mysqli_real_escape_string($conn, $_POST['email']);
$password = mysqli_real_escape_string($conn, $_POST['password']);
$first_name = mysqli_real_escape_string($conn, $_POST['first_name']);
$last_name = mysqli_real_escape_string($conn, $_POST['last_name']);
$mobile = mysqli_real_escape_string($conn, $_POST['mobile']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
if(mysqli_query($conn, "INSERT INTO user(email, pass, first_name, last_name, mobile, address) VALUES('".$email."', '" . $password . "', '". $first_name."', '".$last_name."', '".$mobile."', '". $address."')")) {
echo "You're Registered Successfully!";
} else {
echo "Error in registering...Please try again later!";
}
}
?>
You can view the live demo from the Demo link and can download the script from the Download link below.
Demo [sociallocker]Download[/sociallocker]