<?php require 'header.php'; ?>

	<section id="content" class="sbr">
		<div class="menu-shadow"></div>
		<div class="container clearfix">
			<div class="page-header clearfix" style="margin-bottom: 20px;">
				<h1>Members Only Registration</h1>
				<div class="line"></div>
			</div>
			<!--/ .page-header-->

			<section id="main" class="twelve columns">
				<article class="entry clearfix">
					<!--/ .entry-title-->

					<!--/ .preloader-->

					<!--/ .entry-meta-->

					<div class="entry-body">
Thank you for registering for the MCIFA Members Only Web Site and Hotline Updates.
<br><br>
Your registration is being processed and you will receive an email when your application has been approved and accepted. In the meantime, an email copy of your registration form has been sent to you. Please save this e-mail.
<br><br>
Back to <a href="http://www.mcifa.com">www.mcifa.com</a>
<br></b>

<?php
if (empty($_POST['email']) || !filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) {
    echo 'Error, invalid email.';
    require 'sidebar.php';
    require 'footer.php';
    exit;
}

$currentDateTime = date('Y-m-d H:i:s');

$db = getWriteDb();
$stmt = $db->prepare("INSERT INTO users (fname, lname, Member, Password, EMail, City, State, Country, List, CurrentDateTime, OnOff, Address1, Address2, Zip, Phone) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'Off', ?, ?, ?, ?)");
$stmt->execute([
    $_POST['fname'] ?? '',
    $_POST['lname'] ?? '',
    $_POST['Member'] ?? '',
    $_POST['Password'] ?? '',
    $_POST['email'] ?? '',
    $_POST['City'] ?? '',
    $_POST['State'] ?? '',
    $_POST['Country'] ?? '',
    $_POST['List'] ?? '',
    $currentDateTime,
    $_POST['Address'] ?? '',
    $_POST['Address2'] ?? '',
    $_POST['Zip'] ?? '',
    $_POST['Phone'] ?? ''
]);
?>
						<!--/ .about-author-->

					</div>
					<!--/ .entry-body-->

				</article>
				<!--/ .entry-->
			</section>				<!--/ #main-->

<?php require 'sidebar.php'; ?>



<?php require 'footer.php'; ?>