Latest web development tutorials
 

PHP mysqli_connect() Function

< PHP MySQLi Reference

Example

Open a new connection to the MySQL server:

<?php
$con = mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?>

Definition and Usage

The mysqli_connect() function opens a new connection to the MySQL server.


Syntax

mysqli_connect(host,username,password,dbname,port,socket);

Parameter Description
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

Technical Details

Return Value: Returns an object representing the connection to the MySQL server
PHP Version: 5+

< PHP MySQLi Reference