$submit = strip_tags($_POST['submit']);
$fname = strip_tags($_POST['fname']);
$lname = strip_tags($_POST['lname']);
$company = strip_tags($_POST['cname']);
$addr1 = strip_tags($_POST['addr1']);
$addr2 = strip_tags($_POST['addr2']);
$city = strip_tags($_POST['city']);
$state = strip_tags($_POST['state']);
$zip = strip_tags($_POST['zip']);
$email = strip_tags($_POST['email']);
$area_code = strip_tags($_POST['area_code']);
$first3 = strip_tags($_POST['first3']);
$last4 = strip_tags($_POST['last4']);
if ($area_code && $first3 && $last4) {
$phone = "(".$area_code.") ".$first3."-".$last4;
}
$uname = strtolower(strip_tags($_POST['uname']));
$pword = strip_tags($_POST['pword']);
$pword2 = strip_tags($_POST['pword2']);
//echo $phone,"/".$pword;
if ($submit)
{
require('conn.php');
//echo "select username from users where username='$uname'";
//die();
$namecheck = mysql_query("select username from users where username='$uname'");
$count = mysql_num_rows($namecheck);
if ($count != 0) {
?>
die();
}
$namecheck = mysql_query("select email from users where email='$email'");
$count = mysql_num_rows($namecheck);
if ($count != 0) {
?>
die();
}
// check
if ($uname && $pword && $fname && $lname && $email && $pword2)
{
if ($pword ==$pword2)
{
if (strlen($uname) > 25 || strlen($uname) < 6) {
echo "
"; } //mysql_close($con); #####FORWARD TO MEMBERS PAGE########## $to = $email; $subject = "ABACUS CONFIRMATION"; $message = "This email was sent to confirm your membership with Abacus.\n"; $message .= "Please visit http://www.abacusbci.com/confirmed.php?id=$uID"; $from = "ABACUS"; $headers = "From:" . $from; mail($to,$subject,$message,$headers); echo "Mail Sent."; //die(); ?> } } else echo "
USERNAME MUST BE BETWEEN 6 AND 25 CHARACTERS.
";
}
else
{
if (strlen($pword) > 25 || strlen($pword) < 6 ) {
echo "PASSWORD MUST BE BETWEEN 6 AND 25 CHARACTERS
";
}
else
//encrypt password
$pword = md5($pword);
$pword2 = md5($pword2);
//register here
$queryreg = mysql_query("INSERT INTO users (fname, lname, company, addr1, addr2, city, state, zip, email, phone, username, password) VALUES ('$fname', '$lname', '$company', '$addr1', '$addr2', '$city', '$state', '$zip', '$email', '$phone', '$uname', '$pword')");
mysql_close($con);
include('conn.php');
//echo "INSERT INTO users (fname, lname, email, phone, username, password) VALUES ('$fname', '$lname', '$email', '$phone', '$uname', '$pword')";
$result = mysql_query("SELECT id FROM users where username='$uname'");
//echo "SELECT id FROM users where username=$uname";
while($row = mysql_fetch_array($result))
{
$uID = $row['id'];
// echo ""; } //mysql_close($con); #####FORWARD TO MEMBERS PAGE########## $to = $email; $subject = "ABACUS CONFIRMATION"; $message = "This email was sent to confirm your membership with Abacus.\n"; $message .= "Please visit http://www.abacusbci.com/confirmed.php?id=$uID"; $from = "ABACUS"; $headers = "From:" . $from; mail($to,$subject,$message,$headers); echo "Mail Sent."; //die(); ?> } } else echo "
YOUR PASSWORDS DO NOT MATCH! PLEASE TRY AGAIN.
";
}
else
echo "PLEASE MAKE SURE ALL REQUIRED FIELDS HAVE BEEN ENTERED.
";
}
$req=" * ";
?>
Click here to see Strategic Alliances
Sign up today to receive our direct mailing
Contact Information
Abacus Benefit Consultants, Inc.Tel: (401) 942-4900 • Fax: (401) 942-8989
info@abacusbci.com
Frequently Asked Questions
Click here to view our Frequently Asked Question section to get more details on individual plans.