PHP MySQLi mysqli_connect() - Establishing a Connection

mysqli_connect()

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

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

// Establishing a connection
$connection = mysqli_connect($server, $username, $password, $database);

// Checking the connection
// NOTE: If all four parameters above are correct (server, username, 
// password, and database), the mysqli_connect_errno() function will return FALSE (0), 
// and the script will jump to the else block and output success. If you change 
// the password to something incorrect, you will immediately see the displayed error.
if (mysqli_connect_errno()) {
    echo "An error occurred:<br>" . mysqli_connect_error();
} else {
    echo "Connection to the MySQL database is successful.";
}

// Closing the connection
mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: For a successful connection, you need four pieces of information: server address, username, password, and database name. Test it at home like this:

Check if you have the MySQL module turned on in XAMPP.

Use mysqli_connect_error() to determine the reason if the connection fails.

Always close the connection with mysqli_close() when you are finished working.