Mailing List example
Now for the fruits of your labour , create a newsletter and send it to all your subscribers. First of all we create a form with some necessary fields in it .
<form action = "sendnewsletter.php" method = "post">
<table>
<tr>
<td>Subject : </td>
<td>
<input type = "text" name = "subject" size="70">
</td>
</tr><tr>
<td>Body : </td>
<td><textarea name = "body" cols = "50" rows = "20" wrap = virtual></textarea></td>
</tr><tr><td>
<input type = "submit" value = "create newsletter">
</td><td>
<input type = "reset">
</td></tr>
</table>
</form>
Pretty straightforward this now for the script to send the newsletters
<?php
//sendnewsletter.php
//creates your newsletter an sends it.
if (($subject == "") || ($body == ""))
{
header("Location : sendaletter.php");
exit;
}
else
{
//make a connection
$connection = mysql_connect("localhost" , "username" , "password")
or die("cannot make connection");
//select the database
$db = mysql_select_db("email" , $connection)
or die("cannot find database");
$sql_query = "SELECT email FROM email";
$result = mysql_query($sql_query) or die("cannot execute query");
$header = "From : Myscripting.Com";
//loop through rows
while ($row = mysql_fetch_array($result))
{
$address = $row[0];
//mail function requires email address($address)
//The subject($subject) , the message ($body) and
//the $header info
mail($address ,$subject , $body , $header);
//display a message confirming email has been sent
echo ("newsletter sent to : $address<br>");
}
echo ("Completed sending emails");
}
?>
Remember and add your user info at the start , the hostname , username and password.
This script simply sends an email to an address forom the database , it loops through all stored addresses dispalying a confirmation message and when this is finished you get a message .
Note the if else at the start is our first validation this basicly checks whether you have entered and data for the subject and the body , if you have not you are redirected back to the form , in this case
back to section 3 |
