PHP. Руководство по PHP. 2005

mysqli_real_connect

(PHP 5)mysqli_real_connect

(no version information, might be only in CVS)mysqli->real_connect -- Opens a connection to a mysql server

Description

Procedural stylebool mysqli_real_connect (mysqli 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:

Таблица 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)
Замечание:
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.

Примеры

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)

Пример 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();
?>

Пример 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);
?>

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

Connection: Localhost via UNIX socket

PHP. Руководство по PHP. 2005

mysqli_real_connect

Description

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

Смотрите также

Примеры

Ваше письмо	×