dbstatus.php

<?php

require 'vendor/autoload.php';

Dotenv::load($_SERVER['DOCUMENT_ROOT'].'/../');

Dotenv::required(array(
  'MYSQL_HOSTNAME',
  'MYSQL_USERNAME',
  'MYSQL_DATABASE',
));

$server    = getenv('MYSQL_HOSTNAME');
$username  = getenv('MYSQL_USERNAME');
$password  = getenv('MYSQL_PASSWORD');
$database  = getenv('MYSQL_DATABASE');

try {
  $dbh = new PDO("mysql:host=$server;dbname=$database", $username, $password);
  foreach($dbh->query('SELECT * from sample') as $row) {
    print_r($row);
  }
  $dbh = null;
} catch (PDOException $e) {
  print "Error!: " . $e->getMessage() . "<br/>";
}