PHP: Connecting PHP to MySQL with MySQLi (procedural style)

This documentation is part of the Connect to MySQL guide. You can view the complete guide here: Learn how to connect to MySQL from PHP using MySQLi and PDO.

👋 Welcome to the Stackhero documentation!

Stackhero offers a PHP cloud solution designed for fast, reliable deployments:

• Deploy your PHP application to production in seconds with a simple git push.
• Use your own domain, with automatic HTTPS certificates configured for you—no manual steps required.
• Take advantage of automatic backups, one-click updates, and straightforward, predictable pricing. Stackhero manages these aspects so you can focus on your code.
• Enjoy strong performance and enhanced security on a private, dedicated VM built specifically for your applications.

Save time and streamline your workflow—getting started with Stackhero's PHP cloud hosting takes just a few minutes.

If you prefer a procedural approach, the example below shows how to establish a connection using MySQLi in a procedural style. As always, using a dedicated database and a restricted user is recommended for enhanced security.

<?php

$hostname = '<XXXXXX>.stackhero-network.com';
$user = 'root';
$password = '<yourPassword>';
$database = 'root'; // For enhanced security, create a dedicated database and user in phpMyAdmin

$mysqli = mysqli_init();
$mysqliConnected = mysqli_real_connect($mysqli, $hostname, $user, $password, $database, NULL, NULL, MYSQLI_CLIENT_SSL);
if (!$mysqliConnected) {
  die('Connection error: ' . mysqli_connect_error($mysqli));
}

echo 'Success: ' . mysqli_get_host_info($mysqli) . "\n";

mysqli_close($mysqli);

?>