session_start();
include('txt/topbarout.txt');
include('txt/leftbarout.txt');
include('txt/centerbegin.txt');
$fnameOk = FALSE;
$lnameOk = FALSE;
$emailOk = FALSE;
$usernameOk = FALSE;
$passwordOk = FALSE;
$referralOk = FALSE;
$subOk = FALSE;
$addressOk = FALSE;
$cityOk = FALSE;
$stateOk = FALSE;
$postcodeOk = FALSE;
$telephoneOk = FALSE;
$dobOk = FALSE;
$errorMsg = "";
function dbcon_checker() {
if(mysql_errno())
die(mysql_errno() . ": " . mysql_error());
}
if(isset($_POST['Submit3']) && !isset($_POST['reset'])) {
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$gender = $_POST['gender'];
$email = $_POST['email'];
$username = $_POST['username'];
$password = $_POST['password'];
$password1 = $_POST['password1'];
$referral = $_POST['referral'];
$referral_other = $_POST['referral_otheer'];
$address1 = $_POST['address1'];
$address2 = $_POST['address2'];
$address3 = $_POST['address3'];
$city = $_POST['city'];
$state = $_POST['state'];
$postcode = $_POST['postcode'];
$country = $_POST['country'];
$home_no = $_POST['home_no'];
$home_fax = $_POST['home_fax'];
$sub_details = $_POST['sub'];
$dobd = $_POST['dobd'];
$dobm = $_POST['dobm'];
$doby = $_POST['doby'];
$mob_no = $_POST['mob_no'];
$_SESSION['firstname'] = $_POST['firstname'];
$_SESSION['lastname'] = $_POST['lastname'];
$_SESSION['gender'] = $_POST['gender'];
$_SESSION['email'] = $_POST['email'];
$_SESSION['username'] = $_POST['username'];
$_SESSION['password'] = $_POST['password'];
$_SESSION['password1'] = $_POST['password1'];
$_SESSION['referral'] = $_POST['referral'];
$_SESSION['referral_other'] = $_POST['referral_otheer'];
$_SESSION['address'] = $_POST['address1'] . " " . $_POST['address2'] . " " .$_POST['address3'];
$_SESSION['city'] = $_POST['city'];
$_SESSION['state'] = $_POST['state'];
$_SESSION['postcode'] = $_POST['postcode'];
$_SESSION['country'] = $_POST['country'];
$_SESSION['mob_no'] = $_POST['mob_no'];
$_SESSION['home_no'] = $_POST['home_no'];
$_SESSION['home_fax'] = $_POST['home_fax'];
$_SESSION['sub_details'] = $_POST['sub'];
$_SESSION['dob'] = $_POST['doby'] . "-" . $_POST['dobm'] . "-" . $_POST['dobd'];
/**
echo "First Name: $firstname
";
echo "Last Name: $lastname
";
echo "Gender: $gender
";
echo "Email: $email
";
echo "Username: $username
";
echo "Password: $password
";
echo "Referral: $referral
";
echo "referral_other: $referral
";
echo "Address: $address1 $address2 $address3
";
echo "City: $city
";
echo "State: $state
";
echo "Postcode: $postcode
";
echo "Country: $country
";
echo "Home No.: $home_no
";
echo "Home Fax: $home_fax
";
echo "Subsctipion Details: $sub_details
";
echo "Payment Type: $payment_type
";
echo "Card Number: $card_num
";
echo "Expiry Date: $exp_date
";
echo "Card Holder: $holder_name
";
echo "Auto Renew?: $auto_renew
";
**/
if($firstname != NULL && $firstname != "") {
$fnameOk = TRUE;
}
if($lastname != NULL && $lastname != "") {
$lnameOk = TRUE;
}
if($dobd != NULL && $dobd !="" && dobm != NULL && dobm !="" && $doby != NULL && $doby !="") {
if(validate_date($dobd,$dobm,$doby))
$dobOk = TRUE;
}
if(check_email_address($email)) {
$emailOk = TRUE;
}
if($username != NULL && $username != "") {
if($_POST['status'] != "" && $_POST['status'] != NULL) {
$username = TRUE;
}
else {
include('/home/finpres/options/klse/dbconnalvin.ltc');
$sql = "SELECT username FROM subscriptions WHERE username='$username'";
$rs = mysql_query($sql);
// include('/home/finpres/options/klse/dbconnalvin.ltc');
dbcon_checker();
if(mysql_num_rows($rs) > 0)
$usernameOk = FALSE;
else
$usernameOk = TRUE;
mysql_close();
}
}
if($password != NULL && $password1 !=NULL && $password != "" && $password1 != "") {
if($password == $password1) {
$passwordOk = TRUE;
}
}
if($referral != NULL && $referral != "" && $referral != "na") {
$referralOk = TRUE;
}
if($sub != NULL && $sub != "") {
$subOk = TRUE;
}
if($address1 != NULL && $address1 != "") {
$addressOk = TRUE;
}
if($city != NULL && $city != "") {
$cityOk = TRUE;
}
if($state != NULL && $state != "") {
$stateOk = TRUE;
}
if($postcode != NULL && $postcode != "") {
$postcodeOk = TRUE;
}
if($home_no != NULL && $home_no != "") {
$telephoneOk = TRUE;
}
if($fnameOk && $lnameOk && $dobOk && $emailOk && $usernameOk && $passwordOk && $referralOk && $subOk && $addressOk && $cityOk && $stateOk && $postcodeOk && $telephoneOk) {
include('/home/finpres/options/klse/dbconnalvin.ltc');
dbcon_checker();
$reg_date = gmdate("Y-m-d", time() + (28800));
$address = trim("$address1" . " $address2" . " $address3");
if($gender == "male")
$gender = 'M';
elseif($gender == "female")
$gender = 'F';
$dob = $doby . '-' . $dobm . '-' . $dobd;
$expiry_date = "0000-00-00";
$sql = "INSERT INTO subscriptions VALUES(NULL,'$username','$password','$firstname','$lastname','$gender','$dob','$email','$address','$city','$state','$postcode','$country','$mob_no','$home_no','$home_fax','$reg_date','$expiry_date','$referral','NULL','NORMAL','NULL','Y')";
mysql_query($sql);
include('/home/finpres/options/klse/dbconnalvin.ltc');
dbcon_checker();
$redirect = "";
echo $redirect;
echo "";
}
$errorMsg = "
Registration Failed! | " . "
"; if(!$fnameOk) $errorMsg = $errorMsg . "First Name Missing. "; if(!$lnameOk) $errorMsg = $errorMsg . "Last Name Missing. "; if(!$dobOk) $errorMsg = $errorMsg . "DOB Missing or Not A Valid Date. "; if(!$emailOk) $errorMsg = $errorMsg . "Email Missing or Not A Valid Email Address. "; if(!$usernameOk) $errorMsg = $errorMsg . "Username Missing or Username Already Taken. "; if(!$passwordOk) $errorMsg = $errorMsg . "Password Missing or Password Not Matched. "; if(!$referralOk) $errorMsg = $errorMsg . "No Referral Selected. "; if(!$subOk) $errorMsg = $errorMsg . "Please Select Your Subscription Details. "; if(!$addressOk) $errorMsg = $errorMsg . "Address Missing. "; if(!$cityOk) $errorMsg = $errorMsg . "City Name Missing. "; if(!$stateOk) $errorMsg = $errorMsg . "State Name Missing. "; if(!$postcodeOk) $errorMsg = $errorMsg . "Postal Code Missing. "; if(!$telephoneOk) $errorMsg = $errorMsg . "Home Telephone Number Missing. "; $errorMsg = $errorMsg . " | ||
Registration Form
|