File: /home/panama/public_html_old/signup.php
<?
include("include/config.php");
$db_sel = new database();
$pageid=7;
$db_sel->where("pageid=".$pageid);
$db_sel->selectstmt("cmspagemaster");
$pagetitle = $db_sel->f_pagetitle;
$pagemeta = $db_sel->f_pagemeta;
$pagemetadesc = $db_sel->f_pagemetadesc;
//$str_len=strlen($db_sel->f_pagedesc);
//if($str_len>1100)
//$description = substr($db_sel->f_pagedesc,0,1100)."...";
//else
$description = $db_sel->f_pagedesc;
?>
<!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" />
<meta name="description" content="<?=$pagemetadesc?>" />
<meta name="keywords" content="<?=$pagemeta?>"/>
<title><?=SITE_TITLE."- Services - ".$pagetitle?></title>
<!-- Stylesheets -->
<link rel="stylesheet" type="text/css" href="styles.css"/>
<!-- Javascript -->
<!--[if IE 6]><script src="js/ie6.js"></script><![endif]-->
<link rel="stylesheet" href="css/dropdownmenu.css" type="text/css" />
<script type="text/javascript" src="js/dropdownmenu.js"></script>
<? include('includescript.php')?>
</head>
<body>
<? include("header.php") ?>
<div id="contentwrapper">
<div class="contentcontainer">
<div class="maincontainer">
<div class="servicesbannerwrapper"><img src="images/banner_services.jpg" width="958" height="178" alt=""/></div>
</div>
<div class="maincontainer">
<div class="servicetextwrapper">
<div class="title">
<div class="breadcrumbs">
<ul>
<li class="first"><span class="titleicons"><img src="images/icon_services.png" width="40" height="42" alt=""/></span> Services</li>
<li><?=$pagetitle?></li>
</ul>
</div>
</div>
<div >
<font size="2">Please Fill up this form apply new user.</font>
<form action="signup.php" method="POST" onsubmit="return checkInput(this);">
<script type="text/javascript" language="javascript">
function checkInput(signupform)
{
if(signupform.txtEmail.value=="")
{
alert("Email Can not be empty!");
signupform.txtEmail.focus();
return false;
}
if(signupform.txtPassword.value=="")
{
alert("Password Can not be empty!");
signupform.txtPassword.focus();
return false;
}
if(signupform.txtComfirmPass.value=="")
{
alert("Confirm Password Can not be empty!");
signupform.txtComfirmPass.focus();
return false;
}
if(signupform.txtFirstName.value=="")
{
alert("First Name Can not be empty!");
signupform.txtFirstName.focus();
return false;
}
if(signupform.txtLastName.value=="")
{
alert("Last Name Can not be empty!");
signupform.txtLastName.focus();
return false;
}
if(signupform.txtPassword.value!=signupform.txtComfirmPass.value)
{
alert("Confirm Password is diffrent password!");
return false;
}
var myCheck=/^([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+@([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+\.[a-zA-Z]{2,3}$/;
if(!myCheck.test(signupform.txtEmail.value))
{
alert("Invalid Email!!!");
signupform.txtEmail.focus();
return false;
}
//alert("HaHa");
return true;
}
</script>
<table border="0" width="100%" id="table1">
<tr>
<td align="right">Email:</td>
<td><input type="text" name="txtEmail" size="52">*</td>
</tr>
<tr>
<td align="right">Password</td>
<td>
<input type="password" name="txtPassword" size="41">*</td>
</tr>
<tr>
<td align="right">Comfirm Password</td>
<td>
<input type="password" name="txtComfirmPass" size="41">*</td>
</tr>
<tr>
<td align="right">First name:</td>
<td><input type="text" name="txtFirstName" size="41">*</td>
</tr>
<tr>
<td align="right">Last name:</td>
<td><input type="text" name="txtLastName" size="41">*</td>
</tr>
<tr>
<td align="right" colspan="2">
<p align="center" style="text-align: center">
<input type="submit" value="Sign Up" name="submit" id="submit"> <input type="reset" value="Clear" name="reset" id="clear"></td>
</tr>
</table>
<p> </p>
</form>
</div>
</div>
<div class="servicesphotowrapper">
<div class="servicesphotocontainer">
<? include("right.php");?>
</div>
</div>
</div>
</div>
<? include('footer.php') ?>
</div>
<?php require_once ("include/ewconfig.php") ?>
<?php require_once ("include/db.php") ?>
<?php
require("include/class.phpmailer.php");
/*Create a New Visa user,send active Email*/
if (@$_POST["submit"] <> "")
{
$strEmail = @$_POST["txtEmail"];
$strPassword = @$_POST["txtPassword"];
$strFirstName = @$_POST["txtFirstName"];
$strLastName = @$_POST["txtLastName"];
$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
MySQL_query("SET NAMES 'utf8'");
/*Check Email*/
$StrCheck="select * from visa_user Where username='".$strEmail."'";
$query = phpmkr_query($StrCheck, $conn) or die("<font color='#FF0000'>ERROR: Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql."</font>");
if (phpmkr_num_rows($query) > 0)
{
echo "<script language=javascript>alert('This Email has aready existed!');</script>";
}
else
{
$sSql="select max(userid)+1 as userid from visa_user";
$query = phpmkr_query($sSql, $conn) or die("<font color='#FF0000'>ERROR: Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql."</font>");
$row = @phpmkr_fetch_array($query);
$query = phpmkr_query($sSql, $conn) or die("<font color='#FF0000'>ERROR: Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql."</font>");
$userid=$row["userid"];
if (empty($userid))
{
$userid=1;
}
else
{
}
$query = phpmkr_query($sSql, $conn) or die("<font color='#FF0000'>ERROR: Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql."</font>");
$StrSel="Insert into visa_user values(".$userid.",'".$strEmail."','".base64_encode($strPassword)."','".$strFirstName."','".$strLastName."','N')";
$query = phpmkr_query($StrSel, $conn) or die("<font color='#FF0000'>ERROR: Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql."</font>");
/*Send Email*/
$mail = new phpmailer();
$uniq_id = md5(uniqid(time()));
//$mail->SetLanguage('en', "language/");
$mail->IsSMTP();
$mail->IsHTML();
$mail->From = FROM_EMAIL;
$mail->FromName = FROM_NAME;
$mail->Host = EW_SMTPSERVER;
$mail->SMTPAuth = true; // turn on SMTP authentication
$mail->Username = EW_SMTPSERVER_USERNAME; // SMTP username
$mail->Password = EW_SMTPSERVER_PASSWORD; // SMTP password
$mail->Subject="Panama Visa Service";
// HTML body
$body = "Hello <font size=\"4\">". $strFirstName ." ". $strLastName ."</font>, <p>";
$body .= "<i>Your</i> Account has been created.<p>";
$body .= "Please Follow Link to <a href='".EW_SERVER_ROOT."active.php?userid=".$userid."&from=email'>active your account</a>.<br>";
$body .= "Please do not reply this Email.<br>";
$body .= "Sincerely, <br>";
$body .= "Panama Visa Service";
// Plain text body (for mail clients that cannot read HTML)
/*
$text_body = "Hello Eric Wang, \n\n";
$text_body .= "Your personal photograph to this message.\n\n";
$text_body .= "Sincerely, \n";
$text_body .= "phpmailer List manager";
*/
$mail->Body = $body;
$mail->AltBody = $text_body;
$mail->AddAddress($strEmail);
//$mail->AddStringAttachment($row["photo"], "YourPhoto.jpg");
if(!$mail->Send())
{
echo "Mailer Error: " . $mail->ErrorInfo;
}
else
{
}
// Clear all addresses and attachments for next loop
$mail->ClearAddresses();
$mail->ClearAttachments();
/*Relocate Page*/
$url="active.php?userid=".$userid."&from=web";
header("Location: $url");
}
}
else
{
}
?>
</body>
</html>