通过html表格发电子邮件
如下:
/******************************************************************************
Description: This is a simple script to send emails via a html-form
to different users
Date : 1999-02-25
Author : amalesh kempf
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!
Subject | |
Body | wrap="PHYSICAL"> echo $strBody ?> |
Category | Party |
type="submit" value="Sende email">
}
if (isset($btnSendEmail))
{ echo "Send Email
";
// 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
";
// fetch array
while($saRow = mysql_fetch_array($intRes))
{ $strEmail = $saRow["email"];
$strName = $saRow["name"];
$strBodyComplete = "Hello " . $strName[$i] . "!\n\n" . $strBody;
mail($strEmail,$strSubject,$strBodyComplete,$strHeader);
// Output
echo "Send to $strName
";
}
}
?>相关阅读:
CSS教程:数字和字母将容器撑大问题解决
不同数据库之间导入导出功能介绍
将XP SP3集成到Windows XP安装光盘
jquery.cvtooltip.js 基于jquery的气泡提示插件
Ajax案例集下载:新增分页查询案例(包括《Ajax开发精要》中的两个综合案例) 下载
MySQL服务维护及应用设计笔记 (2)
MooTools教程和资源(Webjx收集英文教程)
JavaScript 继承机制的实现(待续)
asp.net 字符串加密解密技术
JavaScript split()使用方法与示例
Mozilla的JavaScript引擎__noSuchMethod__()方法
PHP学习笔记之二 php入门知识
javascript 伪数组实现方法
Oracle中实现控制文件多路复用