客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Title</title>
</head>
<body>
<?php
$db = new Mysqli("localhost","root","root","db_0808");
//!$db?"":die("链接错误");
empty(mysqli_connect_error())?"":die("链接错误");
$sql = "select * from student where is_delete='0'";
//$data = $db->query($sql)->fetch_all();
?>
<form action="batch_delete.php" method="post">
<table border="1">
<tr>
<td>id</td>
<td>名字</td>
<td>性别</td>
<td>班级</td>
<td>生日</td>
<td>操作</td>
<td>选择</td>
</tr>
<?php
$result=$db->query($sql);
while ($data=$result->fetch_row()){
// foreach ($data as $i){
if ($data[2]==1){
$data[2]="男";
}else if ($data[2]==0){
$data[2]="女";
}else{
$data[2]="保密";
}
echo "<tr>
<td>{$data[0]}</td>
<td>{$data[1]}</td>
<td>{$data[2]}</td>
<td>{$data[3]}</td>
<td>{$data[4]}</td>
<td><a href='delete.php?id={$data[0]}'>删除</a>
<a href='xiugai.php?id={$data[0]}'>修改</a>
</td>
<td><input type='checkbox' name='ids[]' value='{$data[0]}'></td>
<?php /** * Created by fcc * User: Administrator * Date: 2017/10/17 * Time: 15:16 */ $ids=$_POST['ids']; $db=new Mysqli("localhost","root","root","db_0808"); empty(mysqli_connect_error())?"":die("链接错误"); //$sql="DELETE FROM student WHERE Sno='{$id}'";//彻底删除 foreach ($ids as $i){ $sql = "update student set is_delete = '1' where Sno= '{$i}'";//表面删除 if ($db->query($sql)){ header("location:CURD.php"); }; };
|
2022-08-17
2022-08-12
2022-11-06
2022-07-18
2022-08-15
librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam
旧的模板消息将在 2020 年 1 月 10 号全面下架，也就是今天，不过貌似现在还可以用！
avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave
女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的
The component mcontrol.action in RISCV ISA Sim commit ac466a21df442c59962589ba29
medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho
A vulnerability, which was classified as problematic, has been found in SourceCo
openshift/osin: Golang OAuth2 server library
sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor
离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾
请发表评论