30)) { $message = '

There was a problem.

'; } else { // Open connection to database mysql_connect("localhost", "testuser", "testpass") or die("Failure to communicate with database."); mysql_select_db("testdb"); // Insert email address $as_email = addslashes($_POST['email']); $tr_email = trim($as_email); $ip = $_SERVER['REMOTE_ADDR']; $query = "INSERT INTO mailinglist (ID, Email, Source) VALUES(2, '$tr_email', '$ip')"; $result = mysql_query($query); if (mysql_affected_rows() == 1) { $message = '

Your information has been recorded.

'; $noform_var = 1; } else { error_log(mysql_error()."\n\n", 3, "/tmp/phplog.err"); $message = '

Something went wrong with your signup attempt.

'; } } // Show the form in every case except successful submission if (!$noform_var) { $thisfile = $_SERVER['PHP_SELF']; $message = <<< EOMSG

Enter your email address and we will send you our weekly newsletter.

EOMSG; } } ?>

Newsletter sign-up form