<?php
if (!$_post['email'] || $_post['email'] =="" ||
strlen(isset($_post['email']) && $_post['email'] > 30){
echo '<P>Is je emailadres echt zo lang?</P>';
} else {
//Open connection to de database
mysql_connect("localhost", "root", "")
or die("Kan geen contact maken met de database");
mysql_select_db("test");
//Insert mail address
$as_email = mysql_real_escape_string($_post['email']);
$tr_email = trim($as_email);
$QUERY = "INSERT INTO mailinglist (ID, Email, Source)
VALUES(NULL, '$tr_email',
'www.example.com/newsletter_signup.html')
";
$result = mysql_query($QUERY);
if (mysql_affected_rows() == 1) {
echo '<P>Your information has been recorded.</P>';
} else {
error_log(mysql_error());
echo '<P>Somthing went wrong with your signup
attempt.</P>';
}
}
?>