Connect MySQL Database using PHP

The MySQLi extension of PHP allows you to access MySQL database servers. It is designed to work with MySQL version 4.1 and above.

Installation & Runtime Configuration

The MySQLi extension was introduced with PHP version 5.0.0. The MySQL Native Driver was included in PHP version 5.3.0.

For installation details, go to: https://php.net/manual/en/mysqli.installation.php

For runtime configuration details, go to: https://php.net/manual/en/mysqli.configuration.php

mysqli_connect() function

To connect to the MySQL server, mysqli_connect() function can be used. The syntax for using this function is mentioned below:

//Object-oriented style
public mysqli::connect(hostname, username, password, 
                       database, port, socket)

//Procedural style
mysqli_connect(hostname, username, password, 
               database, port, socket)

Parameters

`hostname`	`Optional.` Specify the host name or an IP address. Passing the null value or "localhost" to this parameter, the local host is assumed.
`username`	`Optional.` Specify the MySQL user name.
`password`	`Optional.` Specify the MySQL password. This allows the username to be used with different permissions (depending on if a password is provided or not).
`database`	`Optional.` If provided will specify the default database to be used when performing queries.
`port`	`Optional.` Specify the port number to attempt to connect to the MySQL server.
`socket`	`Optional.` Specify the socket or named pipe that should be used.

Connect to MySQL Database - Object-oriented style

The example below demonstrates how to connect to the MySQL database using object-oriented style.

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDatabase";

//establishing connection 
$mysqli = new mysqli($servername, $username, $password, $dbname);

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

echo "Connected successfully.";

//closing the connection
$mysqli->close();
?>

The output of the above code will be:

Connected successfully.

Connect to MySQL Database - Procedural style

The same can be achieved using procedural style with following script:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDatabase";

//establishing connection 
$mysqli = mysqli_connect($servername, $username, $password, $dbname);

//checking connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: ". mysqli_connect_error();
  exit();
}

echo "Connected successfully.";

//closing the connection
mysqli_close($mysqli);
?>

The output of the above code will be:

Connected successfully.

Complete PHP MySQLi Reference

For a complete reference of all properties, methods and functions of PHP MySQLi extension, see PHP MySQLi Reference.

❮ PHP & MySQL