mysqli::options
mysqli_options
(PHP 5, PHP 7)
mysqli::options -- mysqli_options — Set options
Description
Object oriented style
Procedural style
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().
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_TIMEOUTconnection timeout in seconds (supported on Windows with TCP/IP since PHP 5.3.1) MYSQLI_OPT_LOCAL_INFILEenable/disable use of LOAD LOCAL INFILE MYSQLI_INIT_COMMANDcommand to execute after when connecting to MySQL server MYSQLI_READ_DEFAULT_FILERead options from named option file instead of my.cnf MYSQLI_READ_DEFAULT_GROUPRead options from the named group from my.cnf or the file specified with MYSQL_READ_DEFAULT_FILE.MYSQLI_SERVER_PUBLIC_KEYRSA public key file used with the SHA-256 based authentication. MYSQLI_OPT_NET_CMD_BUFFER_SIZEThe size of the internal command/network buffer. Only valid for mysqlnd. MYSQLI_OPT_NET_READ_BUFFER_SIZEMaximum read chunk size in bytes when reading the body of a MySQL command packet. Only valid for mysqlnd. MYSQLI_OPT_INT_AND_FLOAT_NATIVEConvert integer and float columns back to PHP numbers. Only valid for mysqlnd. MYSQLI_OPT_SSL_VERIFY_SERVER_CERT -
value -
The value for the option.
Changelog
| Version | Description |
|---|---|
| 5.5.0 |
The MYSQLI_SERVER_PUBLIC_KEY and
MYSQLI_SERVER_PUBLIC_KEY options were added.
|
| 5.3.0 |
The MYSQLI_OPT_INT_AND_FLOAT_NATIVE,
MYSQLI_OPT_NET_CMD_BUFFER_SIZE,
MYSQLI_OPT_NET_READ_BUFFER_SIZE, and
MYSQLI_OPT_SSL_VERIFY_SERVER_CERT options were
added.
|
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() - Initializes MySQLi and returns a resource for use with mysqli_real_connect()
- mysqli_real_connect() - Opens a connection to a mysql server
English translation
You have asked to visit this site in English. For now, only the interface is translated, but not all the content yet.If you want to help me in translations, your contribution is welcome. All you need to do is register on the site, and send me a message asking me to add you to the group of translators, which will give you the opportunity to translate the pages you want. A link at the bottom of each translated page indicates that you are the translator, and has a link to your profile.
Thank you in advance.
Document created the 30/01/2003, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/php-rf-mysqli.options.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
