this code is not yet completed. But it is very helpful with your assignment.
registration.php
<?php
session_start();
include("include/config.php");
$btn_submit = $_POST['btnsubmit'];
$txt_fname = $_POST['txtfname'];
$txt_lname = $_POST['txtlname'];
$txt_user = $_POST['txtuser'];
$txt_pass = $_POST['txtpassword'];
$txt_email = $_POST['txtemail'];
$txt_reemail = $_POST['txtreemail'];
$gender = $_POST['gender'];
$txt_month = $_POST['txtmonth'];
$txt_date = $_POST['txtdate'];
$txt_year = $_POST['txtyear'];
$code = session_id();
$validemail="^[_+a-z0-9-]+(\.[_+a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]{1,})*\.([a-z]{2,}){1}$";
if(isset($btn_submit)){
$check_verify_email = mysql_query("SELECT * FROM tbluser_verify WHERE email='".$txt_email."'");
$check_email = mysql_query("SELECT * FROM tbluser WHERE email='".$txt_email."'");
if(!mysql_num_rows($check_verify_email) && !mysql_num_rows($check_user)){
$insert_user = mysql_query("INSERT INTO tbluser (fname,lname,email,username,password,gender,month,date,year,active) VALUES ('".$txt_fname."','".$txt_lname."','".$txt_email."','".$txt_user."','".md5($txt_pass)."','".$gender."','".$txt_month."','".$txt_date."','".$txt_year."','0')",$cnn);
$insert_user_verify = mysql_query("INSERT INTO tbluser_verify (email,code) VALUES('".$txt_email."','".$code."')",$cnn);
echo "Your Registration is complete Please see the link for activate<br>";
//echo "http://www.pisethnov.co.cc/active.php?email=$txt_email&&code=$code";
echo "active.php?email=$txt_email&&code=$code";
session_destroy();
}
else{
echo "Email Already Exist in Database.";
}
}
?>
<!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=utf-8" />
<title>User Registration</title>
</head>
<form action="#" method="post">
<table>
<tr><td colspan="3"><h2>User Registration Form</h2></td></tr>
<tr><td>First Name:</td><td colspan="2"><input type="text" name="txtfname" /></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="txtlname" /></td></tr>
<tr><td>Your Email:</td><td><input type="text" name="txtemail" /></td></tr>
<tr><td>Re-Enter Email:</td><td><input type="text" name="txtreemail" /></td></tr>
<tr><td>Username:</td><td><input type="text" name="txtuser" /></td></tr>
<tr><td>Password:</td><td><input type="password" name="txtpassword" /></td></tr>
<tr>
<td>I am:</td>
<td>
<select name="gender">
<option value="0">Select Gender:</option>
<option value="1">Female</option>
<option value="2">Male</option>
</select>
</td>
</tr>
<tr>
<td>Birthday:</td>
<td>
<input type="text" size="3" name="txtmonth" value="month" />
<input type="text" size="2" name="txtdate" value="date" />
<input type="text" size="4" name="txtyear" value="year"/>
</td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="btnsubmit" value="Register"</td>
</tr>
</table>
</form>
<body>
</body>
</html>
active.php
<?php
include("include/config.php");
if(isset($_GET['email'])&& isset($_GET['code'])){
$check_user_verify= mysql_query("SELECT * FROM tbluser_verify WHERE code='".$_GET['code']."' AND email='".$_GET['email']."'",$cnn);
if(mysql_num_rows($check_user_verify)){
$check_user = mysql_query("SELECT * FROM tbluser WHERE email='".$_GET['email']."'",$cnn);
if(mysql_num_rows($check_user)){
$ac="1";
//"UPDATE tblstudent SET gender='Male' WHERE studid='1'",$connect);
$insert = mysql_query("UPDATE tbluser SET active='".$ac."' WHERE email='".$_GET['email']."'");
echo "Welcome to the hell of PHP code...";
$delete = mysql_query("DELETE * FROM tbluser_verify WHERE code='".$_GET['code']."'");
}
}
}
?>
