php mysql 预编译

预编译执行 dml 语句

<?php

//mysql预编译
	$mysqli = new mysqli("localhost", "root", "root", "php");
	
	$mysqli->query("set names gbk");
	
	$sql = "insert into user1(name,psw,email,age) values(?,?,?,?)";
	
	$mysqli_stmt = $mysqli->prepare($sql);
	
	//绑定参数
	
	$name = "公子玮";
	$psw = "123";
	$email = "gonziwei.sohu,com";
	$age = 24;

	$mysqli_stmt->bind_param("sssi",$name,$psw,$email,$age);
	
	$b = $mysqli_stmt->execute();
	
	if(!$b){
		die("failed".$mysqli_stmt->error);
		exit();
	}else{
		echo "success<br/>";
	}
	
	
	//继续添加
	$name = "编程大师";
	$psw = "123";
	$email = "dashi.sohu,com";
	$age = 25;
	
	$mysqli_stmt->bind_param("sssi",$name,$psw,$email,$age);
	
	$b = $mysqli_stmt->execute();
	
	if(!$b){
		die("failed".$mysqli_stmt->error);
		exit();
	}else{
		echo "success<br/>";
	}
	
	//继续添加
	$name = "编程屌丝";
	$psw = "123";
	$email = "diaoshi.sohu,com";
	$age = 25;
	
	$mysqli_stmt->bind_param("sssi",$name,$psw,$email,$age);
	
	$b = $mysqli_stmt->execute();
	
	if(!$b){
		die("failed".$mysqli_stmt->error);
		exit();
	}else{
		echo "success<br/>";
	}
	
	$mysqli->close();
?>

预编译执行 dql 语句：

<?php

	//预编译 执行 dql 语句
	header("Content-type:text/html;charset=utf-8");
	$mysqli = new mysqli("localhost", "root", "root", "php");
	
	if($mysqli->connect_error){
		die($mysqli->connect_error);
		exit();
	}
	//create a predefined object and get a position
	
	$sql = "select id,name,email from user1 where id > ?";
	
	$mysqli_stmt = $mysqli->prepare($sql);
	$id = 5;
	//bind param
	$mysqli_stmt->bind_param("i",$id);
	
	//bind results
	
	$mysqli_stmt->bind_result($id,$name,$email);
	
	
	$mysqli_stmt->execute();
	
	while ($mysqli_stmt->fetch()){
		echo "--$id--$name--$email<br/>";
	}
	
	$mysqli_stmt->close();
	
	$mysqli->close();
	
?>