bool mysqli_real_connect ( object link [, string hostname [, string username [, string passwd [, string dbname [, int port [, string socket [, int flags]]]]]]])

Object oriented style (method)

class mysqli {

bool real_connect ( [string hostname [, string username [, string passwd [, string dbname [, int port [, string socket [, int flags]]]]]]])

}

mysqli_real_connect() attempts to establish a connection to a MySQL database engine running on hostname.

This function differs from mysqli_connect():

mysqli_real_connect() needs a valid object which has to be created by function mysqli_init()
With function mysqli_options() you can set various options for connection.

With the parameter flags you can set different connection options:

Table 1. Supported flags

Name	Description
`MYSQLI_CLIENT_COMPRESS`	Use compression protocol
`MYSQLI_CLIENT_FOUND_ROWS`	return number of matched rows, not the number of affected rows
`MYSQLI_CLIENT_IGNORE_SPACE`	Allow spaces after function names. Makes all function names reserved words.
`MYSQLI_CLIENT_INTERACTIVE`	Allow `interactive_timeout` seconds (instead of `wait_timeout` seconds) of inactivity before closing the connection
`MYSQLI_CLIENT_SSL`	Use SSL (encryption)

Note: For security reasons the MULTI_STATEMENT flag is not supported in PHP. If you want to execute multiple queries use the mysqli_multi_query() function.

Return values

Returns TRUE on success or FALSE on failure.

Example

Example 1. Object oriented style


<?php



/* create a connection object which is not connected */

$mysqli = mysqli_init();



/* set connection options */

$mysqli->options(MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=0");

$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5);



/* connect to server */

$mysqli->real_connect('localhost', 'my_user', 'my_password', 'world');



/* check connection */

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}



printf ("Connection: %s\n.", $mysqli->host_info);



$mysqli->close();

?>

Example 2. Procedural style


<?php



/* create a connection object which is not connected */

$link = mysqli_init();



/* set connection options */

mysqli_options($link, MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=0");

mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 5);



/* connect to server */

mysqli_real_connect($link, 'localhost', 'my_user', 'my_password', 'world');



/* check connection */

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}



printf ("Connection: %s\n.", mysqli_get_host_info($link));



mysqli_close($link);

?>

The above examples would produce the following output:

Connection: Localhost via UNIX socket

mysqli_real_connect

Description

Return values

See Also

Example