mysqli::options
mysqli_options
Set options
Description
Object oriented style
bool mysqli::options
( int $option
, mixed $value
)
bool mysqli_options
( mysqli $link
, int $option
, mixed $value
)
This function may be called multiple times to set several options.
mysqli_options should be called after
mysqli_init and before
mysqli_real_connect.
Parameters
-
link -
Procedural style only: A link identifier
returned by mysqli_connect or mysqli_init
-
option
-
The option that you want to set. It can be one of the following values:
Valid options
| Name |
Description |
MYSQLI_OPT_CONNECT_TIMEOUT |
connection timeout in seconds (supported on Windows with TCP/IP since PHP 5.3.1) |
MYSQLI_OPT_LOCAL_INFILE |
enable/disable use of LOAD LOCAL INFILE |
MYSQLI_INIT_COMMAND |
command to execute after when connecting to MySQL server |
MYSQLI_READ_DEFAULT_FILE |
Read options from named option file instead of my.cnf
|
MYSQLI_READ_DEFAULT_GROUP |
Read options from the named group from my.cnf
or the file specified with MYSQL_READ_DEFAULT_FILE.
|
MYSQLI_SERVER_PUBLIC_KEY |
RSA public key file used with the SHA-256 based authentication.
|
-
value
-
The value for the option.
Return Values
Returns TRUE on success or FALSE on failure.
Examples
See mysqli_real_connect.
Notes
Note:
MySQLnd always assumes the server default charset. This charset is sent during connection
hand-shake/authentication, which mysqlnd will use.
Libmysqlclient uses the default charset set in the
my.cnf or by an explicit call to mysqli_options prior to
calling mysqli_real_connect, but after mysqli_init.
See Also
- mysqli_init
- mysqli_real_connect