<?php
   $host        = "host=127.0.0.1";
   $port        = "port=5432";
   $dbname      = "dbname=accounting1";
   $credentials = "user=websqluser password=Lollipop123";

   $db = pg_connect( "$host $port $dbname $credentials"  );
   if(!$db){
      echo "Error : Unable to open database\n";
   } else {
      echo "Opened database successfully\n";
   }

   $sql =   INSERT INTO users ('firstName','lastName','userName','password','email','loggedIn','activated') VALUES ('Tim','Leonard','timmy','password','tim@timmy.com',0,0);


   $ret = pg_query($db, $sql);
   if(!$ret){
      echo pg_last_error($db);
   } else {
      echo "Values inserted\n";
   }
   pg_close($db);
?>