connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect);
$DB->select_db($dbname);
unset($servername, $dbusername, $dbpassword, $usepconnect);
// 增加回贴
if ($_POST['action'] == "add")
{
$email = $_POST['email'];
$query = "SELECT itemid FROM maillist WHERE email = '".$email."'";
$result = $DB->query($query);
if ($DB->num_rows($result) > 0)
{
echo "您的EMAIL已在邮件列表中。
";
echo "点此返回首页";
}
else
{
$query = "INSERT INTO maillist(email, datecreated) VALUES ('".$email."',now())";
$DB->query($query);
echo "您的EMAIL已加入邮件列表，谢谢您。
";
echo "点此返回首页";
}
}
else if ($_POST['action'] == "del")
{
$email = $_POST['email'];
$query = "DELETE FROM maillist WHERE email = '".$email."'";
$DB->query($query);
echo "您的EMAIL已从邮件列表中删除，谢谢您。
";
echo "点此返回首页";
}
else
{
?>
|
