Вы не зарегистрированы? Нажмите здесь для регистрации.
Забыли пароль? Запросите новый здесь.
|
Вы должны авторизироваться, чтобы добавить сообщение.
|
|
|
Последние активные темы форума |
|
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Процедурный стиль 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.
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.
Возвращаемые значенияВозвращает TRUE в случае успешного завершения или FALSE в случае возникновения ошибки.
Примеры
Пример 1. Объектно-ориентированный стиль
<?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. Процедурный стиль
<?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 |
|
· Гостей: 1
· Пользователей: 0
· Всего пользователей: 453
· Новый пользователь: ZDA
|
|