prepare('SELECT stats_registration FROM fc_stats LIMIT 1;'); $select->execute(); $result = $select->fetch(PDO::FETCH_ASSOC); $stats = $result["stats_registration"]++; $update = $dbh->prepare('UPDATE fc_stats SET stats_registration = ? LIMIT 1;'); $update->execute([$stats]); $_SESSION["reg_fname"] = $_SESSION["reg_lname"] = $_SESSION["reg_email"] = $_SESSION["reg_gender"] = $_SESSION["reg_handle"] = $_SESSION["reg_password"] = $_SESSION["reg_cpassword"] = $_SESSION["reg_city"] = $_SESSION["reg_state"] = $_SESSION["reg_country"] = ''; $errortext = ''; $_SESSION["registration_complete"] = 0; $fname_ok = $lname_ok = $email_ok = $gender_ok = $handle_ok = $password_ok = $address_ok = $city_ok = $state_ok = $postalcode_ok = $country_ok = $phone_ok = 0; //first name if ((!isset($_POST["fname"])) || ($_POST["fname"] != '') || (!isset($_SESSION["reg_fname"])) || ($_SESSION["reg_fname"] != '')) { if ((isset($_POST["fname"])) && ($_POST["fname"] != '')) { $_SESSION["reg_fname"] = $reg_fname = $_POST["fname"]; $fname_ok = 1; } else {unset($_SESSION["reg_fname"]);} } else {unset($_SESSION["reg_fname"]);} //last name if ((!isset($_POST["lname"])) || ($_POST["lname"] != '') || (!isset($_SESSION["reg_lname"])) || ($_SESSION["reg_lname"] != '')) { if ((isset($_POST["lname"])) && ($_POST["lname"] != '')) { $_SESSION["reg_lname"] = $reg_lname = $_POST["lname"]; $lname_ok = 1; } else {unset($_SESSION["reg_lname"]);} } else {unset($_SESSION["reg_lname"]);} //email address if ((!isset($_POST["email"])) || ($_POST["email"] != '') || (!isset($_SESSION["reg_email"])) || ($_SESSION["reg_email"] != '')) { if ((isset($_POST["email"])) && (isset($_SESSION["reg_email"])) && ($_POST["email"] != $_SESSION["reg_email"])) {$_SESSION["reg_email"] = $_POST["email"];} if (isset($_POST["email"])) {$reg_email = $_POST["email"];} } else {unset($_SESSION["reg_email"]);} //user gender if ((isset($_POST["gender"])) && ($_POST["gender"] != '')) {$reg_gender = $_SESSION["reg_gender"] = $_POST["gender"];} //user handle if ((!isset($_POST["handle"])) || ($_POST["handle"] != '') || (!isset($_SESSION["reg_handle"])) || ($_SESSION["reg_handle"] != '')) { if ((isset($_POST["handle"])) && ($_POST["handle"] != '')) {$_SESSION["reg_handle"] = $reg_handle = $_POST["handle"];} else {unset($_SESSION["reg_handle"]);} } else {unset($_SESSION["reg_handle"]);} //password if ((!isset($_POST["password"])) || ($_POST["password"] != '') || (!isset($_SESSION["reg_password"])) || ($_SESSION["reg_password"] != '')) { if ((isset($_POST["password"])) && (isset($_SESSION["reg_password"])) && ($_POST["password"] != $_SESSION["reg_password"])) {$_SESSION["reg_password"] = $_POST["password"];} if (isset($_POST["password"])) {$reg_password = $_POST["password"];} } else {unset($_SESSION["reg_password"]);} //password confirmation if ((!isset($_POST["cpassword"])) || ($_POST["cpassword"] != '') || (!isset($_SESSION["reg_cpassword"])) || ($_SESSION["reg_cpassword"] != '')) { if ((isset($_POST["cpassword"])) && (isset($_SESSION["reg_cpassword"])) && ($_POST["cpassword"] != $_SESSION["reg_cpassword"])) {$_SESSION["reg_cpassword"] = $_POST["cpassword"];} if (isset($_POST["cpassword"])) {$reg_cpassword = $_POST["cpassword"];} } else {unset($_SESSION["reg_cpassword"]);} //user city if ((!isset($_POST["city"])) || ($_POST["city"] != '') || (!isset($_SESSION["reg_city"])) || ($_SESSION["reg_city"] != '')) { if ((isset($_POST["city"])) && ($_POST["city"] != '')) { $_SESSION["reg_city"] = $reg_city = $_POST["city"]; $city_ok = 1; } else {unset($_SESSION["reg_city"]);} } else {unset($_SESSION["reg_city"]);} //state or province if ((!isset($_POST["state"])) || ($_POST["state"] != '') || (!isset($_SESSION["reg_state"])) || ($_SESSION["reg_state"] != '')) { if ((isset($_POST["state"])) && ($_POST["state"] != '')) { $_SESSION["reg_state"] = $reg_state = $_POST["state"]; $state_ok = 1; } else {unset($_SESSION["reg_state"]);} } else {unset($_SESSION["reg_state"]);} //user country if ((!isset($_POST["country"])) || ($_POST["country"] != '') || (!isset($_SESSION["reg_country"])) || ($_SESSION["reg_country"] != '')) { if ((isset($_POST["country"])) && ($_POST["country"] != '')) { $_SESSION["reg_country"] = $reg_country = $_POST["country"]; $country_ok = 1; } else {unset($_SESSION["reg_country"]);} } else {unset($_SESSION["reg_country"]);} ?> Family Chores Registration Page
1)) { $reg_fname = trim($reg_fname); $fname_ok = 1; } else {$errortext .= 'Please enter your first name.
';} //check last name if ((isset($reg_lname) || isset($_SESSION["reg_lname"])) && (strlen($reg_lname) > 1)) { $reg_lname = trim($reg_lname); $lname_ok = 1; } else {$errortext .= 'Please enter your last name.
';} //check email address if (isset($reg_email)) { if (!filter_var($reg_email, FILTER_VALIDATE_EMAIL)) {$errortext .= 'Please enter a valid email address.
';} else { $select = $dbh->prepare('SELECT user_email FROM fc_members;'); $select->execute(); $result = $select->fetchAll(PDO::FETCH_ASSOC); $reg_emaillow = strtolower($reg_email); $emailmatch = 0; foreach ($result as $row) { $database_email = strtolower($row["user_email"]); if ($database_email == $reg_emaillow) {$emailmatch = 1;} } if ($emailmatch == 1) {$errortext .= 'The email you have entered is already registered here. Please choose another.
';} else { $reg_email = trim($reg_email); $email_ok = 1; } } } else {$errortext .= 'Please enter a valid email address.
';} //check gender if (isset($reg_gender)) { if (($reg_gender == 'Male') ||($reg_gender == 'Female')) { $reg_gender = trim($reg_gender); $gender_ok = 1; } else {$errortext .= 'Please define your gender.
';} } else {$errortext .= 'Please define your gender.
';} //check handle if (isset($reg_handle)) { $reg_handle = trim(str_replace(" ", "", $reg_handle)); if ((strlen($reg_handle) < 4) || (strlen($reg_handle) > 16)) { $errortext .= 'Your username must be between 4 and 16 characters long.
'; $handle_ok = 0; } else { $reg_handlelow = strtolower($reg_handle); $select = $dbh->prepare('SELECT user_handle FROM fc_members;'); $select->execute(); $result = $select->fetchAll(PDO::FETCH_ASSOC); $duplicate = 0; foreach ($result as $row) { $database_handle = strtolower($row["user_handle"]); if ($database_handle == $reg_handlelow) {$duplicate = 1;} } if ($duplicate != 0) { $errortext .= 'The username you have chosen is already taken. Please choose another.
'; $handle_ok = 0; } else { $reg_handle = trim($reg_handle); $handle_ok = 1; } } } else {$errortext .= 'Please enter a username for yourself.
';} //checks password and password confirmation if (isset($reg_password) && isset($reg_cpassword) && ($reg_password == $reg_cpassword)) { if ((!preg_match('/^[A-Za-z0-9]+$/', $reg_password)) || (!preg_match("#^.*(?=.*\d)(?=.*[a-z]).*$#i", $reg_password)) || (strlen($reg_password) < 8) || (strlen($reg_password) > 20)) {$errortext .= 'Password must be 8-20 characters long, alphanumeric, with at least one number and one letter.
';} else { $reg_password = base64_encode(trim($reg_password)); $reg_password = $reg_password; $password_ok = 1; } } else {$errortext .= 'Please enter a password into the correct field, then confirm it in the field below.
';} //check city if (isset($reg_city) && (strlen($reg_city) > 2)) { $reg_city = trim($reg_city); $city_ok = 1; } else {$errortext .= 'Please enter the name of the city you live in.
';} //checks state or province if (isset($reg_state) && (strlen($reg_state) > 1)) { $reg_state = trim($reg_state); $state_ok = 1; } else {$errortext .= 'Please enter the state/province you reside in.
';} //checks country if (isset($reg_country) && (strlen($reg_country) > 3)) { $reg_country = trim($reg_country); $country_ok = 1; } else {$errortext .= 'Please select the country in which you reside.
';} $reg_date = date("Y-m-d"); if (($fname_ok == 1) && ($lname_ok == 1) && ($email_ok == 1) && ($gender_ok == 1) && ($handle_ok == 1) && ($password_ok == 1) && ($city_ok == 1) && ($state_ok == 1) && ($country_ok == 1)) { if ($reg_gender == 'Male') {$reg_gender = 1;} else {$reg_gender = 0;} $reg_handle = trim($reg_handle); $insert = $dbh->prepare('INSERT INTO fc_members (user_parent, user_admin, user_fname, user_lname, user_gender, user_city, user_state, user_country, user_email, user_handle, user_password, user_date_reg, user_date_visit) VALUES (1,0,?,?,?,?,?,?,?,?,?,CURRENT_TIMESTAMP(),?);'); $insert->execute([$reg_fname,$reg_lname,$reg_gender,$reg_city,$reg_state,$reg_country,$reg_email,$reg_handle,$reg_password,$reg_date]); $_SESSION["registration_complete"] = 1; //welcome email $email = $reg_email; $to = $email; $subject = "Welcome to FamilyChores.com!\r\n"; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= "From: support@familychores.com\r\n"; $headers .= "Return-Path: " . $email . "\r\n"; $headers .= "Reply-To: support@familychores.com\r\n"; $message = '


Congratulations and Welcome to
FamilyChores.com!

You have just taken the first step in a simple and easy way to motivate your kids to do chores around your home.

We encourage you to visit the site often and share it with other families as well. We hope that you will not feel any hesitation in contacting us at any time at support@familychores.com, whether you require help or have suggestions that may enhance our site.

Thank you again for joining Family Chores! Congratulations! Login now to view your account!

'; $message .= ''; $message .= '

'; mail($to,$subject,$message,$headers); unset($_SESSION["reg_fname"]); unset($_SESSION["reg_lname"]); unset($_SESSION["reg_email"]); unset($_SESSION["reg_gender"]); unset($_SESSION["reg_handle"]); unset($_SESSION["reg_password"]); unset($_SESSION["reg_cpassword"]); unset($_SESSION["reg_address"]); unset($_SESSION["reg_city"]); unset($_SESSION["reg_state"]); unset($_SESSION["reg_postalcode"]); unset($_SESSION["reg_country"]); unset($_SESSION["reg_phone"]); } ?> Register Your Family Now ... Its Free!

The initial registration MUST BE COMPLETED BY AN ADULT, namely the parent. The process takes only a minute or two of your time and brings you infinitely closer to having responsible and reliable children who learn the value of work. Please fill out the following form to register; all fields are mandatory. Remember, registration and membership are completely free!

'; if (((!isset($_POST["fname"])) || ($_POST["fname"] == '')) && ((!isset($_POST["lname"])) || ($_POST["lname"] == '')) && ((!isset($_POST["email"])) || ($_POST["email"] == '')) && ((!isset($_POST["gender"])) || ($_POST["gender"] == '')) && ((!isset($_POST["handle"])) || ($_POST["handle"] == '')) && ((!isset($_POST["password"])) || ($_POST["password"] == '')) && ((!isset($_POST["cpassword"])) || ($_POST["cpassword"] == '')) && ((!isset($_POST["city"])) || ($_POST["city"] == '')) && ((!isset($_POST["state"])) || ($_POST["state"] == '')) && ((!isset($_POST["country"])) || ($_POST["country"] == ''))) {echo 'All fields are mandatory. Username must be 6-16 characters in length, be contain only letters and numbers, and have no spaces. Your password must be 8-20 characters in length, contain only letters and numbers, with at least one number and one letter. Both the username and password are case sensitive.';} else {echo '' . $errortext . '';} echo '

Parent Account Registration

Registration Form First Name  
Registration Form Last Name  
Registration Form Username/Handle  
Registration Form Email Address  
Registration Form Gender      Male Female
Registration Form Password  
Registration Form Confirm Password  
Registration Form City  
Registration Form State / Province  
Registration Form Country  

';} else { echo 'Congratulations! You Have Registered Yourself

We also strongly urge you to register for an Amazon account, if you do not have one yet! You will need it to purchase the rewards which your children will redeemed for the good habits FamilyChores.com is going to instill in them!






Or login to visit your free account now:


Member Login for FamilyChores.com


'; } ?>