enru/dsnfromenv

dsnfromenv

Parses a database URL from the environment into a DSN connection string for use in PHP's PDO., _(*1)

Useful for parsing heroku config DATABASE_URL variable., _(*2)

e.g., _(*3)

A database URL set in an environment variable:, _(*4)

export DATABASE_URL=postgres://USER:PASS@HOST:PORT/DBNAME

...can be parsed into this string:, _(*5)

'pgsql:host=HOST;port=PORT;user=USER;dbname=DBNAME;password=PASSWORD'

...using this code:, _(*6)

<?php

$dsn = new enru\DsnFromEnv();
$dsn_string = $dsn->parse();

A database connection can then easily be made:, _(*7)

<?php

try {
    $dsn = new enru\DsnFromEnv();
    $dbh = new PDO($dsn->parse());
}   
catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}