mysql先行編譯處理（mysqli、PDO）

標籤：mysql   php   mysqli   pdo   

DML語句先行編譯：

MysqLi：

<?php$mysqli = new mysqli("localhost","root","root","dbname");$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 = '[email protected]';$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 = '[email protected]';$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：

<?php$dns = 'mysql:dbname=dbname;host=127.0.0.1';$user = 'root';$password = 'root';try{$pdo = new PDO($dns,$user,$password);} catch(PDOException $e){echo $e->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 = '[email protected]';$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：

<?php$mysqli = new mysqli("localhost","root","root","dbname");$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();?>

mysql先行編譯處理（mysqli、PDO）