Script that I use for testing sql connections

db_tester.php

<?php
	$TIMEOUT = 5; # in seconds

	# cli args
	# array_shift($argv);
    	# [$HOST, $DATABASE, $USER, $PASSWORD] = $argv;

	# http GET query
	# [$HOST, $DATABASE, $USER, $PASSWORD] = $_GET;

	# Hardcode
	$HOST 		= "1.1.1.1";
	$DATABASE 	= "dbname";
	$USER 		= "username";
	$PASSWORD 	= "supersecret";

	try {
		$db = new PDO(
			`mysql:host={$HOST};dbname={$DATABASE};charset=utf8`,
			$USER,
			$PASSWORD,
		    Array(
		        PDO::ATTR_TIMEOUT => $TIMEOUT,
		        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
		    )
		);
	} catch (PDOException $e) {
		http_response_code(500);
		die(`cant connect to db.\n ${$e->getMessage()}\n`);
	} finally {
		http_response_code(200);
		die("success\n");

		$smt = $db->query("SELECT table_name FROM information_schema.tables;");
		print_r($smt->fetchAll(PDO::FETCH_COLUMN));
	}
?>