PHP: Connecting PHP to MySQL with MySQLi (object-oriented style)

This documentation is part of the Connect to MySQL guide. View the full guide here: Learn how to connect to MySQL from PHP using MySQLi and PDO.

👋 Welcome to the Stackhero documentation!

Stackhero provides a PHP cloud platform 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. There are no manual steps needed.
• Rely on automatic backups, one-click updates, and clear, predictable pricing. Stackhero handles these details, so you can focus on your code.
• Benefit from strong performance and security on a private, dedicated infrastructure built specifically for your applications.

Make your workflow smoother and save time. Getting started with Stackhero's PHP cloud hosting takes just a few minutes.

The following example demonstrates how to connect PHP to MySQL using MySQLi in an object-oriented style. It is best practice to create a dedicated database and user for your application rather than using the 'root' account. This approach improves your application's security.

<?php

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

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

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

$mysqli->close();

?>