PHP mysqli_options() Function

## PHP Basic

PHP HOME PHP Intro PHP Install PHP Syntax PHP Variables PHP Echo / Print PHP Data Types PHP String Functions PHP Constants PHP Operators PHP If...Else...Elseif PHP Switch PHP While Loops PHP For Loops PHP Functions PHP Arrays PHP Sorting Arrays PHP Superglobals

## PHP Forms

PHP Form Handling PHP Form Validation PHP Form Required PHP Form URL/E-mail PHP Form Complete

## PHP Advanced

PHP Arrays Multi PHP Date PHP Include PHP File PHP File Upload PHP Cookies PHP Sessions PHP E-mail PHP Secure E-mail PHP Error PHP Exception PHP Filter

## PHP Database

PHP MySQL Intro PHP MySQL Connect PHP CREATE DB/Table PHP INSERT INTO PHP SELECT PHP WHERE PHP ORDER BY PHP UPDATE PHP DELETE PHP ODBC

## PHP XML

XML Expat Parser XML DOM XML SimpleXML

## PHP and AJAX

AJAX Intro AJAX PHP AJAX Database AJAX XML AJAX Live Search AJAX RSS Reader AJAX Poll

## PHP Reference

PHP Array PHP Calendar PHP Date PHP Directory PHP Error PHP Filesystem PHP Filter PHP FTP PHP HTTP PHP Libxml PHP Mail PHP Math PHP Misc PHP MySQLi PHP SimpleXML PHP String PHP XML PHP Zip PHP Timezones

## PHP Quiz

PHP Quiz PHP Certificate

# 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

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE