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 style
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]]]]]]])
}
mysql_real_connect() attempts to establish a connection to a MySQL database engine running on host.
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 diffrent 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.
Return values
Возвращает TRUE в случае успешного завершения, FALSE в случае возникновения ошибки.
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();
?> | |
Пример 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 |