function registerX($email, $password, $first_name, $last_name) { // Register new person with db // Return true or error message // Connect to db $dbinfo = initialize_db_info(); //report_database_settings($dbinfo); try { $db_link = db_connect($dbinfo); db_select($db_link, $dbinfo); } catch (Exception $e) { echo report_exception("Database Connection", $e); echo report_database_settings($dbinfo); } // Check if username is unique $uniqueSql = "select * from login where email='" . $email . "'"; echo report_name_value("uniqueSql", $uniqueSql); $result_rows = mysql_query($uniqueSql, $db_link); if (!$result_rows) { throw new Exception('Could not execute query'); } $numberOfRows = mysql_num_rows($result_rows); if ($numberOfRows > 0) { throw new Exception('That email is taken - go back and choose another one.'); } $insert_sql = generateUserInsertSql($email, $password, $first_name, $last_name); $result_rows = mysql_query($insert_sql, $db_link); if (!$result_rows) { throw new Exception('Could not register you in database - please try again later. (' . $insert_sql . ')'); } return true; }
function display_duck_blinds() { $dbinfo = initialize_db_info(); #report_database_settings($dbinfo); try { $db_link = db_connect($dbinfo); db_select($db_link, $dbinfo); } catch (Exception $e) { echo report_exception("Database Connection", $e); echo report_database_settings($dbinfo); } $sql = generate_blind_list_sql(); $result_rows = mysql_query($sql, $db_link); if (!$result_rows) { echo $sql; $message = 'Invalid query: ' . mysql_error() . "\n"; echo $message; throw new Exception('No Results.'); } echo '<table>'; while ($row = mysql_fetch_array($result_rows, MYSQL_ASSOC)) { //echo generate_blind_row($row); } echo '</table>'; }
<html> <head> <title>Blind List</title> </head> <body> <?php $dbinfo = initialize_db_info(); //report_database_settings($dbinfo); try { $db_link = db_connect($dbinfo); db_select($db_link, $dbinfo); } catch (Exception $e) { echo report_exception("Database Connection", $e); echo report_database_settings($dbinfo); } $sql = generate_blind_list_sql(); $result_rows = mysql_query($sql, $db_link); if (!$result_rows) { echo $sql; $message = 'Invalid query: ' . mysql_error() . "\n"; echo $message; throw new Exception('No Results.'); } ?> <h1>Blind List</h1> <!--