在PHP中删除数据的代码,php实现删除功能

php删除数据

$delete = $_POST['delete']; // POST方式获得复选框值

//单击删除按钮时

if ($submitdel) // 按提交按钮

{

//以，号组合成字符串，供mysql使用

$aryid=@implode(",",$delete);

$db-query("delete from `table` where id in($aryid)");

}

复选框的大致代码：

input type="checkbox" name="delete[]" value="?php echo $id; ?"

原理：复选框的name属性为delete[] 所以选择如果个之后获得的$delete值为一个数组，例如是$delete = array(0 = 1,1 = 2,2 = 3);

然后用implode函数将数组切割成字符串，$aryid=@implode(",",$delete);那么$aryid就是 $aryid = "1,2,3";

然后执行sql语句。delete from `table` where id in($aryid)

SQL语句就是delete from `table` where id in(1,2,3);

这样就很明白了吧

相关问答

Q1: 如何用PHP写一段删除数据库表中的一条记录？急求啊

//删除是记录是用sql语句，比如 delete from xxx(table) where id=1 删除 id=1的记录

//数据库操作后，手动关闭是好得习惯，不手动关闭，php程序也会最后自动关闭

Q2: PHP代码实现1)删除整个数组2)删除数组中指定的元素3)删除重复的元素？

$cars=array("Volvo","BMW","Toyota","BMW","23","33","23","67","23");

$cars2 = array_unique($cars);//元素去重

$cars2 = array_merge_recursive($cars2);//合并（因为去重后索引号不重新整理）

$delCars = array_splice($cars2,1,2);//从数组中移除索引号1开始共计2个元素

array_splice($cars2,0,(count($cars2)));//清空数组内容

unset($cars2);//或 $cars2 = null ，删除数组