$arr=implode(",",$ids);
//echo $arr;
$sql = "DELETE FROM student WHERE id IN (?)";
$st =$pdo->prepare($sql);
var_dump($st->bindParam(1,$arr,PDO::PARAM_STR));
$st->execute();
部分代码,请问怎么做批量删除啊,我现在只能删除第一个。
//echo $arr;
$sql = "DELETE FROM student WHERE id IN (?)";
$st =$pdo->prepare($sql);
var_dump($st->bindParam(1,$arr,PDO::PARAM_STR));
$st->execute();
部分代码,请问怎么做批量删除啊,我现在只能删除第一个。
$clause = str_repeat("?,", count($ids)-1) . "?";
$sql = "DELETE FROM student WHERE id IN ($clause)";
$st =$pdo->prepare($sql);
$st->execute($ids);