PHP Tutorial : How to build a newsletter (part I)

Hi,

Do you need to send regular news by email to your customers, or just want to keep them posted with product offers and updates? There is a solution, php newsletter. This can be done in two parts, first part is collecting the emails into a mysql database within a html form and php processing.

<form action="" method="POST">
Enter your email : <input type="text" name="email">
<input type="submit" name="sb" value="Subscribe">
</form>
<?php

if(isset($_POST['sb'])) {

if($_POST['email'] == "") {
print "Please complete email address";
}else{
$sql = "insert into tablename (`email`) values ('".addslashes(mysql_real_escape_string($_POST['email']))."')";
$rs = mysql_query($sql);

if($rs) {

print "Email address subscribed to our newsletter";
}else{

print "Email address was not subscribed to our newsletter durring a mysql error";
}
}
}
?>

Second part is coming!