PHP Manual
Prev |  | Next

# mysqli_options

(PHP 5)

mysqli_options

(no version information, might be only in CVS)

mysqli->options -- Set options

## Description

Procedural style:

bool mysqli_options ( mysqli link, int option, mixed value )

Object oriented style (method)

class mysqli {
bool options ( int option, mixed value )
}

mysqli_options() can be 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().

The parameter option is the option that you want to set, the value is the value for the option. The parameter option can be one of the following values:

Table 1. Valid options

Name | Description
--- | ---
`MYSQLI_OPT_CONNECT_TIMEOUT` | connection timeout in seconds
`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`.

## Return Values

Returns `TRUE` on success or `FALSE` on failure.

## See Also

mysqli_init() and mysqli_real_connect().

## Examples

See mysqli_real_connect().

Prev | Home | Next
mysqli_num_rows | Up | mysqli_param_count