# options

mysqli::options

mysqli_options

Set options

# 

ENTITY

ENTITY

<div data-wrapper="1" role="mysqli">

public

</div>

<div data-wrapper="1" role="mysqli">

bool

</div>

<div data-wrapper="1" role="mysqli">

mysqli::options

</div>

<div data-wrapper="1" role="mysqli">

int

</div>

<div data-wrapper="1" role="mysqli">

option

</div>

<div data-wrapper="1" role="mysqli">

string

</div>

<div data-wrapper="1" role="mysqli">

int

</div>

<div data-wrapper="1" role="mysqli">

value

</div>

ENTITY

bool

mysqli_options

mysqli

mysql

int

option

string

int

value

Used to set extra connect options and affect behavior for a connection.

This function may be called multiple times to set several options.

`mysqli_options` should be called after `mysqli_init` and before `mysqli_real_connect`.

# 

ENTITY

`option`  
The option that you want to set. It can be one of the following values:

| Name | Description |
|----|----|
| `MYSQLI_OPT_CONNECT_TIMEOUT` | Connection timeout in seconds |
| `MYSQLI_OPT_READ_TIMEOUT` | Command execution result timeout in seconds. Available as of PHP 7.2.0. |
| `MYSQLI_OPT_LOCAL_INFILE` | Enable/disable use of `LOAD LOCAL INFILE` |
| `MYSQLI_OPT_LOAD_DATA_LOCAL_DIR` | Directory to be used for `LOAD DATA LOCAL INFILE`. |
| `MYSQLI_INIT_COMMAND` | Command to execute after establishing a connection to the MySQL server |
| `MYSQLI_SET_CHARSET_NAME` | The charset to be set as default. |
| `MYSQLI_READ_DEFAULT_FILE` | Read options from named option file instead of `my.cnf` Not supported by mysqlnd. |
| `MYSQLI_READ_DEFAULT_GROUP` | Read options from the named group from `my.cnf` or the file specified with `MYSQL_READ_DEFAULT_FILE`. Not supported by mysqlnd. |
| `MYSQLI_SERVER_PUBLIC_KEY` | RSA public key file used with the SHA-256 based authentication. |
| `MYSQLI_OPT_NET_CMD_BUFFER_SIZE` | The size of the internal command/network buffer. Only valid for mysqlnd. |
| `MYSQLI_OPT_NET_READ_BUFFER_SIZE` | Maximum read chunk size in bytes when reading the body of a MySQL command packet. Only valid for mysqlnd. |
| `MYSQLI_OPT_INT_AND_FLOAT_NATIVE` | Convert integer and float columns back to PHP numbers when using non-prepared statements. Only valid for mysqlnd. |
| `MYSQLI_OPT_SSL_VERIFY_SERVER_CERT` | Whether to verify server certificate or not. |
| `MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS` | Whether the client should accept expired passwords. |
| `1` | Whether to use network communication compression. |

Valid options {#mysqli.options.parameters}

`value`  
The value for the option.

# 

ENTITY

ENTITY

# 

ENTITY ENTITY

# 

ENTITY

See `mysqli_real_connect`.

# 

ENTITY ENTITY

# 

ENTITY

`mysqli_init`, `mysqli_real_connect`