Latest web development tutorials
 

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