$value) { $_REQUEST[$key] = removeQuotes($value); } $firstName = trim($_REQUEST['firstname']); $lastName = trim($_REQUEST['lastname']); $email = trim($_REQUEST['email']); $howHear = trim($_REQUEST['how_hear']); if(isset($_REQUEST['join-mailing'])) { $subscribe = '1'; } else { $subscribe = '0'; } $newpass = trim($_REQUEST['password']); $newpass_confirm = trim($_REQUEST['passwordVerify']); if(strlen($firstName) == 0 || strlen($lastName) == 0) { $errorstring = "Contact information must be filled out fully
"; } if(strlen($email) == 0) { $errorstring .= "You must specify an email address
"; } if(strlen($newpass) > 0 and strlen($newpass_confirm) > 0) { if($newpass != $newpass_confirm) { $errorstring .= "Passwords do not match
"; } } else { $errorstring .= "Must create a password
"; } $customer_ip= $_SERVER['REMOTE_ADDR']; if(strlen($errorstring) == 0) { $query = "SELECT count(*) as count FROM customers where lcase(email)=lcase('$email')"; $result = mysql_query($query); if($row= mysql_fetch_assoc($result)) { $count = $row['count']; if($count > 0) { $errorstring = "This email is already associated with an account. Please login here.
"; } else { $query = "insert into customers set registeredDt=NOW(), firstName='$firstName', lastName='$lastName', email='$email', password='$newpass', subscribeNewsletter='$subscribe', howHeardAboutUs='$howHear',Client_ip='$customer_ip'"; $result = mysql_query($query); $customerId = mysql_insert_id(); $code = strtoupper(substr($lastName, 1, 1) . substr($firstName, 1, 1)) . $customerId; $query = "update customers set customerCode='$code' where customerId='$customerId'"; $result = mysql_query($query); if($subscribe) { $type = "SIGNUP"; $howHear = $_REQUEST['how_hear']; if($type == "") { die("No referring page specified"); } $date = date("Y-m") . "-01 00:00:00"; $query = "select * from newsletterSignups where date='$date' and type='$type'"; $result = mysql_query($query); if($row = mysql_fetch_assoc($result)) { extract($row); $count++; $query = "update newsletterSignups set count='$count' where date='$date' and type='$type'"; $result = mysql_query($query); } else { $query = "insert newsletterSignups set count='1', date='$date', type='$type'"; $result = mysql_query($query); } } $_SESSION['customerId'] = $customerId; $_SESSION['firstName'] = $firstName; $_SESSION['lastName'] = $lastName; header('location:' . $clientRoot . 'my-account-settings.html'); die(); } } else { $errorstring = "Error creating account"; } } } include_header("solanova :: Create an Account", "@import url('stylesheets/create-account.css');",''); ?>

Create an Account

Shopping is a breeze with registration benefits like these!

- Checkout is faster and easier
- Quick access to your Order Status and History
- Easy Review of your AutoShip Program products
- An Address Book saves you time entering information
- Simple sign-up for email health updates and promotions

0) { echo "$errorstring"; } ?>

*required



Receive exclusive email offers & health updates from Solanova. We will never share or sell your email. Privacy Policy