0 ? $_POST['fname'] : NULL;
$lname = isset($_POST['lname']) && strlen($_POST['lname']) > 0 ? $_POST['lname'] : NULL;
$email = isset($_POST['email']) && strlen($_POST['email']) > 0 ? $_POST['email'] : NULL;
$verifyEmail = isset($_POST['verifyemail']) && strlen($_POST['verifyemail']) > 0 ? $_POST['verifyemail'] : NULL;
$pw = isset($_POST['password']) && strlen($_POST['password']) > 0 ? $_POST['password'] : NULL;
$verifyPW = isset($_POST['verifypassword']) && strlen($_POST['verifypassword']) > 0 ? $_POST['verifypassword'] : NULL;
$terms = isset($_POST['terms']) && strlen($_POST['terms']) > 0 ? $_POST['terms'] : NULL;
$phoneNumber = $_POST['phone'];
$interest = $_POST['interest'];
$working = $_POST['working'];
$emailRates = $_POST['emailrates'];
$emailNews = $_POST['emailnews'];
if (isset($fname) && isset($lname) && isset($email) && isset($verifyEmail) &&
isset($pw) && isset($verifyPW) && isset($terms))
{
if ($email != $verifyEmail)
{
$err = "Email addresses do not match";
}
else if ($pw != $verifyPW)
{
$err = "Passwords do not match";
}
else
{
// verify email address is not already used
include("/home/cbhearth/_inc/dbconnect.inc");
$check = mysql_query ("SELECT EMAIL FROM PUBLICUSER WHERE EMAIL='$email'");
if (!$check)
{
echo mysql_error();
}
$matches = mysql_num_rows ($check);
if ($matches > 0)
{
$err = "This email address is already in use. ";
$err .= "Click here to email the password for this account.";
}
else
{
// insert user
$email = mysql_real_escape_string(stripslashes($email));
$pw = mysql_real_escape_string(stripslashes($pw));
$fname = mysql_real_escape_string(stripslashes($fname));
$lname = mysql_real_escape_string(stripslashes($lname));
$phoneNumber = mysql_real_escape_string(stripslashes($phoneNumber));
$interest = mysql_real_escape_string(stripslashes($interest));
$working = mysql_real_escape_string(stripslashes($working));
$emailRates = mysql_real_escape_string(stripslashes($emailRates));
$emailNews = mysql_real_escape_string(stripslashes($emailNews));
$query = "INSERT INTO PUBLICUSER (EMAIL, PASSWORD, FNAME, LNAME, PHONE, INTEREST, WORKING, EMAILRATES, EMAILNEWS) ";
$query .= "VALUES ('$email', '".sha1($pw)."', '$fname', '$lname', '$phoneNumber', '$interest', '$working', '$emailRates', '$emailNews')";
$result = mysql_query($query);
if (!$result)
{
$err = "There was a problem, please try again.";
}
else
{
// clear any previous session
session_start ();
$_SESSION = array (); // Empty the session
session_destroy (); // Destroy the session
$allow = array ();
include ("/home/cbhearth/_inc/retriever/protect.php");
header ("Location: ".$next);
exit;
}
}
}
}
else
{
$err = "Please fill in all required fields";
$fnameClass = isset($fname) == false ? " class=\"required\"" : "";
$lnameClass = isset($lname) == false ? " class=\"required\"" : "";
$emailClass = isset($email) == false ? " class=\"required\"" : "";
$verifyEmailClass = isset($verifyEmail) == false ? " class=\"required\"" : "";
$pwClass = isset($pw) == false ? " class=\"required\"" : "";
$verifyPWClass = isset($verifyPW) == false ? " class=\"required\"" : "";
$termsClass = isset($terms) == false ? " class=\"required\"" : "";
}
}
$headAppend = $isPopup ? " class=\"popup\"" : "";
?>
Register for Coldwell Banker's Home Retriever
>