In this article, we will discuss the mysqli_real_connect() function in PHP, which is used to establish a connection to a MySQL database.

Introduction to the mysqli_real_connect() function

The mysqli_real_connect() function is a built-in function in PHP that is used to establish a connection to a MySQL database. This function is similar to the mysqli_connect() function, but it provides more control over the connection process.

How to use the mysqli_real_connect() function

Using the mysqli_real_connect() function is straightforward. Here's an example:

$mysqli = mysqli_init();

if (!$mysqli) {
    die('mysqli_init failed');

if (!$mysqli->real_connect('localhost', 'username', 'password', 'database')) {
    die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);

echo 'Success... ' . $mysqli->host_info . "\n";


In this example, we first create a new MySQLi object using the mysqli_init() function. We then check if the object was created successfully using an if statement. If the object was created successfully, we use the mysqli_real_connect() function to establish a connection to the MySQL database. If the connection fails, we output an error message using the die() function. If the connection is successful, we output a success message using the echo statement. Finally, we close the connection using the close() method.


In conclusion, the mysqli_real_connect() function is an essential tool for establishing a connection to a MySQL database in PHP. By understanding how to use the function, you can connect to a database and begin working with data, executing queries, and retrieving result sets.

Practice Your Knowledge

What can be done with the mysqli_real_connect() function in PHP?

Quiz Time: Test Your Skills!

Ready to challenge what you've learned? Dive into our interactive quizzes for a deeper understanding and a fun way to reinforce your knowledge.

Do you find this helpful?