PHP: Connecting PHP to MySQL using credentials from environment variables

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 ready-to-use PHP cloud solution that provides a host of benefits, including:

• Deploy your application in seconds with a simple git push.
• Use your own domain name and benefit from the automatic configuration of HTTPS certificates for enhanced security.
• Enjoy peace of mind with automatic backups, one-click updates, and straightforward, transparent, and predictable pricing.
• Get optimal performance and robust security thanks to a private and dedicated VM.

Save time and simplify your life: it only takes 5 minutes to try Stackhero's PHP cloud hosting solution!

For enhanced security and easier configuration management, it is recommended that you avoid hardcoding your credentials in your source code. Instead, retrieve these settings from environment variables as shown below:

<?php

$hostname = getenv('STACKHERO_MYSQL_HOST');
$user = getenv('STACKHERO_MYSQL_USER');
$password = getenv('STACKHERO_MYSQL_PASSWORD');
$database = getenv('STACKHERO_MYSQL_USER'); // By convention, the database name matches the username

?>

Using environment variables helps maintain the security of your credentials and makes your configuration more adaptable across different environments.