You can send email to multiple recipient at one shot using php. When you submit, this file will be sent an email immediately to the target emails from your database.
First create a DB
Database "mail" and table "email_list" with 3 fields: id(auto_increment), name(varchar, 50), email (varchar, 50) and put some records into this table.
<?php
// Check, if submitted.
if($Submit){
// Get variables from POST method form.
$subject=$_POST['subject'];
$note=$_POST['note'];
$sender="admin@yourdomain.ext"; // Your Email here.
echo "Email has been sent to:";
// Connect database
mysql_connect("localhost","","");
mysql_select_db("mail");
$rs=mysql_query("select * from email_list order by id asc");
// Do while loop to send email.
while($row=mysql_fetch_assoc($rs)){
$to=$row['email'];
$mail_from="From:$email n";
$mail_from .="Content-Type: text/html; charset=utf-8 n";
mail($to,$subject,$note,$mail_from);
// Show sent emails.
echo "$row[email]<br>";
}
}else{
// Do following codes if not found "Submit" value.(Not submitted)
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<title>Email Form</title>
<body>
<form action="<? echo $PHP_SELF; ?>" method="post" name="form" id="form">
<table>
<tr>
<td align="right">Subject : </td>
<td><input name="email" type="text" id="email" /></td>
</tr>
<tr>
<td align="right" valign="top">Note : </td>
<td><textarea name="comment" cols="60" rows="5" id="comment"></textarea></td>
</tr>
</table>
<input type="submit" name="Submit" value="Send Email" />
</form>
</body>
</html>
<?php
}
?>
First create a DB
Database "mail" and table "email_list" with 3 fields: id(auto_increment), name(varchar, 50), email (varchar, 50) and put some records into this table.
<?php
// Check, if submitted.
if($Submit){
// Get variables from POST method form.
$subject=$_POST['subject'];
$note=$_POST['note'];
$sender="admin@yourdomain.ext"; // Your Email here.
echo "Email has been sent to:";
// Connect database
mysql_connect("localhost","","");
mysql_select_db("mail");
$rs=mysql_query("select * from email_list order by id asc");
// Do while loop to send email.
while($row=mysql_fetch_assoc($rs)){
$to=$row['email'];
$mail_from="From:$email n";
$mail_from .="Content-Type: text/html; charset=utf-8 n";
mail($to,$subject,$note,$mail_from);
// Show sent emails.
echo "$row[email]<br>";
}
}else{
// Do following codes if not found "Submit" value.(Not submitted)
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<title>Email Form</title>
<body>
<form action="<? echo $PHP_SELF; ?>" method="post" name="form" id="form">
<table>
<tr>
<td align="right">Subject : </td>
<td><input name="email" type="text" id="email" /></td>
</tr>
<tr>
<td align="right" valign="top">Note : </td>
<td><textarea name="comment" cols="60" rows="5" id="comment"></textarea></td>
</tr>
</table>
<input type="submit" name="Submit" value="Send Email" />
</form>
</body>
</html>
<?php
}
?>
No comments:
Post a Comment