<?php
ini_set ("display_errors", "1");

error_reporting(E_ALL);
$con="host=127.0.0.1 port=5432 dbname=website_db user=cake password=cake";
$db=pg_connect($con) or die('connection failed');
echo '<p>Connected to: ', pg_dbname($db).'</p>';

$result = pg_query($db, "SELECT id, name FROM public.roles");
if (!$result) {
  echo "<p>An error occurred: ".pg_last_error()."</p>.\n";
  exit;
}

while ($row = pg_fetch_row($result)) {
  echo "ID: $row[0]  Name: $row[1]";
  echo "<br />\n";
}
?>