PHP MySQLi_STMT添加数据

php mysqli_stmt 添加数据：

<?php
	//预编译
	//1.创建mysqli对象
	$mysqli = new MySQLi("localhost", "root", "1234", "test");


	//2.创建预编译对象
	$sql = "insert into user1 (name, password, email, age) values(?, ?, ?, ?)";
	$mysqli_stmt = $mysqli->prepare($sql) or die($mysqli->error);

	//绑定参数
	$name = "小倩";
	$password = md5("xiaoqian");
	$email = "xiaoqian@qq.com";
	$age = 200;
	//参数绑定->给？赋值，这里类型和顺序都要对应
	//sssi：sss代表第一个、第二个、第三个参数为string型，i代表第四个参数为int型
	$mysqli_stmt->bind_param("sssi", $name, $password, $email, $age);

	//执行
	//execute()返回boolean型
	if(!$mysqli_stmt->execute()){
		die("操作失败".$mysqli_stmt->error);
	}else{
		echo "插入成功";
	}


	//继续添加
	$name = "老妖";
	$password = md5("laoyao");
	$email = "laoyao@qq.com";
	$age = 250;
	$mysqli_stmt->bind_param("sssi", $name, $password, $email, $age);
	//执行
	if(!$mysqli_stmt->execute()){
		die("操作失败".$mysqli_stmt->error);
	}else{
		echo "插入成功";
	}
	//多个添加也可以用while循环添加

	//释放资源
	$mysqli->close();
?>