function register($email, $password, $first_name, $last_name)
{
// register new person with db
// return true or error message
// Connect to db
$dbInfo = initialize_db_info();
$dbLink = db_connect($dbInfo);
db_select($dbLink, $dbInfo);
// Check if username is unique
$uniqueUserNameSQL = "select * from login where email='" . $email . "'";
$result = mysql_query($uniqueUserNameSQL, $dbLink);
$numRows = mysql_num_rows($result);
if (!$result) {
show_db_error("Could not execute query", $uniqueUserNameSQL);
}
if ($numRows > 0) {
throw new Exception('That email is taken - go back and choose another one.');
}
// if ok, put in db
//$result = $conn->query("insert into login (email, password) values
// ('".$email."', sha1('".$password."')");
//
//$result = $conn->query("insert into login (email, password) values
// ('".$email."', sha1('".$password."'))");
$insert_sql = generateUserInsertSql($email, $password, $first_name, $last_name);
$result = mysql_query($insert_sql);
if (!$result) {
throw new Exception('Could not register you in database - please try again later. (' . $insert_sql . ')');
}
return true;
}
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;
}
