Field Notes Archive

Section Field Notes

<?php $host = '82.165.6.246'; $dbname = 'pg25_236772'; $user = 'pg25connorodell'; $password = 'pgco_287017';

Article Overview

Structured Notes

Section 1

<?php $host = '82.165.6.246'; $dbname = 'pg25_236772'; $user = 'pg25connorodell'; $password = 'pgco_287017';

Section 2

if (!$pgCon) { die("Connection failed: " . pg_last_error()); }

// Drop & recreate schema pg_query($pgCon, "DROP SCHEMA IF EXISTS jakeygym CASCADE;"); pg_query($pgCon, "CREATE SCHEMA jakeygym;");

Section 3

// Drop table pg_query($pgCon, "DROP TABLE IF EXISTS jakeygym.usertable;");

// Create table with proper column definitions pg_query($pgCon, " CREATE TABLE jakeygym.usertable ( userid SERIAL PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE, hashedpassword TEXT NOT NULL ); ");