First create a database table in MySql :-
Than create a Sign Up form using html.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form method="post" action="database.php">
<fieldset style="width:30%">
<legend>Registration Form</legend>
<table align="center">
<tr>
<td>First Name :</td>
<td><input type="text" name="fname"/></td>
</tr>
<tr>
<td>Last Name :</td>
<td><input type="text" name="lname"/></td>
</tr>
<tr>
<td>Select UserName :</td>
<td><input type="text" name="uname"/></td>
</tr>
<tr>
<td>Email ID :</td>
<td><input type="text" name="email"/></td>
</tr>
<tr>
<td>Password :</td>
<td><input type="password" name="pw"/></td>
</tr>
<tr>
<td></td>
<td><input id="button" name="submit" type="submit" value="Sign Up"/></td>
</tr>
</table>
</fieldset>
</form>
</body>
</html>
write the following code in the Database.php :-
<?php
$cn=mysql_connect('localhost','root','');
$cd=mysql_select_db('Mahi',$cn); //Mahi is a Database Name
if(isset($_POST['submit']))
{
SignUp();
}
function SignUp()
{
if(!empty($_POST['uname'])) //checking the 'uname' is empty or have some text
{
$query = mysql_query("SELECT * FROM cf1 WHERE UserName = '$_POST[uname]'
OR UserName='$_POST[uname]' and Email='$_POST[email]' OR
Email='$_POST[email]'"); //cf1 is a Table name of a Database
if(!$row = mysql_fetch_array($query))
{
newuser();
}
else
{
echo "SORRY...This is Aready Registered User.";
}
}
}
function NewUser()
{
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$uname = $_POST['uname'];
$email = $_POST['email'];
$pw = $_POST['pw'];
$query = "INSERT INTO CF1(First_Name,Last_Name,UserName,Email,Password) VALUES ('$fname','$lname','$uname','$email','$pw')";
$data = mysql_query ($query);
if($data)
{
echo "YOUR REGISTRATION IS COMPLETED...";
}
}
?>
Output :-
