PHP mysqli_real_connect() Function
PHP MySQLi Reference
Example
Open a new connection to the MySQL server:
<?php
$con=mysqli_init();
if (!$con)
{
die("mysqli_init failed");
}
if
(!mysqli_real_connect($con,"localhost","my_user","my_password","my_db"))
{
die("Connect Error: " . mysqli_connect_error());
}
mysqli_close($con);
?>
Definition and Usage
The mysqli_real_connect() function opens a new connection to the MySQL server.
The mysqli_real_connect() function differs from mysqli_connect() in the
following ways:
- mysqli_real_connect() requires a valid object created by mysqli_init()
- mysqli_real_connect() can be used with mysqli_options() to set different options for the connection
- mysqli_real_connect() has a flag parameter
Syntax
mysqli_real_connect(connection,host,username,password,dbname,port,socket,flag);
Parameter |
Description |
connection |
Required. Specifies the MySQL connection to use |
host |
Optional. Specifies a host name or an IP address |
username |
Optional. Specifies the MySQL username |
password |
Optional. Specifies the MySQL password |
dbname |
Optional. Specifies the default database to be used |
port |
Optional. Specifies the port number to attempt to connect to the MySQL
server |
socket |
Optional. Specifies the socket or named pipe to be used |
flag |
Optional. Specifies different connection options. Possible values:
- MYSQLI_CLIENT_COMPRESS - Use compression protocol
- MYSQLI_CLIENT_FOUND_ROWS - Return number of matched rows (not
affected rows)
- MYSQLI_CLIENT_IGNORE_SPACE - Allow spaces after function names. Make
function names reserved words
- MYSQLI_CLIENT_INTERACTIVE - Allow interactive_timeout seconds of
inactivity before closing connection
- MYSQLI_CLIENT_SSL - Use SSL encryption
|
Technical Details
Return Value: |
TRUE on success. FALSE on failure |
PHP Version: |
5+ |
PHP MySQLi Reference
Color Picker