> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ahmadraza.in/llms.txt
> Use this file to discover all available pages before exploring further.

# Db healthcheck.php

## PHP MySQL Connection Script for Health Check

This PHP script demonstrates how to connect to a MySQL database using the `mysqli` extension.

### 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

```php theme={null}
$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

```php theme={null}
$conn = new mysqli($hostname, $username, $password, $database);
```

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

#### Step 3: Check Connection

```php theme={null}
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 theme={null}
<?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.