mysqli扩展库增强-预处理mysqli_stmt批量输入

<?php 
    //mysqli扩展库增强-预处理mysqli_stmt
    //1、创建mysql对象
  	$mysqli=new mysqli("127.0.0.1","root","password","testdb");
  	//验证是否连接成功
    if($mysqli->connect_error){
    	die("连接失败".$mysqli->connect_error);
    }
    //2创建预编译对象

  	$sql="insert into user (name,password,email,age) value(?,?,?,?)";
  	$mysqli_stmt=$mysqli->prepare($sql);
  	//绑定参数
  	$name="zhangsan";
  	$password="123456";
  	$email="zhangsan@163.com";
  	$age="12";
  	//参数绑定   给?赋值
  	//
  	$mysqli_stmt->bind_param("sssi",$name,$password,$email,$age);

  	//执行
  	$b=$mysqli_stmt->execute();

  	if(!$b){
  		die("操作失败".$mysqli_stmt->error);
  	}else{
  		echo"操作ok";
  	}

    //关闭连接
    $mysqli-close();
  	

?>