How to make a Registration Form in PHP & MySQL Database

Hi Guys!! In this Blog you will learn how to create a database and make a registration form in PHP and MySQL using phpmyadmin. You can make a website with a registration form and make a database for it to save the form data.

To create a database:

Open phpmyadmin
Click create table and name it as simple_login.
Then name the database as “simple_login”.
After creating a database name, click the SQL and paste the below code.

CREATE TABLE IF NOT EXISTS `member` (

`mem_id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(30) NOT NULL,

`password` varchar(30) NOT NULL,

`fname` varchar(30) NOT NULL,

`lname` varchar(30) NOT NULL,

`address` varchar(100) NOT NULL,

`contact` varchar(30) NOT NULL,

`picture` varchar(100) NOT NULL,

`gender` varchar(10) NOT NULL,

PRIMARY KEY (`mem_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;

Creating a Form

To create a form and save it as index.php. To create a form, open your HTML code editor and paste the code below after the tag.

<tr>

<?php

$remarks=$_GET[‘remarks’];

if ($remarks==null and $remarks==””)

{

echo ‘Register Here’;

}

if ($remarks==’success’)

{

echo ‘Registration Success’;

}

</div></td>

</tr>

<tr>

<td width=”95″><div align=”right”>First Name:</div></td>

</tr>

<tr>

</tr>

<tr>

<td><div align=”right”>Gender:</div></td>

</tr>

<tr>

<td><div align=”right”>Address:</div></td>

</tr>

<tr>

<td><div align=”right”>Contact No.:</div></td>

</tr>

<tr>

<td><div align=”right”>Picture:</div></td>

</tr>

<tr>

<td><div align=”right”>Username:</div></td>

</tr>

<tr>

<td><div align=”right”>Password:</div></td>

</tr>

<tr>

</tr>

</table>

</form>

Creating our Connection

Next step is to create a database connection and save it as “connection.php”. This file is used to connect our form to database. This file serves as a bridge between our form and our database.

<?php

$mysql_hostname = “localhost”;

$mysql_user = “root”;

$mysql_password = “”;

$mysql_database = “registration”;

$prefix = “”;

$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die(“Could not connect database”);

mysql_select_db($mysql_database, $bd) or die(“Could not select database”);

Writing Our Save Script

Next step is to create our script that save our input data to database and save it as:

code_exec.php.

<?php

session_start();

include(‘connection.php’);

$fname=$_POST[‘fname’];

$lname=$_POST[‘lname’];

$mname=$_POST[‘mname’];

$address=$_POST[‘address’];

$contact=$_POST[‘contact’];

$pic=$_POST[‘pic’];

$username=$_POST[‘username’];

$password=$_POST[‘password’];

mysql_query(“INSERT INTO member(fname, lname, gender, address, contact, picture, username, password)VALUES(‘$fname’, ‘$lname’, ‘$mname’, ‘$address’, ‘$contact’, ‘$pic’, ‘$username’, ‘$password’)”);

header(“location: index.php?remarks=success”);

mysql_close($con);

Validating Input

To add some input validation using javascript, add the code below in the head tag of your index.php file. Input validation is used to make sure that all input field are filled out before saving the to database.

function validateForm()

{

var a=document.forms[“reg”][“fname”].value;

var b=document.forms[“reg”][“lname”].value;

var c=document.forms[“reg”][“mname”].value;

var d=document.forms[“reg”][“address”].value;

var e=document.forms[“reg”][“contact”].value;

var f=document.forms[“reg”][“pic”].value;

var g=document.forms[“reg”][“pic”].value;

var h=document.forms[“reg”][“pic”].value;

if ((a==null || a==””) && (b==null || b==””) && (c==null || c==””) && (d==null || d==””) && (e==null || e==””) && (f==null || f==””))

{

alert(“All Field must be filled out”);

return false;

}

if (a==null || a==””)

{

alert(“First name must be filled out”);

return false;

}

if (b==null || b==””)

{

alert(“Last name must be filled out”);

return false;

}

if (c==null || c==””)

{

alert(“Gender name must be filled out”);

return false;

}

if (d==null || d==””)

{

alert(“address must be filled out”);

return false;

}

if (e==null || e==””)

{

alert(“contact must be filled out”);

return false;

}

if (f==null || f==””)

{

alert(“picture must be filled out”);

return false;

}

if (g==null || g==””)

{

alert(“username must be filled out”);

return false;

}

if (h==null || h==””)

{

alert(“password must be filled out”);

return false;

}

</script>

So Guys 🙂 In this way you can create a database and make a registration form in PHP and MySQL. Hope you like this article. If you still need more help and assistance, please comment down below so that we can help you. Good Luck!!