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);?>The mysqli_real_connect() function opens a new connection to the MySQL server.
The mysqli_real_connect() function differs from the mysqli_connect() function in the following aspects:
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.
mysqli_real_connect( connection,host,username,password,dbname,port,socket,flag ) ;
| parameter | describe |
|---|---|
| connection | Required. Specifies the MySQL connection to use. |
| host | Optional. Specify the hostname or IP address. |
| username | Optional. Specifies the MySQL username. |
| password | Optional. Specifies the MySQL password. |
| dbname | Optional. Specifies the default database to use. |
| port | Optional. Specifies the port number to attempt to connect to the MySQL server. |
| socket | Optional. Specifies the socket or named pipe to use. |
| flag | Optional. Specifies different connection options. Possible values: MYSQLI_CLIENT_COMPRESS - Use compression protocol MYSQLI_CLIENT_FOUND_ROWS - Returns the number of matching rows (not the number of affected rows) MYSQLI_CLIENT_IGNORE_SPACE - Allow spaces after function names, making function names reserved MYSQLI_CLIENT_INTERACTIVE - allow interactive_timeout seconds of inactivity before closing the connection MYSQLI_CLIENT_SSL - Use SSL encryption |
| Return value: | Returns TRUE if successful and FALSE if failed. |
|---|---|
| PHP version: | 5+ |