Head First PHP 第4章 removeemail.php

来源：互联网发布：nlp分词算法编辑：程序博客网时间：2024/06/05 19:06
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />    <title>Make Me Elvis - Add Email</title>    <link rel="stylesheet" type="text/css" 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>Please select the email addresses to delete from the email list and click Remove.</p>    <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">    <?php    $dbc = mysqli_connect('localhost:3306', 'root', '', 'elvis_store')    or die('Error connecting mysql');    if(isset($_POST['submit']) && !empty($_POST['todelete'])) {        foreach($_POST['todelete'] as $delete_id) {            $query = "DELETE FROM email_list WHERE id = $delete_id";            mysqli_query($dbc, $query)                or die('Error querying database');        }        echo 'Customer(s) removed.<br />';    }    $query = "SELECT * FROM email_list";    $result = mysqli_query($dbc, $query);    while($row = mysqli_fetch_array($result)) {        echo '<input type="checkbox" value="' . $row['id'] . '" name="todelete[]" />';        echo $row['first_name'];        echo ' ' . $row['last_name'];        echo ' ' . $row['email'];        echo '<br />';    }    mysqli_close($dbc);    ?>    <input type="submit" name="submit" value="Remove" /></body></html>
0 0