simpe user registration script in php mysql

6 Steps to Create Simple User Registration Script in PHP and MySql

This is a Simple User Registration Script in PHP and MySQL. By using this user can easily register, filling username, email, password fields. After submitting form, the data will be stored in a database table. So that next time user can login with the login credentials which are used while user registration.

Here these are a series of articles

These scripts are for beginner learners, who want to learn the concept of user registration, login, login activation and forgot password.

Steps to creating Simple User Registration Script in PHP and MySql

Create a database
Creating table with five fields
- id
- username
- email
- password
- active
Create form in html
Adding styles to form
Connect to the database using php
Writing logic for user registration script in php

Below is the Video on PHP User Login Registration Script With All Features

Do you want to Build Secure Members Area for your Website?

I've good News for you! Created a Video Course with 5 Hours of Content to create secure members area section

Join on Udemy for $10

Join on Skillshare Free for 2 Months

1. Create a Database

For creating a database, login to phpmyadmin, then click on Databases tab. And in the input field enter database name and click on create database button.

2. Creating a Database table

After creating Database, Create a database table for users, it’s simple table with user name, email, password, active and an id as primary key and also it is auto incremented.

id is the primary key and auto incremented.
Username field will be used for storing username
email field will be used for storing email address of user, this will be used to send forgotten password by email in this series.
Password field will store password of user in normal format.
active state is for checking the user is active or blocked user, If the user is blocked then he can’t login to system.
- User login script with activation check

Import this below sql into your database.

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
)

CREATE TABLE IF NOT EXISTS `user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(255) NOT NULL,

`email` varchar(255) NOT NULL,

`password` varchar(255) NOT NULL,

`active` tinyint(1) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `username` (`username`)

)

3. Create form in html

Save this file as register.php, Here this is simple html for generating form. This form contains user name field, email, password a submit button and a link to login.php file. Here i’m adding some classes to the HTML, Later i can add some styles.

<div class="container">
      <form class="form-signin" method="POST">
        <h2 class="form-signin-heading">Please Register</h2>
        <div class="input-group">
	  <span class="input-group-addon" id="basic-addon1">@</span>
	  <input type="text" name="username" class="form-control" placeholder="Username" required>
	</div>
        <label for="inputEmail" class="sr-only">Email address</label>
        <input type="email" name="email" id="inputEmail" class="form-control" placeholder="Email address" required autofocus>
        <label for="inputPassword" class="sr-only">Password</label>
        <input type="password" name="password" id="inputPassword" class="form-control" placeholder="Password" required>
        <button class="btn btn-lg btn-primary btn-block" type="submit">Register</button>
        <a class="btn btn-lg btn-primary btn-block" href="login.php">Login</a>
      </form>
</div>

<h2 class="form-signin-heading">Please Register</h2>

</div>

<label for="inputEmail" class="sr-only">Email address</label>

<label for="inputPassword" class="sr-only">Password</label>

<button class="btn btn-lg btn-primary btn-block" type="submit">Register</button>

<a class="btn btn-lg btn-primary btn-block" href="login.php">Login</a>

</form>

</div>

4. Adding styles to form

Here i’ve added some styles to form, so that it will look good. I’m using Bootstrap with some custom styles.

Put this code in head section of register.php file

<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" >

<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" >

<link rel="stylesheet" href="styles.css" >

<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>

Save this code as styles.css file

body {
  padding-top: 40px;
  padding-bottom: 40px;
  background-color: #eee;
}

.form-signin {
  max-width: 330px;
  padding: 15px;
  margin: 0 auto;
}
.form-signin .form-signin-heading,
.form-signin .checkbox {
  margin-bottom: 10px;
}
.form-signin .checkbox {
  font-weight: normal;
}
.form-signin .form-control {
  position: relative;
  height: auto;
  -webkit-box-sizing: border-box;
     -moz-box-sizing: border-box;
          box-sizing: border-box;
  padding: 10px;
  font-size: 16px;
}
.form-signin .form-control:focus {
  z-index: 2;
}
.form-signin input[type="email"] {
  margin-bottom: -1px;
  border-bottom-right-radius: 0;
  border-bottom-left-radius: 0;
}
.form-signin input[type="password"] {
  margin-bottom: 10px;
  border-top-left-radius: 0;
  border-top-right-radius: 0;
}

body {

padding-top: 40px;

padding-bottom: 40px;

background-color: #eee;

}

.form-signin {

max-width: 330px;

padding: 15px;

margin: 0 auto;

}

.form-signin .form-signin-heading,

.form-signin .checkbox {

margin-bottom: 10px;

}

.form-signin .checkbox {

font-weight: normal;

}

.form-signin .form-control {

position: relative;

height: auto;

-webkit-box-sizing: border-box;

-moz-box-sizing: border-box;

box-sizing: border-box;

padding: 10px;

font-size: 16px;

}

.form-signin .form-control:focus {

z-index: 2;

}

.form-signin input[type="email"] {

margin-bottom: -1px;

border-bottom-right-radius: 0;

border-bottom-left-radius: 0;

}

.form-signin input[type="password"] {

margin-bottom: 10px;

border-top-left-radius: 0;

border-top-right-radius: 0;

}

5. Connect to the database

Create a file with name connect.php. Here i’m connecting to database and selecting the database.

User correct database name & user credentials.

<?php
$connection = mysqli_connect('localhost', 'root', 'Rvm@i[9)0?~=');
if (!$connection){
    die("Database Connection Failed" . mysqli_error($connection));
}
$select_db = mysqli_select_db($connection, 'test');
if (!$select_db){
    die("Database Selection Failed" . mysqli_error($connection));
}

<?php

$connection = mysqli_connect('localhost', 'root', 'Rvm@i[9)0?~=');

if (!$connection){

die("Database Connection Failed" . mysqli_error($connection));

}

$select_db = mysqli_select_db($connection, 'test');

if (!$select_db){

die("Database Selection Failed" . mysqli_error($connection));

}

6. Writing logic for user registration script in php

All the registration process done in one single php file, in this file we will display an html form for user to register. In the PHP section we will first connect to the database, then we will select the database, if the values are posted, then we are running a MySQL query it will insert the values into the database.

Add this code register.php file above the html code. That means right before step 3 code. If you have any dobut, you can check the final code.

<?php
	require('connect.php');
    // If the values are posted, insert them into the database.
    if (isset($_POST['username']) && isset($_POST['password'])){
        $username = $_POST['username'];
	$email = $_POST['email'];
        $password = $_POST['password'];
 
        $query = "INSERT INTO `user` (username, password, email) VALUES ('$username', '$password', '$email')";
        $result = mysqli_query($connection, $query);
        if($result){
            $smsg = "User Created Successfully.";
        }else{
            $fmsg ="User Registration Failed";
        }
    }
    ?>

<?php

require('connect.php');

// If the values are posted, insert them into the database.

if (isset($_POST['username']) && isset($_POST['password'])){

$username = $_POST['username'];

$email = $_POST['email'];

$password = $_POST['password'];

$query = "INSERT INTO `user` (username, password, email) VALUES ('$username', '$password', '$email')";

$result = mysqli_query($connection, $query);

if($result){

$smsg = "User Created Successfully.";

}else{

$fmsg ="User Registration Failed";

}

Add this code after opening form tag, this code is used to display the status message.

      <?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?>
      <?php if(isset($fmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fmsg; ?> </div><?php } ?>

1 2	<?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?> <?php if(isset($fmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fmsg; ?> </div><?php } ?>

Complete Code of Register.php

<?php
	require('connect.php');
    // If the values are posted, insert them into the database.
    if (isset($_POST['username']) && isset($_POST['password'])){
        $username = $_POST['username'];
	$email = $_POST['email'];
        $password = $_POST['password'];
 
        $query = "INSERT INTO `user` (username, password, email) VALUES ('$username', '$password', '$email')";
        $result = mysqli_query($connection, $query);
        if($result){
            $smsg = "User Created Successfully.";
        }else{
            $fmsg ="User Registration Failed";
        }
    }
    ?>
<html>
<head>
	<title>User Registeration Using PHP & MySQL</title>
	
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" >

<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" >

<link rel="stylesheet" href="styles.css" >

<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>

<div class="container">
      <form class="form-signin" method="POST">
      
      <?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?>
      <?php if(isset($fmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fmsg; ?> </div><?php } ?>
        <h2 class="form-signin-heading">Please Register</h2>
        <div class="input-group">
	  <span class="input-group-addon" id="basic-addon1">@</span>
	  <input type="text" name="username" class="form-control" placeholder="Username" required>
	</div>
        <label for="inputEmail" class="sr-only">Email address</label>
        <input type="email" name="email" id="inputEmail" class="form-control" placeholder="Email address" required autofocus>
        <label for="inputPassword" class="sr-only">Password</label>
        <input type="password" name="password" id="inputPassword" class="form-control" placeholder="Password" required>
        <div class="checkbox">
          <label>
            <input type="checkbox" value="remember-me"> Remember me
          </label>
        </div>
        <button class="btn btn-lg btn-primary btn-block" type="submit">Register</button>
        <a class="btn btn-lg btn-primary btn-block" href="login.php">Login</a>
      </form>
</div>

</body>

</html>

<?php

require('connect.php');

// If the values are posted, insert them into the database.

if (isset($_POST['username']) && isset($_POST['password'])){

$username = $_POST['username'];

$email = $_POST['email'];

$password = $_POST['password'];

$query = "INSERT INTO `user` (username, password, email) VALUES ('$username', '$password', '$email')";

$result = mysqli_query($connection, $query);

if($result){

$smsg = "User Created Successfully.";

}else{

$fmsg ="User Registration Failed";

}

<html>

<head>

<title>User Registeration Using PHP & MySQL</title>

</head>

<body>

<?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?>

<?php if(isset($fmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fmsg; ?> </div><?php } ?>

<h2 class="form-signin-heading">Please Register</h2>

</div>

<label for="inputEmail" class="sr-only">Email address</label>

<label for="inputPassword" class="sr-only">Password</label>

<label>

<input type="checkbox" value="remember-me"> Remember me

</label>

</div>

<button class="btn btn-lg btn-primary btn-block" type="submit">Register</button>

<a class="btn btn-lg btn-primary btn-block" href="login.php">Login</a>

</form>

</div>

</body>

</html>

Next Steps After User Registration

About code is just simple user registration code for educational purpose, if you are implementing this code in the real-world application then you should use these techniques.

Sanitize the Data

First of all, you should sanitize the data. This will helps to stop the sql injection & cross-site scripting XSS attacks. To stop sql injection use mysqli_real_escape_sting PHP function. And for XSS attacks you should use htmlentities PHP function.

Example of the code is below, you should apply this to all the submitted values.

$username = mysqli_real_escape_string($connection, $_POST['username']);

1	$username = mysqli_real_escape_string($connection, $_POST['username']);

Password Encryption

In the above code, you can see I’m storing passwords in plain text method. That is not recommended method to store passwords in the database. Use password_hash PHP function to store the passwords in database, it’s a secure method to store the password in database.

If you follow these above methods, you can create a secure user registration process for your web application.

If you want to learn other things you can read other posts – registration, login, user login with activation check, and sending forgotten password by email, Check Username Availability .

I hope this article helped you to learn user login using PHP and MySQL . To get latest news and updates follow us on twitter & facebook, subscribe to newsletter. If you have any feedback please let us know by using comment form.

Do you want to Build Secure Members Area for your Website?

I've good News for you! Created a Video Course with 5 Hours of Content to create secure members area section

Join on Udemy for $10

Join on Skillshare Free for 2 Months

registration form in php simple registration form in php PHP registration script php registration form php code for registration form user registration form in php php register script php code for registration php registration form with database connection code php signup script

Vivek Vengala

Vivek Vengala is a Online Entrepreneur, Web Developer from Hyderabad India.

Click Here to Leave a Comment Below 26 comments

Balaji

You there step no 6 file name what ? what can be save that file

Azams

IMHO, using mysqli extension is better than mysql ext. but thanks for this good tutorial. 🙂

Elena Calvillo

THANK YOU SO MUCH!, I understand better this subject now =)

Rajneesh

I have been reading tons of blogs regarding this, but i was not satisfied. Thanks to the author and thanks to codingcyber:)

Prakash

Simple and clean php steps here. Thank you so much!

Saurabh Prakash

Your post is just awesome sir
I also tried so much to make a login and registration system

Thanks u so much and your one is just awesome

Andrade

<
<

I don't where to write d above code in d form opening tag. Pls i need some help writing it.

Hi Andrade,

Please put the code in same file above HTML opening tag, or else you can unlock the complete code and save it in a file.

Let me know, if you still have any problem.

sujata

Hi sir,
This is sujata,i want to know what is code of Registration form and how to connect to that with database.plz let me know
Thanks&regards
sujata

Hello Sujata,

You can watch my video series to understand about this.

If you have any questions let me know…

Tanzil

When I run it it tells me there is an error on line 10

Hello Tanzil,

Post your error, so that I can help…

Proll

Hi!

I did everything like you, but i have issue to send data to Mysql in database, when i ran this code

$query = “INSERT INTO ‘login’ (‘username’,’password’,’email’)VALUES(‘$username’,’$password’,’$email’)”;
$result = mysqli_query($connection, $query);
if($result){
$smsg = “User Created Successfully.”;
echo “success;
}else{
$fmsg =”User Registration Failed”;
echo “Error occured”;
I wounder what I am doing wrong?

thank you for sharing this with us

Hi Proll,

What is the error message you are getting…

Hi again!

it shows no error, but when I use echo in if/else statement, it shows the else one. Error occurred. I tried different syntax for query part, still does not work

$smsg = “User Created Successfully.”;
echo “success;
}else{
$fmsg =”User Registration Failed”;
echo “Error occured”; <— this is occurred.

saikiran

can i copy the entire register.php and use for entire reg form !!

Hi saikiran,

Yes, you can use it.

nurulahsan

Vivek Vengala,Thanks a lot, So helpful. Its easy to understand.

Shrabany Roy

where I input the last section ?

(Add this code after opening form tag, this code is used to display the status message.)

Hi Sharabany,

You can use this anywhere you want to display the messages. Right place is in div with container class block.

Eddie

I have followed the steps exacly, but I get ‘User Registration failed’ when trying to register :/

Hi Eddie,

In your SQL query use die & mysqli_error PHP functions. so that you can get the exact error message.

csy

Hi! Good day! I’m encountering some problems. I can’t seem to connect it to my database. Keep on User Registration Failed.

Update connect.php file with your database credentials, don’t forget to upload SQL file

Mayank

Hi I have advanced login system given by you but I don’t know its configuration
so can u tell me this?

Hi Mayank,

After extracting the zip file, you will find SQL file. Import it using PHPMyAdmin and update database configuration options.

6 Steps to Create Simple User Registration Script in PHP and MySql

Steps to creating Simple User Registration Script in PHP and MySql

Below is the Video on PHP User Login Registration Script With All Features

1. Create a Database

2. Creating a Database table

3. Create form in html

4. Adding styles to form

5. Connect to the database

6. Writing logic for user registration script in php

Complete Code of Register.php

Next Steps After User Registration

Sanitize the Data

Password Encryption

Download User Login Registration Script For Free

Related Posts

Vivek Vengala

Leave a Reply:

Download User Login Registration Script For Free

6 Steps to Create Simple User Registration Script in PHP and MySql

Steps to creating Simple User Registration Script in PHP and MySql

Below is the Video on PHP User Login Registration Script With All Features

1. Create a Database

2. Creating a Database table

3. Create form in html

4. Adding styles to form

5. Connect to the database

6. Writing logic for user registration script in php

Complete Code of Register.php

Next Steps After User Registration

Sanitize the Data

Password Encryption

Download User Login Registration Script For Free

Share this:

Related Posts

Vivek Vengala

Leave a Reply:

Download User Login Registration Script For Free