如下: <?
/****************************************************************************** Description: This is a simple script to send emails via a html-form to different users Date : 1999-02-25 Author : amalesh kempf <amalesh@goatrance.de>
Create this table The field "what" is for different categories
CREATE TABLE email_notify ( ID int(11) DEFAULT '0' NOT NULL, What varchar(60) DEFAULT '0' NOT NULL, Name varchar(60) DEFAULT '0' NOT NULL, Email varchar(60) DEFAULT '0' NOT NULL, timestamp varchar(16), KEY (What), PRIMARY KEY (ID));
To fill this table you might create an insert form
*******************************************************************************/
// Set this values: $strHost ="localhost"; $strUser ="root"; $strPassw =""; $strSender="you@domain.com";
if (!$btnSendEmail) { ?>
The email will be added automatically with "Hello Name" in the first line of the emailbody!<br> <br>
<form action="send_email.php3" enctype="application/x-www-form- urlencoded" method="post"> <table> <tr> <td>Subject</td> <td><input name="strSubject" size="40"></td> </tr> <tr> <td>Body</td> <td><textarea cols="40" name="strBody" rows="8" wrap="PHYSICAL"><? echo $strBody ?></textarea></td> </tr> <tr> <td>Category</td> <td> <select name="strWhat"> <?php // add you categories here: ?> <option value="party">Party</option> </select> </td> </tr> </table> <input name="btnSendEmail" style="HEIGHT: 24px; WIDTH: 224px" type="submit" value="Sende email"> </form> <?php }
if (isset($btnSendEmail)) { echo "Send Email<br>";
// Create connection $intConID = mysql_pconnect($strHost,$strUser,$strPassw);
// Header $strHeader = "Return-Path: $strSender Errors-To: $strSender From: $strSender"; // SQL $strSQL = "select name,email from email_notify where lcase(what) = '$strWhat'"; $intRes = mysql_query($strSQL,$intConID);
echo "Send Email $strBody<br>";
// fetch array while($saRow = mysql_fetch_array($intRes)) { $strEmail = $saRow["email"]; $strName = $saRow["name"]; $strBodyComplete = "Hello " . $strName[$i] . "! " . $strBody; // Email mail($strEmail,$strSubject,$strBodyComplete,$strHeader); // Output echo "Send to $strName<br>"; } } ?>
|