\n"; echo "

Graduate Guestbook

\n"; echo "

"; else { $newoffset = $offset - $entries; if($newoffset < 0) $newoffset = 0; if($order != "") { echo "" ."Previous ".$entries." Entries"; } else { echo "Previous ".$entries." Entries"; } } echo ""; echo ""; echo ""; echo ""; } else { echo "Next ".$entries." Entries"; } echo "

"; if($offset == 0) echo "

Entries ".$offset." to ".($offset+$entries)."

"; $newoffset = $offset + $entries; if($order != "") { echo "" ."Next ".$entries." Entries

\n"; echo "

\n"; $db = DB::connect($dbtype."://www-data@unix+localhost/".$dbname); if(DB::isError($db)) { echo "

\n"; echo "

Whoops, I couldn't find the guestbook database!

\n"; echo "

Please report the above error and the following data to"; echo " merlin@math.lsu.edu:

Failed connecting to ".$dbtype." database ".$dbname."\n"; echo "

Error: ".DB::errorMessage($db)."

Please press the Back button on your browser to return to the guestbook\n"; echo "

\n"; exit; } if($order != "") // General browse { $selectstring = "SELECT * FROM guestbook ORDER BY ".$order; if($order == gradyear) $selectstring .= " DESC"; $result = $db->query($selectstring); if(DB::isError($result)) { gberror("database failure while browsing guestbook","",$result); exithtml(); } if($result->numRows() == 0) { echo "

No entries found!

You may press the back button on your browser to return to" ." the guestbook, or click here to return to" ." the main graduate studies page.

\n"; exithtml(); } // echo "

Browsing by: ".$order."

\n"; $position = 0; while($data = $result->fetchrow(DB_FETCHMODE_ASSOC)) { $position = showentry($db, $data, $position, $offset, $entries); } } // if($order != "") // General browse else { $querystring = "SELECT * FROM guestbook"; $firstsearchterm = true; $order1 = "lastname"; $order2 = "firstname"; if($lastname != "") { $querystring .= " WHERE lastname ~* '".$lastname."'"; $firstsearchterm = false; } if($firstname != "") { if($firstsearchterm) { $querystring .= " WHERE firstname ~* '".$firstname."'"; $firstsearchterm = false; $order1 = "firstname"; $order2 = "lastname"; } else { $querystring .= " AND firstname ~* '".$firstname."'"; } } if($gradyear != "") { if($firstsearchterm) { $querystring .= " WHERE gradyear = ".$gradyear; } else { $querystring .= " AND gradyear = ".$gradyear; } } $querystring .= " ORDER BY ".$order1.",".$order2.",gradyear DESC;\n"; $result = $db->query($querystring); if(DB::isError($result)) { gberror("database failure while searching guestbook","",$result); exithtml(); } if($result->numRows() == 0) { echo "

No entries found!

You may press the back button on your browser to return to" ." the guestbook, or click here to return to" ." the main graduate studies page.

"; exithtml(); } $position = 0; while($data = $result->fetchrow(DB_FETCHMODE_ASSOC)) { $position = showentry($db, $data, $position, $offset, $entries); } } function showentry($db, $data, $position, $offset, $entries) { if( ($position >= $offset) && ($position < ($offset+$entries)) ) { $ms = sqltobool($data["ms"]); $phd = sqltobool($data["phd"]); echo "

".$data["firstname"]." ".$data["lastname"]." ("; if($ms) { echo "M.S., "; } if($phd) { echo "Ph.D., "; } echo $data["gradyear"].")

Advisor: ".$data["advisor"]."

E-mail Address: ".$data["email"]."

".$data["publicinfo"]."

" .$picdata["description"]."

\n"; } return $position + 1; } ?>