<?php
ob_start();

// Database credentials
$host = 'localhost';
$user = '';  // your DB username
$pass = '';  // your DB password
$db   = '';  // your database name

$conn = new mysqli($host, $user, $pass, $db);

if ($conn->connect_error) {
    http_response_code(500);
    echo "Database connection failed: " . $conn->connect_error . "\n";
    ob_end_flush();
    exit;
}

echo "Apache is up and running.\n";

$query = "SELECT 1 FROM DUAL";
$result = $conn->query($query);
if ($result) {
    echo "Database is up and running.\n";
    $result->free();
} else {
    http_response_code(500);
    echo "Error executing query: " . $conn->error . "\n";
}

$query = "SHOW GLOBAL STATUS LIKE 'Uptime'";
$result = $conn->query($query);
if ($result) {
    $row = $result->fetch_assoc();
    $uptime_seconds = (int)$row['Value'];

    $days    = floor($uptime_seconds / 86400);
    $hours   = floor(($uptime_seconds % 86400) / 3600);
    $minutes = floor(($uptime_seconds % 3600) / 60);
    $seconds = $uptime_seconds % 60;

    echo "MySQL Uptime: {$days} days, {$hours} hours, {$minutes} minutes, {$seconds} seconds\n";

    if ($uptime_seconds < 86400) {
        echo "Warning: MySQL uptime is less than 1 day!\n";
    }

    $result->free();
} else {
    echo "Error retrieving MySQL uptime: " . $conn->error . "\n";
}

echo "Server Time: " . date('Y-m-d H:i:s') . "\n";

$conn->close();
ob_end_flush();
?>