What i need to do is check to see if the email address submitted is in the database already and if so be re-directed to an html error page!
Code: Select all
<?php
$mysqli = mysqli_connect("HIDDEN", "HIDDEN", "HIDDEN", "mailing_list");
if (mysqli_errno($mysqli)) {
printf("Connection Failed: %s\n", mysqli_connect_errno());
exit();
} else {
if (($_POST) && ($_POST["action"] == "sub")) {
$sql = "INSERT INTO emails (email_addresses) VALUES ('".$_POST["email"]."')";
$res = mysqli_query($mysqli, $sql);
if ($res === TRUE) {
header( "Location: http://localhost:8088/networking/htdocs ... ningup.htm" );
} else {
printf("Could not insert record: %s\n", mysqli_errno($mysqli));
}
mysqli_close($mysqli);
}
}
?>
Code: Select all
<form action="../scripts/insert.php" method="post" name="mailList" class="style3" id="mailList">
<br/><br/>
<input type="text" name="email" id="email" size="20" value="Your E-Mail" onfocus="clearText(this.form);" />
<br/>
<span class="style1 style3 style3">
<input type="radio" name="action" value="sub" checked="checked" />Subscribe
<input type="radio" name="action" value="unsub" />Unsubscribe
</span>
<br/>
<input type="submit" name="submit" id="submit" value="Submit" onclick="return checkEmail(this.form);" />
</form>