PHP mysqli connect() Function

Example - Object Oriented style

Open a new connection to the MySQL server:

<?php
$mysqli = new mysqli("localhost","my_user","my_password","my_db");

// Check connection
if ($mysqli -> connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
exit();
}
?>

Look at example of procedural style at the bottom.

Definition and Usage

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

Syntax

Object oriented style:

$mysqli -> new mysqli(host, username, password, dbname, port, socket)

Procedural style:

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

Parameter Values

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+

Example - Procedural style

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();
exit();
}
?>

❮ PHP MySQLi Reference