mysql预编译处理（mysqli、PDO）_MySQL

DML语句预编译：

MysqLi：

query("set names utf8");
	$sql = 'insert into user(id,name,age,email) values (?,?,?,?)';
	$mysqli_stmt = $mysqli->prepare($sql);


	$id = 2;
	$name = 'kung';
	$age = 28;
	$email = '[e-mail]';
	
	$mysqli_stmt->bind_param('isis',$id,$name,$age,$email);

	$res = $mysqli_stmt->execute();

	if(!$res){
		echo 'error'.$mysqli_stmt->error;
		exit;
	}else{
		echo 'ok';
	}

	$id = 3;
	$name = 'xiaoyu';
	$age = 28;
	$email = '[e-mail]';

	$mysqli_stmt->bind_param('isis',$id,$name,$age,$email);
	$res = $mysqli_stmt->execute();

	if(!$res){
		echo 'error'.mysqli_stmt->error;
		exit;
	}else{
		echo 'ok';
	}
?>

PDO：

getMessage();
}
	$pdo->query("set names utf8");
	
	$sql = 'inser into user values(:id,:name,:age,:email)';
	$pdo_stmt = $pdo->prepare($sql);
	
	$id = 2;
	$name = 'kung';
	$age = 27;
	$email = '[e-mail]';

	$pdo_stmt->bindParam(':id',$id);
	$pdo_stmt->bindParam(':name',$name);
	$pdo_stmt->bindParam(':age',$age);
	$pdo_stmt->bindParam(':email',$email);
	$pdo_stmt->execute();
?>

DQL语句预编译：

mysqli：

query("set names utf8");
	$sql = " select id,name from user where id > ?";
	$mysqli_stmt = $mysqli->prepare($sql);
	
	$id = 1;
	$mysqli_stmt->bind_param('i',$id);
	$mysqli_stmt->bind_result($id,$name);
	$mysqli_stmt->execute();
	
	while($mysqli_stmt->fetch()){
		echo $id.'--'.$name;
	}

	$mysqli_stmt->close();
	$mysqli->close();
?>