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 report_exception($title, $exception)
{
echo report_exception_title($title);
echo report_name_value("Code", $exception->getCode());
echo report_name_value("Message", $exception->getMessage());
echo report_name_value("File", $exception->getFile());
echo report_name_value("Line", $exception->getLine());
}
function report_database_settings($dbInfo)
{
$server = $dbInfo->getServer();
$user = $dbInfo->getUser();
$password = $dbInfo->getPassword();
$database = $dbInfo->getDatabase();
echo report_name_value("MySQL Server", $server);
echo report_name_value("MySQL User", $user);
echo report_name_value("MySQL Password", $password);
echo report_name_value("MySQL Database", $database);
}
