Db healthcheck.php

​

PHP MySQL Connection Script for Health Check

​

Prerequisites

• Ensure you have PHP installed on your server.
• Ensure you have MySQL installed and a database created.

​

Script Breakdown

​

Step 1: Define Database Connection Parameters

$hostname = 'localhost';
$username = 'your_db_username';
$password = 'your_db_password';
$database = 'your_db_name';

• $hostname: The hostname of your MySQL server, typically ‘localhost’.
• $username: The username to access the MySQL database.
• $password: The password associated with the username.
• $database: The name of the database you want to connect to.

​

Step 2: Establish Database Connection

$conn = new mysqli($hostname, $username, $password, $database);

• $conn: This variable holds the connection object returned by new mysqli() function.

​

Step 3: Check Connection

if ($conn->connect_error) {
    die('Connection failed: ' . $conn->connect_error);
}
echo 'Connected successfully';

• $conn->connect_error: This property checks if there was an error connecting to the database.
• die(): If there is a connection error, this function stops the script execution and outputs the error message.
• echo ‘Connected successfully’: If the connection is successful, this message will be displayed.

​

Complete Script

<?php
$hostname = 'localhost';
$username = 'your_db_username';
$password = 'your_db_password';
$database = 'your_db_name';

$conn = new mysqli($hostname, $username, $password, $database);

if ($conn->connect_error) {
    die('Connection failed: ' . $conn->connect_error);
}
echo 'Connected successfully';
?>

​

How to Use

1. Replace the placeholder values:
   • your_db_username with your actual database username.
   • your_db_password with your actual database password.
   • your_db_name with the name of your database.
2. Save the script as a .php file (e.g., db_connect.php).
3. Upload the script to your PHP server.
4. Access the script via a web browser (e.g., http://yourserver.com/db_connect.php).

If the connection is successful, you will see the message “Connected successfully.” If there is an error, the message “Connection failed: ” followed by the error details will be displayed.