I've tested my database connection, and i've echoed $email and $name, can I put this down to incorrect syntax?
<div id="form">
<form name="form1" method="post" action="form-email.php">
<input type="text" onclick="this.value=''" name="name" class="round" value="name" size="20" />
<input type="text" onclick="this.value=''" name="email" class="round" value="email" size="20"/>
<input type="submit" class="round" name="Submit" value="Register Your interest"/>
</form>
</div>
<?php
if (isset($_POST['Submit'])) {
if ($_POST['name'] != "") {
$name = filter_var($_POST['name'], FILTER_SANITIZE_STRING);
if (!filter_var($name, FILTER_SANITIZE_STRING)) {
$errors .= '* Please enter a valid name.<br/><br/>';
}
} else {
$errors .= '* Please enter your name.<br/>';
}
if ($_POST['email'] != "") {
$email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$errors .= "* $email is <strong>NOT</strong> a valid email address ";
}
} else {
$errors .= '* Please enter your email address.<br/>';
}
if (!$errors) {
$hostname = "###";
$username = "###";
$dbname = "###";
$password = "###";
$con = mysql_connect ("$hostname", "$username", "$password");
if (!$con) {
die ('Could not connect: ' . mysql_error ());
}
mysql_select_db ("###", $con);
$sql = "INSERT INTO NLCUP (name, email) VALUES ('$name', '$email')";
echo '<p style="color: white; margin-left:105px; font-size:22px; padding-top:15px">* Thankyou, we will be in touch soon!<br></p>';
}
else {
echo '<p style="color: white; margin-left:105px; padding-top:15px">' . $errors . 'please try again.</p></div>';
}
}
?>
</div>
