";
#Check user access to the database
$connstr = "dbname=cur_pr1 user=vfong password=gonfv host=iron";
$dbh = pg_connect ($connstr);
if (!$dbh){
echo "Cannot connect to database";
exit;
}
echo "";
# Select protein info from the database
$sql = "select l.orf_name, l.std_name, l.sgd_description from cur_locus l order by 2";
$qstat = pg_exec($dbh, $sql);
if($qstat){
echo "| Back | ORF Name | Gene | Fasta Description | \n";
$rows = pg_numrows($qstat);
for($i = 0; $i < $rows; $i++){
$data = pg_fetch_row($qstat, $i);
echo "| <<< | $data[0] |
$data[1] | $data[2] |
";
}
}
echo "