How to Connect to a MySQL Database Using mysqli in PHP?

Connecting to MySQL Using mysqli in PHP

In PHP, the mysqli extension provides a convenient way to connect to MySQL databases. However, certain issues can arise during the connection process, as encountered in the case described.

The original code attempts to connect without specifying the server name, which results in the "Failed to connect to MySQL" error. To resolve this, the server name must be explicitly specified, typically as "localhost" for local connections or the hostname or IP address of the remote MySQL server.

One example of a corrected connection code using mysqli_connect() is:

$con = mysqli_connect("localhost", "username", "password", "databasename");

Alternatively, the mysqli_connect_errno() and mysqli_connect_error() functions can be utilized to provide more detailed information about the error.

For a more structured approach, MySQLi procedural style can be employed:

$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$con = mysqli_connect($servername, $username, $password);

// Check connection
if (!$con) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

Finally, it's important to note that the database username and password should be replaced with the appropriate credentials.

The above is the detailed content of How to Connect to a MySQL Database Using mysqli in PHP?. For more information, please follow other related articles on the PHP Chinese website!