Latest web development tutorials
 

PHP mysqli_options() Function

< PHP MySQLi Reference

Example

Open a new connection to the 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("Connect Error: " . mysqli_connect_error());
  }

mysqli_close($con);
?>

Definition and Usage

The mysqli_options() function sets extra connect options and affect behavior for a connection.

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

Note: The mysqli_options() function should be called after mysqli_init() and before mysqli_real_connect().

Syntax

mysqli_options(connection,option,value);

Parameter Description
connection Required. Specifies the MySQL connection to use
option Required. Specifies the option to set. Can be one of the following values:
  • MYSQLI_OPT_CONNECT_TIMEOUT - connection timout in seconds
  • MYSQLI_OPT_LOCAL_INFILE - enable/disable use of LOAD LOCAL INFILE
  • MYSQLI_INIT_COMMAND - command to execute after connecting to MySQL server
  • MYSQLI_READ_DEFAULT_FILE - read options from named file instead of my.cnf
  • MYSQLI_READ_DEFAULT_GROUP - read options from named group from my.cnf or the file specified in MYSQLI_READ_DEFAULT_FILE
  • MYSQLI_SERVER_PUBLIC_KEY - RSA public key file used with SHA-256 based authentication
value Required. Specifies the value for the option

Technical Details

Return Value: TRUE on success. FALSE on failure
PHP Version: 5+
Changelog: The MYSQLI_SERVER_PUBLIC_KEY option was added in PHP 5.5
< PHP MySQLi Reference