PHP 结合 Boostrap 结合 js 实现学生列表删除编辑及搜索功能
发布:smiling 来源: PHP粉丝网 添加日期:2021-11-22 23:45:08 浏览: 评论:0
这篇文章主要介绍了PHP 结合 Boostrap 结合 js 实现学生列表删除编辑以及搜索功能,非常不错,具有一定的参考借鉴价值 ,需要的朋友可以参考下。
这个自己的小项目要先告一段落了,可能还有许多bug,请见谅
删除学生功能
PHP:
- // 这里是通过前端代码HTML中的 url 传过来的,用 $_GET 来获取(相关HTML代码可以看一下到主页看一下前几条博客)
- if (emptyempty($_GET['num'])) exit('<h1>找不到您要删除的学生的学号</h1>');
- $num = $_GET['num'];
- $connection = mysqli_connect('localhost', 'root', '密码', 'students_info_system');
- if (!$connection) exit('<h1>连接数据库失败</h1>');
- $query = mysqli_query($connection, "delete from students where num = {$num}");
- if (!$query) exit('<h1>该学生信息查询失败</h1>');
- // 注意:这里传入的是连接对象
- $affected_rows = mysqli_affected_rows($connection);
- if ($affected_rows !== 1) exit('<h1>删除失败</h1>');
- header('Location: student_info.php');
编辑学生功能(整体上和添加学生功能差不到,稍微有些许变化)
HTML:
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>编辑学生</title>
- <link rel="stylesheet" type="text/css" href="css/Bootstrap.css" rel="external nofollow" >
- </head>
- <body>
- <div class="container mt-3">
- <h1 class="display-5 text-center">编辑学生</h1>
- <?php if (isset($error_msg)): ?>
- <div class="alert alert-danger"><?php echo $error_msg; ?></div>
- <?php endif ?>
- <div class="row mt-3">
- <img src="<?php echo $current_student['photo']; ?>" alt="<?php echo $current_student['name']; ?>" width="100" height="488" class="col-sm-6">
- <form action="<?php echo $_SERVER['PHP_SELF']; ?>?id=<?php echo $current_num; ?>" method="post" enctype="multipart/form-data" autocomplete="off" class="col-sm-6">
- <div class="form-group">
- <input type="number" name="num" class="form-control" placeholder="学号" value="<?php echo isset($_POST['num']) ? $_POST['num'] : $current_student['num']; ?>">
- </div>
- <div class="form-group">
- <select class="form-control" name="system">
- <option>请选择学院/系</option>
- <option <?php echo $current_student['system'] === '电气工程学院' ? 'selected' : ''; ?>>电气工程学院</option>
- <option <?php echo $current_student['system'] === '信息工程与艺术学院' ? 'selected' : ''; ?>>信息工程与艺术学院</option>
- <option <?php echo $current_student['system'] === '国际教育学院' ? 'selected' : ''; ?>>国际教育学院</option>
- <option <?php echo $current_student['system'] === '水利水电工程学院' ? 'selected' : ''; ?>>水利水电工程学院</option>
- <option <?php echo $current_student['system'] === '测绘与市政工程学院' ? 'selected' : ''; ?>>测绘与市政工程学院</option>
- <option <?php echo $current_student['system'] === '马克思主义学院' ? 'selected' : ''; ?>>马克思主义学院</option>
- <option <?php echo $current_student['system'] === '建筑工程学院' ? 'selected' : ''; ?>>建筑工程学院</option>
- <option <?php echo $current_student['system'] === '经济与管理学院' ? 'selected' : ''; ?>>经济与管理学院</option>
- </select>
- </div>
- <div class="form-group">
- <input type="text" name="class" class="form-control" placeholder="班级" value="<?php echo isset($_POST['class']) ? $_POST['class'] : $current_student['class']; ?>">
- </div>
- <div class="form-group">
- <input type="text" name="name" class="form-control" placeholder="姓名" value="<?php echo isset($_POST['name']) ? $_POST['name'] : $current_student['name']; ?>">
- </div>
- <div class="form-group">
- <select class="form-control" name="gender">
- <option value="-1">请选择性别</option>
- <option <?php echo $current_student['gender'] === '1' ? 'selected' : ''; ?> value="1">男</option>
- <option <?php echo $current_student['gender'] === '0' ? 'selected' : ''; ?> value="0">女</option>
- </select>
- </div>
- <div class="form-group">
- <label for="birthday">出生日期</label>
- <input type="date" name="birthday" class="form-control" id="birthday" value="<?php echo isset($_POST['birthday']) ? $_POST['birthday'] : $current_student['birthday']; ?>">
- </div>
- <div class="form-group">
- <label for="photo">照片</label>
- <input type="file" name="photo" class="form-control">
- </div>
- <button type="submit" class="btn btn-info btn-block">确认修改</button>
- </form>
- </div>
- </div>
- </body>
- </html>
PHP:
- if (emptyempty($_GET['id'])) exit('<h1>必须指定相应的学号</h1>');
- $current_num = $_GET['id'];
- $connection = mysqli_connect('localhost', 'root', '密码', 'students_info_system');
- if (!$connection) exit('<h1>连接数据库失败</h1>');
- $query = mysqli_query($connection, "select * from students where num = {$current_num} limit 1");
- if (!$query) exit('<h1>找不到您要编辑的学生信息</h1>');
- $current_student = mysqli_fetch_assoc($query);
- // var_dump($current_student);
- function edit_student() {
- // var_dump('进来了');
- global $connection;
- global $current_num; // 当前学生学号
- global $current_student;
- $extra_students_query = mysqli_query($connection, "select * from students where num != {$current_num}");
- if (!$extra_students_query) {
- exit('<h1>其余学生数据查询失败</h1>');
- // return;
- }
- // 查询除该学生以外的其他学生
- while ($student = mysqli_fetch_assoc($extra_students_query)) {
- // var_dump($student);
- $students_num[] = $student['num'];
- }
- // var_dump($students_num);
- // var_dump($_FILES['photo']);
- // var_dump($_POST['gender']);
- if (emptyempty($_POST['num'])) {
- $GLOBALS['error_msg'] = '请输入学号';
- return;
- }
- // 判断该学号是否已经被添加(即列表中已存在该学生)=========
- if (in_array($_POST['num'], $students_num)) {
- $GLOBALS['error_msg'] = '该学生已存在';
- return;
- }
- if (emptyempty($_POST['system']) || $_POST['system'] === '请选择学院/系') {
- $GLOBALS['error_msg'] = '请选择学院/系';
- return;
- }
- if (emptyempty($_POST['class'])) {
- $GLOBALS['error_msg'] = '请输入班级';
- return;
- }
- if (emptyempty($_POST['name'])) {
- $GLOBALS['error_msg'] = '请输入姓名';
- return;
- }
- if (!(isset($_POST['gender']) && $_POST['gender'] !== '-1')) {
- $GLOBALS['error_msg'] = '请选择性别';
- return;
- }
- if (emptyempty($_POST['birthday'])) {
- $GLOBALS['error_msg'] = '请输入出生日期';
- return;
- }
- // 以下处理文件域=======================================================
- // 当有文件上传时才验证,没有上传则照片不变
- // $_FILES['photo'] = $current_student['photo'];
- // var_dump($_FILES['photo']);
- if ($_FILES['photo']['name'] !== '') {
- // var_dump($_FILES['photo']);
- // var_dump($_FILES['photo']);
- if ($_FILES['photo']['error'] !== UPLOAD_ERR_OK) {
- $GLOBALS['error_msg'] = '上传照片失败';
- return;
- }
- // 验证上传文件的类型(只允许图片)
- if (strpos($_FILES['photo']['type'], 'image/') !== 0) {
- $GLOBALS['error_msg'] = '这不是支持的文件格式类型,请重新上传';
- return;
- }
- // 文件上传到了服务端开辟的一个临时地址,需要转移到本地
- $image_target = 'images/' . $_FILES['photo']['name'];
- if (!move_uploaded_file($_FILES['photo']['tmp_name'], $image_target)) {
- $GLOBALS['error_msg'] = '图片上传失败';
- return;
- }
- // 接收更新过的学生照片
- $current_student['photo'] = (string)$image_target;
- } else {
- // var_dump($_FILES['photo']);
- // 如果照片没有上传则不进行验证文件域,直接更新数据且不改变原来的照片
- $current_student['num'] = $_POST['num'];
- $current_student['system'] = $_POST['system'];
- $current_student['class'] = $_POST['class'];
- $current_student['name'] = $_POST['name'];
- $current_student['gender'] = $_POST['gender'];
- $current_student['birthday'] = $_POST['birthday'];
- }
- // var_dump($current_num);
- // 将数据修改存放到数据库
- $update_query = mysqli_query($connection, "update students set `num` = '{$current_student['num']}', `system` = '{$current_student['system']}', `class` = '{$current_student['class']}', `name` = '{$current_student['name']}', `gender` = '{$current_student['gender']}', `birthday` = '{$current_student['birthday']}', `photo` = '{$current_student['photo']}' where `num` = {$current_num}");
- if (!$update_query) {
- $GLOBALS['error_msg'] = '更新数据查询失败';
- return;
- }
- $affected_rows = mysqli_affected_rows($connection);
- if ($affected_rows !== 1) {
- $GLOBALS['error_msg'] = '修改失败';
- return;
- }
- // 延迟2秒
- time_sleep_until(time() + 2);
- header('Location: student_info.php');
- }
- if ($_SERVER['REQUEST_METHOD'] === 'POST') {
- edit_student();
- }
搜索功能(用js)
- // 关键词搜索功能----立即函数
- (function (element, search_key) {
- let table = document.getElementById('table-content'); // 获取表格
- function in_array_item (item, array) {
- for (var i = 0; i < array.length; i++) {
- if (array[i].indexOf(item) != -1) {
- return true;
- }
- }
- return false;
- }
- function response () {
- let hiddenStudentsNumber = 0; // 获取隐藏的学生个数(即表格隐藏行数)
- // 获取要搜索的关键词
- const search_content = document.getElementById(search_key).value;
- // console.log(search_content);
- // console.log(typeof(search_content));
- let data = [];
- // 遍历列表将数据存储到一个数组中
- // 1.获取表格行数
- for (let i = 0; i < table.children.length; i++) {
- // 2.获取表格列数
- for (let j = 0; j < table.children[i].children.length; j++) {
- if (!data[i]) {
- // 在数组中创键每一行内容存放的数组,用于存放一行数据
- data[i] = new Array();
- }
- data[i][j] = table.children[i].children[j].innerHTML.toString();
- // 3.存放数据
- if (data[i][j] === '♂') {
- data[i][j] = '男';
- }
- if (data[i][j] === '♀') {
- data[i][j] = '女';
- }
- }
- // console.log(data[i]);
- if (search_content == '') {
- table.children[i].style.display = '';
- } else {
- if (in_array_item(search_content, data[i])) {
- table.children[i].style.display = '';
- } else {
- table.children[i].style.display = 'none';
- hiddenStudentsNumber += 1;
- }
- }
- }
- console.log(hiddenStudentsNumber);
- let str = "共有" + (table.children.length - hiddenStudentsNumber) + "名学生";
- document.getElementById('students_number').innerHTML = str;
- }
- const searchButton = document.getElementById(element);
- searchButton.addEventListener('click', function () {
- response();
- });
- document.addEventListener('keydown', function (event) {
- if (event.keyCode === 13) {
- response();
- }
- });
- let str = "共有" + table.children.length + "名学生";
- document.getElementById('students_number').innerHTML = str;
- })('search', 'search-key');
同时在原有的学生信息页面HTML添加:
- <div class="row mt-3">
- <a class="btn btn-info col-sm-2" style="margin-right: 28px; margin-left: 15px;" href="add_student.php" rel="external nofollow" >添加学生</a>
- // 添加的
- <button class="btn btn-info align-middle" id="students_number"></button>
- <input type="text" class="form-control col-sm-6 ml-2" autocomplete="on" placeholder="请输入关键词" value="" id="search-key">
- <button type="submit" class="btn btn-info col-sm-2 ml-2" id="search">点击搜索</button>
- </div>
Tags: Boostrap PHP列表删除
相关文章
- ·PHP 是什么?(2013-11-12)
- ·Php.ini文件位置在哪里 Php.ini文件找不到(2013-11-12)
- ·点击浏览器的后退按钮后,所有字段的信息都被清空了?(2013-11-12)
- ·PHP 数据类型(2013-11-12)
- ·php 获取当前脚本的url(2013-11-12)
- ·php技术生成静态页面的实现(2013-11-13)
- ·缺陷月项目启动 披露PHP脚本语言漏洞(2013-11-13)
- ·在PHP中全面阻止SQL注入式攻击(2013-11-13)
- ·php生成随机密码的几种方法(2013-11-13)
- ·PHP中使用FCKeditor2.3.2配置(2013-11-13)
- ·如何使用PHP开发高效的WEB系统(2013-11-13)
- ·php过滤危险html代码(2013-11-13)
- ·php:树形结构的算法(2013-11-13)
- ·php4和php5区别(2013-11-13)
- ·php数据库连接(2013-11-13)
- ·如何正确理解PHP的错误信息(2013-11-13)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)