Untitled

<?php
ob_start();
$servername = "localhost";
$username = "XXXXXXXX";
$password = "XXXXXXXX";
$dbname = "XXXXXX";

// Create connection
 $conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
 if (!$conn) {
     die("Connection failed: " . mysqli_connect_error());
	}
// Confirm Valid entries were made
if(isset($_POST['submit'])){

	if (empty($_POST["fname"])) {
		echo "<p>First Name is required.</p>";
        $error = true;
}

	if (empty($_POST["lname"])) {
		echo "<p>Last Name is required.</p>";
        $error = true;
    }


	if (empty($_POST["email"])) {
		echo "<p>Email Address is required</p>";
        $error = true;
}
    if(!preg_match("/12/", $_POST['captcha'])) {
    echo "<p>Wrong answer. Please try again.</p>";
        $error = true;
	}
        $fname = $_POST['fname'];//define variables
		$lname = $_POST['lname'];
		$email = $_POST['email'];
        $captcha =$_POST['captcha'];

if(error) { //insert into database if no errors
$sql = "INSERT INTO data2(fname, lname, email, captcha)
 	VALUES ('$fname', '$lname', '$email', '$captcha')";
        mysqli_real_escape_string($fname,$conn);
        mysqli_real_escape_string($fname,$conn);
        mysqli_real_escape_string($email,$conn);
        mysqli_real_escape_string($captcha,$conn);

    $result = mysqli_query($conn, $sql);

        if($result) {
            header("Location: thankyou.html"); // send to Thank you page if successful
        }  else {
            echo 'An error has occurred';
            echo mysqli_error($conn);
            echo '<p>' .$query.'</p>';
        }
    }
    }
mysqli_close($conn);
ob_flush();
//Close connection to SQL
	?>

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Registration Form</title>
<link href="css/project.css" rel="stylesheet" type="text/css">
<link href="css/bootstrap.css" rel="stylesheet" type="text/css">
<link href="css/bootstrap-3.3.6.css" rel="stylesheet" type="text/css">

</head>

<body id="Body3">
	<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
	<script src="js/jquery-1.11.3.min.js"></script>

	<!-- Include all compiled plugins (below), or include individual files as needed -->
	<script src="js/bootstrap.js"></script>

<div class="container-fluid">
  <div class="row">
    <h1>New Pharmaceuticals</h1>
  </div>
</div>
<div class="container">
  <div class="row text-center">
    <div class="col-md-6 col-md-offset-3 col-lg-offset-0 col-lg-12" style="font-size: 24px">We are happy to introduce our new prescription sleep medicine to you.  To request more information, please fill out the form below. </div>
  </div>
  <div class="row"> </div>
</div>
<div class="row">
  <div class="text-center col-md-12">
    <div class="panel panel-default col-lg-6 col-lg-push-3 center-block">
      <div class="panel-heading">
        <h3 class="page-title">Registration Form</h3>
        <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="POST">
          <br>
          First Name:<br>
          <input type="text" name="fname" value=""/>
          <span class="error">*<?php echo $fnameError; ?></span><br> // Right here is one mistake, that I left from another iteration
          <br>Last Name:<br>
          <input type="text" name="lname" value=""/>
          <span class="error">*<?php echo $lnameError; ?></span><br>
          <br>
          Email:<br>
          <input type="text" name="email" value=""/>
          <span class="error">*<?php echo $emailError; ?></span><br>
          <br>
          What is 9 + 3?<br>
          <input type="text" name="captcha" value="" />
          <span class="error">* <?php echo $captchaerror; ?></span><br>
          <br>
          <p class="error">* Required Fields</p>
          <input type="submit" name="submit" value="Submit" class="btn, btn-default"/>
          <input type="reset" name"reset" value="Clear All" class="btn, btn-default"/>
        </form>
      </div>
    </div>
  </div>
</div>
<div class="text-center col-lg-12" id="Footer">
  <h4>New Pharmaceuticals</h4>
  <p>Copyright &copy; 2016 &middot; All Rights Reserved &middot; <a href="project1.html">New Pharmceuticals</a></p>
</div>
</body>
</html>