NO.13 添加删除

 

<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>

<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<script src="bootstrap/js/jquery-1.11.2.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>

</head>

<body>

<table width="250px" border="1" cellspacing="0" cellpadding="0">
  <caption>人员信息展示</caption>
  <thead>
    <tr>
      <th>代号</th>
      <th>姓名</th>
      <th>性别</th>
      <th>民族</th>
      <th>生日</th>
      <th>操作</th>
    </tr>
  </thead>
  <tbody>
      <?php
    $db = new MySQLi("localhost","root","123","mydb");
    $sql = "select info.code,info.name,sex,nation.name,birthday from info,nation where info.nation=nation.code";
    $result = $db->query($sql);
    if($result){
        $arr = $result->fetch_all();
        foreach($arr as $v){
            $sex = $v[2]?"男":"女";
            echo "<tr>
      <td>{$v[0]}</td>
      <td>{$v[1]}</td>
      <td>{$sex}</td>
      <td>{$v[3]}</td>
      <td>{$v[4]}</td>
      <td><a href='./delete.php?code={$v[0]}' onclick=\"return confirm('确认删除么？')\">
　　　　　　<button type='button' class='btn btn-primary btn-sm'>删除</button></a></td>
    </tr>";
        }
    }
    ?>
  </tbody>
</table>

<div><a href="./tianjia.php">添加数据</a></div>

</body>
</html>

 

添加数据:

表单外层

添加样式：

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>

<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<script src="bootstrap/js/jquery-1.11.2.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>

</head>
<body>

<h1>添加数据</h1>

<from action="./add.php" method="post">
<div class="panel panel-default" style="max-width:500px">
    <div class="panel-body">

添加内容

         <div class="input-group">
            <span class="input-group-addon">代号：</span>
            <input type="text" class="form-control" placeholder="请输入代号" name="code">
        </div>
        <br />
        <div class="input-group">
            <span class="input-group-addon">姓名：</span>
            <input type="text" class="form-control" placeholder="请输入姓名" name="name">
        </div>
        <br />
        <div class="input-group">
            <span class="input-group-addon">性别：</span>
            &nbsp;&nbsp;
            男<input type="radio" name="sex" value="1" />
            &nbsp;
            女<input type="radio" name="sex" value="0" />
        </div>
        <br />
        <div class="input-group">
            <span class="input-group-addon">民族：</span>
            &nbsp;&nbsp;
               <select name="nation">

嵌入php代码读取数据库

                <?php
                $db = new MySQLi("localhost","root","123","mydb");
                $sql = "select * from nation";
                $result = $db->query($sql);
                if($result){
                    $arr = $result->fetch_all();
                    foreach($arr as $v){
                        echo "<option value='{$v[0]}'>{$v[1]}</option>";
                    }
                }
                ?>
            </select>
        </div>
        <br />
        <div class="input-group">
            <span class="input-group-addon">生日：</span>
            <input type="text" class="form-control" placeholder="请输入生日" name="birthday">
        </div>
        <br />
        <input class="btn btn-default" type="submit" value="添加数据">
        
    </div>
</div>
</form>

</body>

添加处理页面

<?php
//取值
$code = $_POST["code"];
$name = $_POST["name"];
$sex = (int)$_POST["sex"];
$nation = $_POST["nation"];
$birthday = $_POST["birthday"];
//往数据库送
$db = new MySQLi("localhost","root","123","mydb");
$sql = "insert into info values('{$code}','{$name}',{$sex},'{$nation}','{$birthday}')";

$result = $db->query($sql);

if($result){
    //header("location:tianjia.php");
    echo "<script type='text/javascript'>window.location.href='tianjia.php';</script>";
}else{
    echo "添加失败！";
}

 删除处理页面

<?php
$code = $_GET["code"];
$db = new MySQLi("localhost","root","123","mydb");
$sql = "delete from info where code='{$code}'";
$result = $db->query($sql);
if($result){
    header("location:main.php");
}else{
    echo "删除失败！";
}

 

posted on 2018-01-29 16:30  名为沐白  阅读(109)  评论(0)    收藏  举报
博客园  ©  2004-2026
浙公网安备 33010602011771号 浙ICP备2021040463号-3