PHP MySQL vorkompiliert

DML-Anweisung vorkompilieren und ausführen

<?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-Anweisung vorkompilieren und ausführen:

<?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();

?>

Das Obige stellt die PHP-MySQL-Vorkompilierung vor, einschließlich einiger Aspekte des Inhalts. Ich hoffe, dass es für Freunde hilfreich sein wird, die sich für PHP-Tutorials interessieren.