check database connection from laravel console
heroku run php artisan tinker
DB::connection()->getPdo();
# connect to clear db in heroku
# NOTE: cleardb is A HEROKU SERVICE, NOT AWS !!!!!!!!
<?php
$url = parse_url(getenv("CLEARDB_DATABASE_URL"));
$server = $url["host"];
$username = $url["user"];
$password = $url["pass"];
$db = substr($url["path"], 1);
$conn = new mysqli($server, $username, $password, $db);
?>
# try to create a table
$sql = "CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);"
# try to query that table
$conn->query("select * from Persons")