Discord Notification for checking MySQL alive with PHP

Monitor Database Status and Send to Discord via Cronjob

You can register a simple script as a Cronjob to regularly check the database status and send the result to Discord.

<?php
// Create connection

$con = mysqli_connect("localhost", "database_user_name", "database_user_password", "database_name");

// Check connection
if ( !mysqli_connect_errno() ) {
    $message = "Database works";
} else {
    $message = "Database is not working";
}

// Discord Webhook

$webhook_url = 'https://discordapp.com/api/webhooks/xxxyyyzzz...';
$payload     = json_encode( ['content' => $message] );

$ch = curl_init($webhook_url);
curl_setopt( $ch, CURLOPT_POSTFIELDS, $payload );
curl_setopt( $ch, CURLOPT_HTTPHEADER, array('Content-Type:application/json'));
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true );
$result = curl_exec($ch);
curl_close($ch);

Register a Cron Job to Send Discord Alerts Every 5 Minutes

*/5 * * * * /usr/bin/php /path/to/a-server-db-monitor.php

With this setup, you can receive regular updates on your server status via Discord.