/******************************************************************************
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!
}
if (isset($btnSendEmail))
{echo "Send Email
";
// 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
";
// fetch array
while($saRow = mysql_fetch_array($intRes))
{$strEmail = $saRow["email"];
$strName = $saRow["name"];
$strBodyComplete = "Hello " . $strName[$i] . "!nn" . $strBody;
mail($strEmail,$strSubject,$strBodyComplete,$strHeader);
// Output
echo "Send to $strName
";
}
}
?>
