mysqli_real_connect

(PHP 5)

mysqli_real_connect

mysqli->real_connect - Opens a connection to a mysql server

Описание

Процедурный стиль вызова

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

Объектно-ориентированный стиль вызова (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.

Поддерживаемые флаги - параметр flags

• MYSQLI_CLIENT_COMPRESS - Use compression protocolMYSQLI_CLIENT_FOUND_ROWSreturn 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)

Замечание: 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.

Возвращаемые значения

Возвращает TRUE в случае успешного завершения или FALSE в случае возникновения ошибки.

Примеры

Пример 1. Объектно-ориентированный стиль вызова

/* 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();

Пример 2. Процедурный стиль вызова

/* 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);

Результат выполнения данного примера:

Connection: Localhost via UNIX socket

Смотрите также: mysqli_connect(), mysqli_init(), mysqli_options(), mysqli_ssl_set() и mysqli_close().

Все функции mysql
Описание на ru2.php.net
Описание на php.ru