master

分支 (1)

管理

管理

master

my-favorite-car-vote
/
admin.php

<?php include_once "checkedAdmin.php" ?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- 引入 layui.js -->
<script src="//unpkg.com/layui@2.6.11/dist/layui.js"></script>
  <script src="https://apps.bdimg.com/libs/jquery/2.1.4/jquery.min.js"></script>
  <title>我最喜欢的汽车投票</title>
  <style>
    .main {
      width: 80%;
      margin: 0 auto;
    }

    h1,
    h2 {
      text-align: center
    }

    h2 {
      font-size: 16px;
    }

    h2 a {
      text-decoration: none;
      margin-right: 5px;
      color: #4476A7;
    }

    h2 a:last-child {
      margin-right: 0;
    }

    h2 a:hover {
      color: black;
      text-decoration: underline;
    }

    h2 a:visited {
      color: #4476A7;
    }

    .current {
      color: blueviolet;
    }

    .style-table tr:hover:nth-child(n+2) {
      background-color: #faebd7;
    }

    .style-table {
      text-align: center;
    }
  </style>
</head>
<?php
include_once "conn.php";
include_once "page.php";
$sql = "SELECT count(1) as total FROM carinfo"; //查询数量采用count聚合函数统计表中所有记录数，as可以省略，别用num_rows这个数据多了效率不行。
$result = mysqli_query($conn, $sql);
$info = mysqli_fetch_array($result);
$total = $info['total']; //得到记录总条数
$perPage = 4; //设置一页显示多少条记录；
$page = $_GET['page'] ?? 1; //读取当前页码数 等于 $page = isset($_GET['page'])?$_GET['page']:1;
paging($total, $perPage); //引用分页函数
$sql = "SELECT * FROM carinfo order by id desc limit $firstCount,$displayPG"; //查询所有且逆序排序,limit 规定查询从那一条开始参数是$firstCount，从$firstCount+1开始查，查多少条$displayPG
$result = mysqli_query($conn, $sql);
?>

<body>
  <h1>车辆后台管理系统</h1>
  <h2><a href="index.php">返回首页</a><a href="admin.php" style="color: blueviolet;">车辆管理</a> <a href="show.php">数据查看</a><a href="logout.php">注销</a></h2>
  <div class="main">
    <table border="0" width="100%" align="cneter">
      <tr>
        <td>
          <!-- border-collapse用于边框合并 cellspacing="0"指单元格间间距 cellpadding="10" 指内容和单元格间距-->
          <table align="cneter" width="100%" border="1" bordercolor="black" cellspacing="0" cellpadding="10" style="border-collapse: collapse" class="style-table">
            <tr>
              <td width="8%">序号</td>
              <td width="15%">车辆名称</td>
              <td width="30%">车辆描述</td>
              <td width="20%">图片</td>
              <td width="8%">票数</td>
              <td>操作</td>
            </tr>
            <?php
            $i = ($page - 1) * $perPage + 1;
            while ($info = mysqli_fetch_array($result)) { //这里需要注意，只有while（）括号里面是sql返回的$result才可以自减，其他变量不可以，需要在花括号自减
            ?>
              <!-- 注意 判断用== 赋值属性要带单引号 -->
              <tr>
                <td><?php echo "$i" ?></td>
                <td><?php echo $info['carName'] ?></td>
                <td><?php echo $info['carDesc'] ?></td>
                <td><img src="/img/<?php echo $info['carPic']; ?>" width="80%"></td>
                <td><?php echo $info['carNum']; ?></td>
                <td><a href="modifyCar.php?id=<?php echo $info['id'] ?>">修改资料</a> <a href="javascript:del('<?php echo $info['carName']?>' , <?php echo $info['id'] ?>)">删除资料</a></td>
              </tr>
            <?php
              $i++;
            }
            ?>
          </table>
        </td>
      </tr>
      <tr>
        <td align="right"><?php echo $pageNav; ?></td>
      </tr>
      <tr>
        <td>
          <h2>车辆添加</h2>
          <!-- 增加上传文件功能以后form需要添加 enctype="multipart/form-data" 编码类型调整，默认编码类型只能上传文本格式，这个编码可以上传文本和二进制数据-->
          <form action="postAddCar.php" method="POST" enctype="multipart/form-data" onsubmit="return check()">
            <table border="1" bordercolor="black" width="80%" cellspacing="10" cellpadding="10" style="border-collapse:collapse ">
              <tr>
                <td align="right">车辆名称：</td>
                <td align="left"><input type="text" name="carName" id="carName"></td>
              </tr>
              <tr>
                <td align="right">车辆描述：</td>
                <td align="left"><textarea name="carDesc" id="carDesc" cols="30" rows="10"></textarea></td>
              </tr>
              <tr>
                <td align="right">车辆图片：</td>
                <td align="left"><input type="file" name="carPic" id="carPic"></td>
              </tr>
              <tr>
                <td align="right"><input type="submit" value="添加"></td>
                <td align="left"><input type="reset" value="重置"></td>
              </tr>
            </table>
          </form>
        </td>
      </tr>
    </table>
  </div>
  <script>
   function del(name,id){
        layer.confirm('您确认要删除车辆 ' + name + ' ?', {icon: 3  , title:'提示'}, function(index){
            location.href = 'delCar.php?id='+id;
            layer.close(index);
        })
    }
    //此处应该再加上正则验证
    function check() {
      let carName = $("#carName").val().trim();
      let carDesc = $("#carDesc").val().trim();
      let carPic = $("#carPic").val().trim();
      if (carName == '' || carDesc == '' || carPic == '') {
        alert('车辆名称、车辆描述、车辆图片都必须要填写');
        return false;
      }
      return true;
    }
  </script>
</body>
</html>