PHP mysqli_options() 函式

---

---

定義和用法

mysqli_options() 函式用於設定額外的連線選項。如果要設定多個選項，需要多次呼叫此函式。

語法

mysqli_options($con, $option, $value)

引數

返回值

此函式返回布林值，成功則為true，失敗則為false。

PHP 版本

此函式首次引入於 PHP 5 版本，並在所有後續版本中有效。

示例

以下示例演示了mysqli_options() 函式的用法（過程式風格）：

<?php
   //Creating the connection
   $con = mysqli_connect("localhost","root","password","test");

   mysqli_options($con, MYSQLI_OPT_NET_CMD_BUFFER_SIZE, 15);

   if($con){
      print("Connection Established Successfully");
   }else{
      print("Connection Failed ");
   }
?>

這將產生以下結果：

Connection Established Successfully

示例

在面向物件風格中，此函式的語法為$con->options();以下是此函式在面向物件風格中的示例：

<?php
   //Creating the connection
   $con = new mysqli("localhost","root","password","test");

   $con->options(MYSQLI_OPT_NET_CMD_BUFFER_SIZE, 15);

   if($con){
      print("Connection Established Successfully");
   }else{
      print("Connection Failed ");
   }
?>

這將產生以下結果：

Connection Established Successfully

示例

在面向物件風格中，此函式的語法為$con->options();以下是此函式在面向物件風格中的示例：

<?php
   $connection_mysql = mysqli_init();

   if (!$connection_mysql){
      die("mysqli_init failed");
   }
   
   mysqli_options($connection_mysql, MYSQLI_OPT_CONNECT_TIMEOUT, 10);

   mysqli_options($connection_mysql,MYSQLI_READ_DEFAULT_FILE,"configure.cnf");
   
   $connection_mysql = mysqli_real_connect($connection_mysql, "localhost","root","password","mydb");

   
   if (!$connection_mysql){
      print("Connect Error: " . mysqli_connect_error());
   }else{
      print("Connection was successful");
   }   
?>

這將產生以下結果：

Connection was successful