php mysql 先行編譯

先行編譯執行 dml 語句

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
";}//繼續添加$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
";}//繼續添加$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
";}$mysqli->close();?>

先行編譯執行 dql 語句：

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
";}$mysqli_stmt->close();$mysqli->close();?>

以上就介紹了php mysql 先行編譯，包括了方面的內容，希望對PHP教程有興趣的朋友有所協助。

