hoangdangninh
6/30/2017 - 6:48 AM

check database connection from laravel console

check database connection from laravel console

# 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")