|
';
$ts = time();
$timestamp = date('Y-m-d h:m:s', $ts );
$result = mysql_query("select email, id from email");
if ($result && mysql_num_rows($result)) {
while ($row = mysql_fetch_assoc($result)) {
while(list($var, $val) = each($row)) {
$rows[$var]=$val;
}
$emailHistory[$row['email']]=$rows['id'];
unset ($rows);
}
}
if (isset($_POST['dir']) && $_POST['dir']=='email'){
$email=strip_tags($_POST['email']);
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
if (!isset($emailHistory[$email]) ){
$res=mysql_query("
INSERT INTO email (timestamp, email, ip)
VALUES ('$timestamp','$email','".$_SERVER['REMOTE_ADDR']."')");
if (!$res){
echo "Error Saving Email. Please try again";
} else {
echo "Thank you for your submission";
$to = "info@hopevalley.com";
$subject = "New Email Registration";
$message = "A new person has signed up for the email list: $email";
$from = "mailserver@hopevalley.com";
$headers = "From:" . $from;
mail($to,$subject,$message,$headers);
}
} else {
echo 'Email already submitted';
}
} else {
echo 'Invalid Email. Please Try again |
