• PHP Video Tutorials

PHP mysqli_real_connect() Function

Definition and Usage

The mysqli_real_connect() function establishes a connection with MySQL server and returns the connection as an object. The difference between the mysql_connect() function and this is that it accepts an object created by the mysqli_real_connect() needs a valid object which has to be created by function mysqli_init() function and, you can set additional options to a connection using the mysqli_options() function.

Syntax

mysqli_real_connect($con,[$host, $username, $passwd, $dname, $port, $socket, $flags] )

Parameters

Sr.No Parameter & Description
1

con(Optional)

This is an object representing a connection to MySQL Server.
2

host(Optional)

This represents a host name or an IP address. If you pass Null or localhost as a value to this parameter, the local host is considered as host.
3

username(Optional)

This represents a user name in MySQL.
4

passwd(Optional)

This is represents the password to the given user.
5

dname(Optional)

This represents the default database in which the queries should be performed.
6

port(Optional)

This represents the port number at which you want to establish a connection to MySQL Server.
7

socket(Optional)

This represents the socket that is to be used.
8

flags(Optional)

An integer value representing different connection options this can be one of the following constants −

  • MYSQLI_CLIENT_COMPRESS

  • MYSQLI_CLIENT_FOUND_ROWS

  • MYSQLI_CLIENT_IGNORE_SPACE

  • MYSQLI_CLIENT_INTERACTIVE

  • MYSQLI_CLIENT_SSL

  • MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT

Return Values

This function returns the boolean value which is true if the connection was successful and false incase of failure.

PHP Version

This function was first introduced in PHP Version 5 and works works in all the later versions.

Example

Following example demonstrates the usage of the mysqli_real_connect() function (in procedural style) −

<?php
   $db = mysqli_init();
   //Creating the connection
   $con = mysqli_real_connect($db, "localhost","root","password","test");
   if($con){
      print("Connection Established Successfully");
   }else{
      print("Connection Failed ");
   }
?>

This will produce following result −

Connection Established Successfully

Example

In object oriented style the syntax of this function is $con-> real_connect(); Following is the example of this function in object oriented style $minus;

<?php
   $db = mysqli_init();
   //Connecting to the database
   $con = $db->real_connect("localhost","root","password","test");

   if($con){
      print("Connection Established Successfully");
   }else{
      print("Connection Failed ");
   }
?>

This will produce following result −

Connection Established Successfully

Example

<?php
   $connection_mysql = mysqli_init();
   
   if (!$connection_mysql){
      die("mysqli_init failed");
   }
   
   if (!mysqli_real_connect($connection_mysql,"localhost","root","password","mydb")){
      die("Connect Error: " . mysqli_connect_error());
   }else{
	  echo "Connection was successful";
   }
   mysqli_close($connection_mysql);
?>

This will produce following result −

Connection was successful
php_function_reference.htm
Advertisements