addemail.php
1<!DOCTYPE html> 2<html lang="cn" dir="ltr"> 3 <head> 4 <meta charset="UTF-8"> 5 <title>猫王商店 - 添加邮箱</title> 6 <link rel="stylesheet" href="style.css"> 7 </head> 8 <body> 9 <img src="blankface.jpg" width="161" height="350" alt="" style="float:right"> 10 <img name="elvislogo" src="elvislogo.gif" width="229" height="32" border="0" alt="Make Me Elvis"> 11 <p>E添加你的名字和邮箱到 <strong>猫王商店</strong> 的邮箱列表。</p> 12 <?php 13 if(isset($_POST['submit'])){ 14 $name = $_POST['name']; 15 $email = $_POST['email']; 16 $output_form = 'no'; 17 18 if (empty($name) || empty($email)) { 19 echo '请完整填写要求的内容.<br />'; 20 $output_form = 'yes'; 21 } 22 } 23 else { 24 $output_form = 'yes'; 25 } 26 27 28 if(!empty($name)&&!empty($email)){ 29 $dbc = mysqli_connect('127.0.0.1','root','','elvis_store') 30 or die('链接MySQL失败。'); 31 32 $query = "INSERT INTO email_list (name, email)". 33 "VALUES ('$name', '$email')"; 34 mysqli_query($dbc, $query) 35 or die('数据添加失败。'); 36 37 echo '顾客信息添加完成。'; 38 39 mysqli_close($dbc); 40 } 41 42 if ($output_form == 'yes'){ 43 ?> 44 45 <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> 46 <label for="NAME">姓名:</label> 47 <input type="text" name="name" id="name"><br> 48 <label for="email">邮箱地址：</label> 49 <input type="text" name="email" id="name"><br> 50 <input type="submit" name="submit" value="提交"> 51 </form> 52 53 <?php 54 } 55 ?> 56 </body> 57</html>
sendemail.php
1<!DOCTYPE html> 2<html lang="cn" dir="ltr"> 3 <head> 4 <meta charset="utf-8"> 5 <title>猫王商店 - 发送邮件</title> 6 <<link rel="stylesheet" href="style.css"> 7 </head> 8 <body> 9 <img src="blankface.jpg" alt="黑脸" width="161" height="350" style="float:right"> 10 <img src="elvislogo.gif" alt="猫王商店" name="elvislogo" width="229" height="32" border="0"> 11 <p><strong>私人的：</strong>仅供Elmer使用<br> 12 向邮箱列表的成员写和发送邮件。</p> 13 <?php 14 if (isset($_POST['submit'])) { 15 $from = 'xxxxxxxx@xxx.com'; 16 $subject = $_POST['subject']; 17 $text = $_POST['elvismail']; 18 $output_form = false; 19 20 if (empty($subject) && empty($text)) { 21 // We know both $subject AND $text are blank 22 echo '你忘记输入邮件的标题和内容。<br>'; 23 $output_form = true; 24 } 25 26 if (empty($subject) && (!empty($text))) { 27 echo '你忘记输入邮件标题<br>'; 28 $output_form = true; 29 } 30 31 if ((!empty($subject)) && empty($text)) { 32 echo '你忘记输入邮件正文.<br>'; 33 $output_form = true; 34 } 35 } 36 else { 37 $output_form = true; 38 } 39 40 if ((!empty($subject)) && (!empty($text))) { 41 $dbc = mysqli_connect('127.0.0.1','root','','elvis_store') 42 or die('链接MySQL失败。'); 43 $query = "SELECT * FROM email_list"; 44 $result = mysqli_query($dbc, $query) 45 or die('查询数据库失败。'); 46 47 while($row = mysqli_fetch_array($result)){ 48 $name = $row['name']; 49 50 $msg = "亲爱的 $name ，\n $text"; 51 $to = $row['email']; 52 mail($to, $subject, $msg, 'From:'.$from); 53 54 echo '邮件发送到了：'.$to.'<br>'; 55 } 56 57 mysqli_close($dbc); 58 } 59 60 if ($output_form) { 61 ?> 62 <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> 63 <label for="subject">邮件的标题：</label><br> 64 <input type="text" name="subject" id="subject" size="30"><br> 65 <label for="elvismail">邮件的内容：</label><br> 66 <textarea name="elvismail" id="elvismail" rows="8" cols="40"></textarea><br> 67 <input type="submit" name="Submit" value="提交"> 68 </form> 69 70 <?php 71 } 72 ?> 73 74 </body> 75</html>
removeemail.php
1<!DOCTYPE html> 2<html lang="cn" dir="ltr"> 3 <head> 4 <meta charset="utf-8"> 5 <title>猫王商店 - 删除邮箱</title> 6 <link rel="stylesheet" href="style.css"> 7 </head> 8 <body> 9 <img src="blankface.jpg" alt="黑脸" width="161" height="350" style="float:right"> 10 <img src="elvislogo.gif" alt="猫王logo" width="229" height="32" name="elvislogo" border="0"> 11 <p>输入你想要移除的邮箱。</p> 12 <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> 13 <?php 14 $dbc = mysqli_connect('127.0.0.1','root','','elvis_store') 15 or die('链接MySQL失败。'); 16 17 if(isset($_POST['submit'])){ 18 foreach ($_POST['todelete'] as $$delete) { 19 $query = "DELETE FROM email_list WHERE id = $delete_id0"; 20 mysqli_query($dbc, $query) 21 or die('查询数据库失败。'); 22 } 23 echo "顾客邮箱移除完毕。<br>"; 24 } 25 26 $query = "SELECT * FROM email_list"; 27 $result = mysqli_query($dbc, $query) 28 or die('查询数据库失败。'); 29 30 while($row = mysqli_fetch_array($result)){ 31 echo '<input type="checkbox" value="' .$row['id']. '" name="todelete[]">'; 32 echo "$row['name']"; 33 echo "$row['email']"; 34 echo "<br>"; 35 } 36 mysqli_close($dbc); 37 ?> 38 39 <input type="submit" name="submit" value="Remove" /> 40 </form> 41 </body> 42</html>