hph mysql_HPH-——>mysql 批量删除

va

无标题文档

姓名:

代号

姓名

性别

民族

生日

操作

$xxm = "";

$tj= "1=1";if(!empty($_POST["xm"]) && $_POST["xm"]!="")

{

$xxm= $_POST["xm"];

$tj= "name like '%{$xxm}%'";

}//造连接对象

$db = new MySQLi("localhost","root","123","mydb");//写SQL语句

$sql = "select * from info where".$tj;

echo $sql;//执行SQL语句

$result = $db->query($sql);//读数据

$attr = $result->fetch_all();foreach($attr as$v)

{

echo"

";

$sex= $v[2]?"男":"女";//根据名族代号查询名族名称

$name = NationName($v[3]);//替换关键字

$newname = str_replace($xxm,"{$xxm}",$v[1]);

echo"

{$v[0]}{$newname}{$sex}{$name}{$v[4]} 删除 修改";/*foreach($v as $v1)

{

echo "

{$v1}";

}*/echo"

";

}//给一个民族代号，返回民族名称

function NationName($code)

{//造连接对象

$db = new MySQLi("localhost","root","123","mydb");//写SQL语句

$sql = "select name from nation where code='{$code}'";//执行SQL语句

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

$attr= $result->fetch_row();return $attr[0];

}?>

{//找到下面所有的复选框

var ck =document.getElementsByClassName("qx");//遍历所有复选框，设置选中状态

for(var i=0;i

{if(a.checked)

{

ck[i].setAttribute("checked","checked");

}else{

ck[i].removeAttribute("checked");

}

}

}

批量删除处理

$attr=array();if(!empty($_POST["sc"]))

{

$attr= $_POST["sc"];

}

$db= new MySQLi("localhost","root","123","mydb");/*foreach($attr as $v)

{

$sql = "delete from info where code='{$v}'";

$db->query($sql);

}*/$str= implode("','",$attr);//echo $str;

$sql= "delete from info where code in('{$str}')";

$db->query($sql);//delete from info where code in('p001','p002','p003')