电脑技术学习

通过html表格发电子邮件

dn001
如下:
<?;;

/******************************************************************************;;
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: $strSendernErrors-To: $strSendernFrom:;;;
$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] . "!nn" . $strBody;;;
;;
// Email;;
mail($strEmail,$strSubject,$strBodyComplete,$strHeader);;;
;;
// Output;;
echo "Send to $strName<br>";;;
;;;;};;
};;
?>;;

标签: