PHP mysqli_real_connect() Function
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:
|
Technical Details
Return Value: | TRUE on success. FALSE on failure |
---|---|
PHP Version: | 5+ |
PHP MySQLi Reference