模式二：SELECT 查詢

<?php
$sql = "SELECT id, name, price, num, desn FROM shops WHERE id > ?";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("i", $id);              // 綁定輸入參數
$stmt->bind_result($id, $name, $price, $num, $desn); // 綁定輸出列（順序必須一致）

$id = 99;
$stmt->execute();
$stmt->store_result();                    // 緩存結果集，才能用 num_rows/data_seek

// 字段元數據
$meta = $stmt->result_metadata();
while ($field = $meta->fetch_field()) {
    echo $field->name . " ";
}
echo "<br>";

// 讀取數據
$stmt->data_seek(2);                      // 跳到第 3 行
while ($stmt->fetch()) {
    echo "$id--$name--$price--$num--$desn<br>";
}
echo "總行數: " . $stmt->num_rows;

$stmt->free_result();
$stmt->close();
?>

實例二：批量插入與查詢（簡化版）

<?php
$mysqli = new mysqli("localhost", "root", "", "test");
$mysqli->query("SET NAMES 'gbk'");

$stmt = $mysqli->prepare("INSERT INTO `test` (`name`,`age`,`dpc`) VALUES (?,?,?)");
$stmt->bind_param("sis", $name, $age, $dpc);

foreach (range(1,4) as $i) {
    $name = "陳華$i"; $age = 25; $dpc = "web開發筆記...";
    $stmt->execute();
}
echo "Last ID: " . $stmt->insert_id . "<br>";
echo "Affected: " . $stmt->affected_rows;
$stmt->close();
?>

實例三：查詢綁定結果

<?php
$mysqli = new mysqli("localhost", "root", "", "test");
$mysqli->query("SET NAMES 'gbk'");

$stmt = $mysqli->prepare("SELECT * FROM `test` WHERE `id` > ?");
$stmt->bind_param("i", $id);
$id = 5;
$stmt->execute();
$stmt->bind_result($id, $name, $age, $dpc);

while ($stmt->fetch()) {
    echo "$name----$age----$dpc<br>";
}
$stmt->close();
?>

關鍵方法速查