MySqli 中预处理类 stmt

    $mysqli=@new mysqli("localhost","root","","sqldb");
    if(mysqli_connect_error()){
        echo "连接数据库错误".$mysqli_connect_error();
    }
    /*拼装数据*/
    $sql="insert into shop values (null,?,?,?)";
    $sql="update shop set name=?,price=?,description=? where id=?";
    /*插入数据*/
    $stmt=$mysqli->prepare($sql);
    /*绑定数据*/
    $stmt->bind_param("sdsi", $name, $price, $description, $id);
    /*赋值*/
    $name="zhangsanasdfadfasdfasdf";
    $price=2.3;
    $description="very good";
    $id=1;
    /*执行*/
    $stmt->execute();

<?php
    $mysqli= @new MySQLi("localhost","root","","sqldb");
    if(mysqli_connect_error()){
        echo "Error:".mysqli_connect_error();
    }
    /*拼装SQL*/
    $sql="select id,name,price,description from shop where id<?";
    /*插入*/
    $stmt=$mysqli->prepare($sql);
    var_dump($stmt);
    /*绑定*/
    $stmt->bind_param(i,$id);
    /*绑定结果集*/
    $stmt->bind_result($id,$name,$price,$description);
    /*赋值*/
    $id=10;
    /*执行*/
    $stmt->execute();
    /*取出结果集*/
    $stmt->store_result();
    echo "<table border=‘1‘>";
    //字段信息、列信息
    $result=$stmt->result_metadata();
        echo "<tr>";
    while($field=$result->fetch_field()){
        echo "<th>{$field->name}</th>";
    }
        echo "</tr>";
        /*fetch()查看结果集*/
    /*移动数据库指针*/
    //$stmt->data_seek(2);
    while($stmt->fetch()){
        echo "<tr>";
        echo "<td>$id</td><td>$name</td><td>$price</td><td>$description</td>";
        echo "</tr>";
    }
    echo "</table>";
    /*关闭结果集*/
    $stmt->free_result();
    /*关闭数据库d*/
    $stmt->close();
?>