\n"; // Create the session file and store username and password as session // variables. session_start(); $_SESSION["username"] = $username; $_SESSION["password"] = $password; // Dump out info about the database that users can do selects on. echo "

\nTables: Student, Transcript, Users.
\n"; echo "Attributes of Student: Id, Name, Address, Status.
\n"; echo "Attributes of Transcript: StuId, CrsCode, Semester, Grade.
\n"; echo "Attributes of Users: Username, Password.
\n"; // Form to allow users to pose queries. Note how SID is passed as a // GET parameter. echo "

\n"; echo "SQL query: 
\n"; echo "\n"; echo "
\n"; } else echo "Not authenticated.
\n"; pg_freeresult($result); pg_close($db_h); ?>