#查询邮件列表并批量发送邮件 Ps:smtp服务未配置好
<?php
if(isset($_POST['submit'])){//提交按钮检测
$from = 'xxxx@qq.com';
$subject = $_POST['subject'];
$text = $_POST['elvismail'];
$output_form = false;//控制输出 false不输出
if((!empty($subject)) && (!empty($text)) ){//非空校验
require 'dbc.php';
$query = "select * from emaillist";
$res = mysqli_query($dbc, $query) or die ('error querying databases.');
while ($row = mysqli_fetch_array($res)) {
$to = $row['email'];
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$msg = "Dear $firstname $lastname,\n$text";
// mail($to, $subject, $msg, 'From:'.$from);//php邮件没配置好
echo 'email send to '.$to.' '.$msg. ' <br>';
}
mysqli_close($dbc);
}else{
echo 'please add content.';
}
}else{
$output_form = true;
}
if ($output_form) { //当没有提交按钮的时候输出表格
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="subject">Subject for email:</label><br>
<input type="text" name="subject" size="30" value="<?php echo @$subject; ?>"><br>
<label for="elvismail">Body for email:</label><br>
<textarea id="elvismail" name="elvismail" rows="8" cols="40"><?php echo @$text; ?></textarea><br>
<input type="submit" name="submit" value="submit">
</form>
<?php
}
?>