Skip to content
PHP Logo

How can PHP developers securely access a centralized MySQL database from multiple websites without exposing sensitive information like access credentials?

To securely access a centralized MySQL database from multiple websites without exposing sensitive information like access credentials, developers can utilize environment variables to store database credentials outside of the codebase. By setting up environment variables on the server hosting the websites, developers can access these variables in their PHP scripts without directly exposing the credentials in the code.

php
// Set environment variables on the server hosting the websites
// Example: DB_HOST, DB_USER, DB_PASS, DB_NAME

// Access environment variables in PHP script
$host = getenv('DB_HOST');
$username = getenv('DB_USER');
$password = getenv('DB_PASS');
$database = getenv('DB_NAME');

// Connect to the MySQL database securely
$mysqli = new mysqli($host, $username, $password, $database);

// Perform database operations using $mysqli