<?php    $conn = new mysqli('localhost','root','','orders'); //連接    $PRepare = "insert into t100 values (?,?,?)";//預設插入sql    $bind = $conn->prepare($prepare);    $t1 = NULL;    $t2 = 'Www';    $t3 = date('Y-m-d H:i:s');    $bind->bind_param('iss',$t1,$t2,$t3); //綁定    //注意iss：    //i為int，s為string類型；意思是強制這幾個參數的類型    $bind->execute();//執行    $prepare = "select * from t100"; //準備要查詢的語句    $bind = $conn->prepare($prepare);//預處理    $t1 = 10;    $bind->execute();//執行    $bind->bind_result($id, $name, $date);//將字段列綁定到變量上    $bind->store_result();//獲取結果集    while ($bind->fetch()){//遍歷        printf("%d == %s == %s<br />",$id,$name,$date);//輸出    }