通过html表格发电子邮件 >>三湘时空-IT知识库[www.sxsky.net]

如下：
<?

/******************************************************************************
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\nErrors-To: $strSender\nFrom:
$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] . "!\n\n" . $strBody;

        // Email
        mail($strEmail,$strSubject,$strBodyComplete,$strHeader);

        // Output
        echo "Send to $strName<br>";
    }
}
?>

上一篇:如何修护MYSQL数据表

下一篇:如何锁定MYSQL数据表