MySQLi 预处理批量删除语句

<?php
include("config.php");
if(empty($_SESSION['username'])){
	header("Location: index.php");
    exit;
}
//$all_id=$_POST['all_id'];
$all_id='540,541';

if($all_id!=""){
    $sql = "DELETE FROM data_type WHERE id=?";
	//mysqli_query($con,"DELETE FROM Persons WHERE LastName='Griffin'");
 
    // 为 mysqli_stmt_prepare() 初始化 statement 对象
    $stmt = mysqli_stmt_init($conn);
 
    //预处理语句
    if (mysqli_stmt_prepare($stmt, $sql)) {
        // 绑定参数
        mysqli_stmt_bind_param($stmt, 'i', $id);
 
        //循环删除 设置参数并执行
		$all_id = explode(',',$all_id);  
		for($i=0;$i<count($all_id);$i++){  
			$id = $all_id[$i];
			mysqli_stmt_execute($stmt);
		}  
        
    }
	$info=1;
	
}else{
	$info=0;
}
	
	
if($info==1){
	$msg='成功'.$_POST['all_id'].'!';
	echo $msg;
}else{
	$msg='失败'.$_POST['all_id'].'!';
	echo $msg;

}
?>