<?php

error_reporting(E_ALL);

echo "Hello!";

$dsn = "postgresql:host=db.doc.ic.ac.uk;port=5432;dbname=g1027121";
$user = "g1027121_u";
$password = "password";

$link = new PDO($dsn,$user,$password);

$stmt = $link -> prepare ("INSERT INTO cities (city_name, location_x, location_y) VALUES ('London', 0, 0);");
echo "Prepared!";
$stmt -> execute();
echo "Executed!";
var_dump($stmt -> fetchAll());
$stmt -> closeCursor();

?>