425MySQLi面向对象实现更新操作

<?php
require 'mysqli_connect.php';
$sql = "UPDATE IGNORE staff SET name=?,salary=? WHERE staff_id=?;";
$stmt = $mysqli->stmt_init();
if($stmt->prepare($sql)){
	$data[] = ['name'=>'4hao0','salary'=>110,'staff_id'=>4];
	$data[] = ['name'=>'5hao0','salary'=>120,'staff_id'=>5];
	$data[] = ['name'=>'6hao0','salary'=>130,'staff_id'=>6];
	$stmt->bind_param('sii',$name,$salary,$staff_id);//绑定参数，此时变量$name都不存在
	foreach($data as $staff){//循环数组
		$name = $staff['name'];//将数组中的name值赋予$name
		$salary = $staff['salary'];
		$staff_id = $staff['staff_id'];
		$stmt->execute();//执行sql语句
	    if($stmt->affected_rows>0){
		echo '<br>更新成功'.$stmt->affected_rows.'条记录，id:'.$staff_id;
	    }else{
	    echo '<br>没有新增记录';
	    }
	}
}else{
	exit($stmt->errno.':'.$stmt->error);//输出错误信息
}
$mysqli->close();//关闭数据连接
?>

1