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']."'"); } } } ?>