mysqli::prepare

定義和用法

prepare() / mysqli_prepare()函數用於準備要執行的SQL 語句。

實例

例子1 - 面向對像風格

準備要執行的SQL 語句：

 <?php
$mysqli = new mysqli ( "localhost" , "my_user" , "my_password" , "my_db" ) ;

// 檢查連接
if ( $mysqli -> connect_errno ) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error ;
  exit ( ) ;
}

// 準備並綁定
$stmt = $mysqli -> prepare ( "INSERT INTO MyGuests (firstname, lastname, email) VALUES (?, ?, ?)" ) ;
$stmt -> bind_param ( "sss" , $firstname , $lastname , $email ) ;

// 設置參數並執行
$firstname = "John" ;
$lastname = "Doe" ;
$email = "john@example.com" ;
$stmt -> execute ( ) ;

$firstname = "Mary" ;
$lastname = "Moe" ;
$email = "mary@example.com" ;
$stmt -> execute ( ) ;

echo "New records created successfully" ;

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