mysqli::real_connect
mysqli_real_connect
(PHP 5) mysqli_real_connect — Opens a connection to a mysql server
Description
Object oriented style (method)
bool mysqli::real_connect
([ string $host
[, string $username
[, string $passwd
[, string $dbname
[, int $port
[, string $socket
[, int $flags
]]]]]]] )
bool mysqli_real_connect
( mysqli $link
[, string $host
[, string $username
[, string $passwd
[, string $dbname
[, int $port
[, string $socket
[, int $flags
]]]]]]] )
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.
-
There is a flags
parameter.
Parameters
-
link
-
Procedural style only: A link identifier
returned by mysqli_connect() or mysqli_init()
-
host
-
Can be either a host name or an IP address. Passing the NULL value
or the string "localhost" to this parameter, the local host is
assumed. When possible, pipes will be used instead of the TCP/IP
protocol.
-
username
-
The MySQL user name.
-
passwd
-
If provided or NULL, the MySQL server will attempt to authenticate
the user against those user records which have no password only. This
allows one username to be used with different permissions (depending
on if a password as provided or not).
-
dbname
-
If provided will specify the default database to be used when
performing queries.
-
port
-
Specifies the port number to attempt to connect to the MySQL server.
-
socket
-
Specifies the socket or named pipe that should be used.
Note:
Specifying the socket
parameter will not
explicitly determine the type of connection to be used when
connecting to the MySQL server. How the connection is made to the
MySQL database is determined by the host
parameter.
-
flags
-
With the parameter flags
you can set different
connection options:
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.
Examples
Example #1 Object oriented style
<?php
$mysqli = mysqli_init();
$mysqli->options(MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=0");
$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5);
$mysqli->real_connect('localhost', 'my_user', 'my_password', 'world');
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
$link = mysqli_init();
mysqli_options($link, MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=0");
mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 5);
mysqli_real_connect($link, 'localhost', 'my_user', 'my_password', 'world');
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 example will output:
Connection: Localhost via UNIX socket
 add a note
User Contributed Notes
Opens a connection to a mysql server
There are no user contributed notes for this page.
|
|
mysqli::query
