Example for the #DevBurgos talk about Heroku

ExampleWithDB.php

<?php
# function that reads DATABASE_URL env var and returns a connection
function pg_connection_string_from_database_url() {
  extract(parse_url($_ENV["DATABASE_URL"]));
  return "user=$user password=$pass host=$host dbname=" . substr($path, 1);
}
 
print "<h1>hello #DevBurgos</h1>";

# Establish the connection.
$pg_conn = pg_connect(pg_connection_string_from_database_url());
 
# silly query
$result = pg_query($pg_conn, "SELECT now()");

#print the result if has any
if (pg_num_rows($result)) {
  print "\nObtained from DB:";
  $row = pg_fetch_row($result);
  print("- $row[0]"); 
}

?>

Prodfile

web: vendor/bin/heroku-php-nginx

Useful command heroku addons:add heroku-postgresql