Head First PHP&MySQl第三章代码

addemail.html

<!DOCTYPE html>
<html lang="cn">
<head>
  <meta charset="UTF-8">
  <title>猫王商店 - 添加邮箱</title>
  <link rel="stylesheet" href="style.css">
</head>
<body>
  <img src="blankface.jpg" width="161" height="350" alt="" style="float:right">
  <img name="elvislogo" src="elvislogo.gif" width="229" height="32" border="0" alt="Make Me Elvis">
  <p>E添加你的名字和邮箱到 <strong>猫王商店</strong> 的邮箱列表。</p>
  <form method="post" action="addemail.php">
    <label for="name">名字：</label>
    <input type="text" id="name" name="name"><br>
    <label for="email">邮箱：</label>
    <input type="text" id="email" name="email"><br>
    <input type="submit" name="Submit" value="提交">
  </form>
</body>
</html>

addemail.php

<?php
  $dbc = mysqli_connect('127.0.0.1','root','','elvis_store')
    or die('链接MySQL失败。');

  $name = $_POST['name'];
  $email = $_POST['email'];

  $query = "INSERT INTO email_list (name, email) ".
    "VALUES ('$name', '$email')";
  mysqli_query($dbc, $query)
    or die('查询数据库失败。');

  echo '完成填写。';
  mysqli_close($dbc);
?>

sendemail.html

<!DOCTYPE html>
<html lang="cn" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>猫王商店 - 发送邮件</title>
    <<link rel="stylesheet" href="style.css">
  </head>
  <body>
    <img src="blankface.jpg" alt="黑脸" width="161" height="350" style="float:right">
    <img src="elvislogo.gif" alt="猫王商店" name="elvislogo" width="229" height="32" border="0">
    <p><strong>私人的：</strong>仅供Elmer使用<br>
      向邮箱列表的成员写和发送邮件。</p>

    <form action="sendemail.php" method="post">
      <label for="subject">邮件的标题：</label><br>
      <input type="text" name="subject" id="subject" size="30"><br>
      <label for="elvismail">邮件的内容：</label><br>
      <textarea name="elvismail" id="elvismail" rows="8" cols="40"></textarea><br>
      <input type="submit" name="Submit" value="提交">
    </form>
  </body>
</html>

sendemail.php

<?php
  $from = '2842310586@qq.com';
  $subject = $_POST['subject'];
  $text = $_POST['elvismail'];

  $dbc = mysqli_connect('127.0.0.1','root','','elvis_store')
    or die('链接MySQL失败。');
  $query = "SELECT * FROM email_list";
  $result = mysqli_query($dbc, $query)
    or die('查询数据库失败。');

  while($row = mysqli_fetch_array($result)){
    $name = $row['name'];

    $msg = "亲爱的 $name ，\n $text";
    $to = $row['email'];
    mail($to, $subject, $msg, 'From:'.$from);

    echo '邮件发送到了：'.$to.'<br>';
  }

  mysqli_close($dbc);
 ?>

removeemail.html

<!DOCTYPE html>
<html lang="cn" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>猫王商店 - 删除邮箱</title>
    <link rel="stylesheet" href="style.css">
  </head>
  <body>
    <img src="blankface.jpg" alt="黑脸" width="161" height="350" style="float:right">
    <img src="elvislogo.gif" alt="猫王logo" width="229" height="32" name="elvislogo" border="0">
    <p>输入你想要移除的邮箱。</p>
    <form action="removeemail.php" method="post">
      <label for="email">邮箱地址：</label>
      <input type="text" name="email" id="name" size="30"><br>
      <input type="submit" name="Remove" value="移除">
    </form>
  </body>
</html>

removeemail.php

<?php
  $dbc = mysqli_connect('127.0.0.1','root','','elvis_store')
    or die('链接MySQL失败。');
  $email = $_POST['email'];
  $query = "DELETE FROM email_list WHERE email = '$email'";
  mysqli_query($dbc,$query)
    or die('查询数据库失败。');
  echo $email."已被移除";
  mysqli_close($dbc;
?>

 

posted on 2019-07-02 20:06  llyydd  阅读(201)  评论(0)    收藏  举报

导航