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
Color Picker