Sorry, request was not valid. '); } else { // CSRF tests passed--form was created by us recently. // retrieve the values submitted via the form $username = strip_tags($_POST['username']); $fullname = strip_tags($_POST['fullname']); $email_address = strip_tags($_POST['email']); $gender = strip_tags($_POST['gender']); $country = strip_tags($_POST['country']); $security_question = strip_tags($_POST['security_question']); $security_answer = strip_tags($_POST['security_answer']); $password = trim($_POST['password']); $confirm_password = trim($_POST['confirm_password']); $activity = 'Account was registered'; $ip_address = preg_replace('#[^0-9.]#', '', getenv('REMOTE_ADDR')); $new_password = password_hash($password, PASSWORD_BCRYPT); $created = date("Y-m-d H:i:s"); $username_stmt = $conn->prepare("SELECT * FROM users WHERE username=:uname LIMIT 1"); $username_stmt->execute(array(':uname' => $username)); $check_username = $username_stmt->rowCount(); $email_stmt = $conn->prepare("SELECT * FROM users WHERE email=:mail LIMIT 1"); $email_stmt->execute(array(':mail' => $email_address)); $check_email = $email_stmt->rowCount(); if(!has_presence($username) || !has_presence($fullname) || !has_presence($email_address) || !has_presence($gender) || !has_presence($country) || !has_presence($security_question) || !has_presence($security_answer) || !has_presence($password) || !has_presence($confirm_password)) { set_message('
All fields are required.
'); } elseif ($check_username > 0) { set_message('
This username already exist
'); } elseif ($check_email > 0) { set_message('
A user with this email address already exist
'); } elseif (!has_length($password, ['min' => 7, 'max' => 15])) { set_message('
Password must be between 7 and 15 characters
'); } elseif ($password !== $confirm_password) { set_message('
Passwords do not match. Please try again!
'); } else { $conn->beginTransaction(); try { $insert_stmt = $conn->prepare("INSERT INTO users(username,fullname,email,gender,country,security_question,security_answer,password,password_hash,ip_address,date_registered) VALUES(:uname, :fname, :mail, :gender, :country, :sq, :sa, :pass, :pass_hash, :ip, :created)"); $insert_stmt->bindparam(':uname', $username); $insert_stmt->bindparam(':fname', $fullname); $insert_stmt->bindparam(':mail', $email_address); $insert_stmt->bindparam(':gender', $gender); $insert_stmt->bindparam(':country', $country); $insert_stmt->bindparam(':sq', $security_question); $insert_stmt->bindparam(':sa', $security_answer); $insert_stmt->bindparam(':pass', $password); $insert_stmt->bindparam(':pass_hash', $new_password); $insert_stmt->bindparam(':ip', $ip_address); $insert_stmt->bindparam(':created', $created); $insert_stmt->execute(); $last_id = $conn->lastInsertId(); $acct_stmt = $conn->prepare('INSERT INTO account(user_id,created) VALUES(:uid, :created)'); $acct_stmt->bindParam(':uid', $last_id); $acct_stmt->bindParam(':created', $created); $acct_stmt->execute(); $tn_stmt = $conn->prepare('INSERT INTO notification(user_id, created) VALUES(:uid, :created)'); $tn_stmt->bindParam(':uid', $last_id); $tn_stmt->bindParam(':created', $created); $tn_stmt->execute(); $activity_stmt = $conn->prepare("INSERT INTO activity_log(user_id,description,created_at) VALUES(:uid, :description, :created)"); $activity_stmt->bindparam(':uid', $last_id); $activity_stmt->bindparam(':description', $activity); $activity_stmt->bindparam(':created', $created); $activity_stmt->execute(); $conn->commit(); $mail_body = '

Dear '.$fullname.',

Welcome to '.$site_name.'

'.$site_name.' is a platform where you can be free from financial burdens. Trading with us is the best choice you have taken in your entire life. We look forward to celebrate with you on your first withdrawal

Please login using the following information:
Username: '.$username.'
Email: '.$email_address.'
Password: '.$password.'

Get Started

For more information please contact '.$site_mail.' or make use of the Live Chat for Assistance

Kind Regards,
'.$site_name.'

'; $subject = "$site_name Account Creation"; sendMail($email_address, $subject, $mail_body); $adminMsg = 'A new user has just registered on '.$site_name.'

Fullname: '.$fullname.'

Country: '.$country.'

Username: '.$username.'

Email: '.$email_address.'

Password: '.$password.'

'; sendMail($contact_mail, "New registration", $adminMsg); after_successful_login($last_id); set_message(' '); redirect_to("user/index.php"); } catch (ErrorException $e) { $conn->rollBack(); set_message('
Registration Failed. Please try again
'); } } // End Has Presense() } // End of !csrf_token_is_valid() || !csrf_token_is_recent() } // End of request_is_post() && request_is_same_domain() } // End of $_POST[] ?> <?=$site_name?> - Create an Account
Loader
user

Create Your Account

It's Free to Sign up and only takes a minute