getConnection();
// Check if username already exists
$query = "SELECT id FROM users WHERE username = :username LIMIT 1";
$stmt = $db->prepare($query);
$stmt->bindParam(":username", $username);
$stmt->execute();
if ($stmt->rowCount() > 0) {
$error_msg = __('username_exists');
} else {
// Check if email already exists
$query = "SELECT id FROM users WHERE email = :email LIMIT 1";
$stmt = $db->prepare($query);
$stmt->bindParam(":email", $email);
$stmt->execute();
if ($stmt->rowCount() > 0) {
$error_msg = __('email_exists');
} else {
// Create user object
$user = new User($db);
$user->username = $username;
$user->email = $email;
$user->password = $password;
// Register user
if ($user->register()) {
$success_msg = __('registration_success');
// Clear form data
$username = "";
$email = "";
} else {
$error_msg = "Unable to register. Please try again.";
}
}
}
} catch (Exception $e) {
$error_msg = "An error occurred: " . $e->getMessage();
}
}
}
?>
<?php echo __('register') . ' - ' . __('climbing_journal'); ?>