先贴代码
//js文件贴在后面
<script src="check.js" type="text/javascript"></script>
<?php
/**
* Created by PhpStorm.
* User: BAI
* Date: 2019/7/12
* Time: 11:13
*/
header("Content-Type:text/html;charset=utf-8");
//require 'connect.php';
$con = mysqli_connect('127.0.0.1','root','root','test');//连接数据库
$con->set_charset("utf8");
if(mysqli_connect_error($con)){
echo "Connect Error";
}
$sql = "SELECT * FROM `test` WHERE 1";
$result = $con->query($sql);
//index.php就是本文
if($result){
echo "<form action='index.php' method='post'><table border='1'><tr><td></td><td>ID</td><td>numbers</td></tr>";
while($row = mysqli_fetch_assoc($result)){
echo "<tr><td><input type='checkbox' name='ID[]' value='".$row['id']."'></td><td>".$row['id']."</td><td>".$row['numbers']."</td></tr>";
}
echo "<tr><td><input type='checkbox' id='all_check' name='all_check' onclick='check_all()'>全選</td></tr>";
echo"<tr><td></td><td><select name='sel'><option value='已報名'>已報名</option><option value='通過初試'>通過初試</option><option value='通過復試'>通過復試</option></select></td><td><input type='submit'></td></tr></table></form>";
}
else{
echo "sql执行失败";
}
//太菜了,不知道怎么解决,于是用@来忽略notice,欢迎指导
if(@$_POST['ID'] != ""){
$a = implode(',',@$_POST['ID']);
$num = $_POST['sel'];
//var_dump($a);
$sqli = "UPDATE `test` SET `numbers`= '$num' WHERE `id` in (".$a.")";
//echo $a."<br>";
$result = mysqli_query($con,$sqli);
var_dump($result);
if($result){
echo "修改成功";
header('location: '.$_SERVER['HTTP_REFERER']);//刷新页面
}
else{
echo "修改失敗";
}
}
else{
echo "請選擇";
}
下面是js的代码
//功能
//当全选按钮被按下,调用这个函数,遍历复选框的那个数组,设置为true
function check_all() {
var all = document.getElementById('all_check');//全选按钮
var check = document.getElementsByName('ID[]');//几个复选框
if(all.checked == true){
for(var i = 0;i < check.length;i++){
check[i].checked = true;
}
}
else{
for(var i = 0;i < check.length;i++){
check[i].checked = false;
}
}
}