Expand|Select|Wrap|Line Numbers
- <?php
- $username="root";
- $password="";
- $database="keywest";
- $host="localhost";
- $msg="";
- mysql_connect($host,$username,$password);
- @mysql_select_db($database);
- if(!empty($_POST['register']))
- {
- $mail=$_POST['eml'];
- $firstname=$_POST['fnm'];
- $lastname=$_POST['lnm'];
- $address=$_POST['adr'];
- $city=$_POST['city'];
- $pin=$_POST['pin'];
- $state=$_POST['stt'];
- $country=$_POST['cnt'];
- $contact=$_POST['cntct'];
- $sex=$_POST['sex'];
- $pass1=$_POST['pwd1'];
- $pass2=$_POST['pwd2'];
- $status="inactive";
- $sql="SELECT * FROM user WHERE email='$mail'";
- $result=mysql_query($sql);
- $row = mysql_fetch_assoc($result);
- // Mysql_num_row is counting table row
- $num = mysql_num_rows($result);
- // If result matched $mail, table row must be 1 row
- if($num>0)
- {
- $msg="Please use another valid Email ID....";
- }
- else if($pass1!=$pass2)
- {
- $msg="Please repeat password properly ..... ";
- }
- else
- {
- //ini_set("SMTP","smtp.mydomain.com");
- //ini_set("smtp_port","25");
- //ini_set("sendmail_from","user@mydomain.com");
- //mail($To,$Subject,$Message,$From);
- $sql="insert into user values('$mail', '$pass1', '$firstname', '$lastname', '$status', '$address', '$city', '$pin', '$state', '$country', '$contact', '$sex')";
- mysql_query($sql);
- $to=$mail;
- $subject="KeyWest Account Activation..";
- $message="Welcome to KeyWest. You have created an account with us. Please go through the following link to activate your account.";
- $message=$message."\r\r http://localhost/KeyWest/Activation.php?var=".$mail;
- $message=$message."\r\r If this is an unwanted message for you, please use the following link.";
- $message=$message."\r\r http://localhost/KeyWest/DeActivate.php?var=".$mail;
- $header='From: ranadip.chakraborty@gmail.com';
- ini_set("SMTP","smtp.gmail.com");
- ini_set("smtp_port","587");
- ini_set("smtp_ssl","auto");
- ini_set("sendmail_from","ranadip.chakraborty@gmail.com");
- ini_set("auth_username","ranadip.chakraborty");
- ini_set("auth_password","Electronics");
- mail($to, $subject, $message, $header);
- $msg="Record Entered Successfully. Please check your email and activate your account....";
- }
- mysql_free_result($result);
- }
- ?>
- <html>
- <body background='Images/Back15.jpg' text='black'>
- <br><br>
- <center>
- <form action="NewRegister.php" method=POST>
- <center>
- <table cellpadding="0" cellspacing="0" border="0">
- <tr>
- <td width="14"><img src="TableImage/TL.png" width=14 height=23 border="0" /></td>
- <td background="Images/Back1.jpg" colspan="2" align="center">
- <font face='arial' size='4' color='maroon'><strong>
- Registration Form:
- </font>
- </td>
- <td width="14"><img src="TableImage/TR.png" width=14 height=23 border="0" /></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Email-ID:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='eml'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>First Name:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='fnm'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Last Name:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='lnm'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Address:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='adr'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>City:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='city'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Pin:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='pin'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>State:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='stt'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Country:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='cnt'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Contact:</font></td>
- <td background="Images/Back1.jpg"><input type='text' name='cntct'/></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Sex:</font></td>
- <td background="Images/Back1.jpg"> <input type='radio' name='sex' value="M" />Male
- <input type='radio' name='sex' value="F" />Female</td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Login Password:</font></td>
- <td background="Images/Back1.jpg"><input type='password' name='pwd1'></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"></td>
- <td background="Images/Back1.jpg" align="right"><font face='verdana' size='2'>Repeat Password:</font></td>
- <td background="Images/Back1.jpg"><input type='password' name='pwd2'></td>
- <td background="Images/Back1.jpg"></td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg" align="center" colspan="2"><input type='submit' name='register' value=' Create Account '></td>
- <td background="Images/Back1.jpg"> </td>
- </tr>
- <tr>
- <td><img src="TableImage/BL.png" width=14 height=23 border="0" /></td>
- <td background="Images/Back1.jpg"> </td>
- <td background="Images/Back1.jpg"> </td>
- <td><img src="TableImage/BR.png" width=14 height=23 border="0" /></td>
- </tr>
- </table>
- </center>
- <p align=Center><?php echo $msg ?></p>
- </form>