Latest web development tutorials

PHP mysqli_options () function

PHP MySQLi Reference Manual PHP MySQLi Reference Manual

Examples

Open a new connection to a MySQL server:

<?php
$con=mysqli_init();
if (!$con)
{
die("mysqli_init failed");
}

mysqli_options($con,MYSQLI_READ_DEFAULT_FILE,"myfile.cnf");

if (!mysqli_real_connect($con,"localhost","my_user","my_password","my_db"))
{
       die("连接错误: " . mysqli_connect_error());
}

mysqli_close($con);
?>

Definition and Usage

mysqli_options () function to set up additional connectivity options for influencing the behavior of the connection.

mysqli_options () function can be called several times to set several options.

Note: mysqli_options () function can mysqli_init () and after mysqli_real_connect () prior to being called.


grammar

mysqli_options( connection,option,value ) ;

参数 描述
connection 必需。规定要使用的 MySQL 连接。
option 必需。规定要设置的选项。可以是下列值中的一个:
  • MYSQLI_OPT_CONNECT_TIMEOUT - 以秒为单位的连接超时时间
  • MYSQLI_OPT_LOCAL_INFILE - 启用/禁用 LOAD LOCAL INFILE
  • MYSQLI_INIT_COMMAND - 在连接到 MySQL 服务器之后的执行命令
  • MYSQLI_READ_DEFAULT_FILE - 从已命名的文件而不是 my.cnf 中读取选项
  • MYSQLI_READ_DEFAULT_GROUP - 从 my.cnf 或者 MYSQLI_READ_DEFAULT_FILE 中指定的文件中的已命名组中读取选项
  • MYSQLI_SERVER_PUBLIC_KEY - 基于 SHA-256 认证的 RSA 公共密钥文件
value 必需。规定 option 的值。

technical details

return value: If successful it returns TRUE, on failure returns FALSE.
PHP version: 5+
Update log: Added MYSQLI_SERVER_PUBLIC_KEY options in PHP 5.5.


PHP MySQLi Reference Manual PHP MySQLi Reference Manual