0) { header("Location: login.php"); exit(); } $theme = "light"; if (isset($_COOKIE['theme'])) { $theme = $_COOKIE['theme']; } $currencies = array(); $query = "SELECT * FROM currencies"; $result = $db->query($query); while ($row = $result->fetchArray(SQLITE3_ASSOC)) { $currencyId = $row['id']; $currencies[$currencyId] = $row; } $passwordMismatch = false; $registrationFailed = false; if (isset($_POST['username'])) { $username = validate($_POST['username']); $email = validate($_POST['email']); $password = $_POST['password']; $confirm_password = $_POST['confirm_password']; $main_currency = $_POST['main_currency']; $language = $_POST['language']; $avatar = "0"; if ($password != $confirm_password) { $passwordMismatch = true; } else { $query = "INSERT INTO user (username, email, password, main_currency, avatar, language) VALUES (:username, :email, :password, :main_currency, :avatar, :language)"; $stmt = $db->prepare($query); $hashedPassword = password_hash($password, PASSWORD_DEFAULT); $stmt->bindValue(':username', $username, SQLITE3_TEXT); $stmt->bindValue(':email', $email, SQLITE3_TEXT); $stmt->bindValue(':password', $hashedPassword, SQLITE3_TEXT); $stmt->bindValue(':main_currency', $main_currency, SQLITE3_TEXT); $stmt->bindValue(':avatar', $avatar, SQLITE3_TEXT); $stmt->bindValue(':language', $language, SQLITE3_TEXT); $result = $stmt->execute(); if ($result) { $deleteQuery = "DELETE FROM household"; $stmtDelete = $db->prepare($deleteQuery); $stmtDelete->execute(); $deleteQuery = "DELETE FROM subscriptions"; $stmtDelete = $db->prepare($deleteQuery); $stmtDelete->execute(); $deleteQuery = "DELETE FROM fixer"; $stmtDelete = $db->prepare($deleteQuery); $stmtDelete->execute(); $query = "INSERT INTO household (name) VALUES (:name)"; $stmt = $db->prepare($query); $stmt->bindValue(':name', $username, SQLITE3_TEXT); $stmt->execute(); $db->close(); header("Location: login.php"); exit(); } else { $registrationFailed = true; } } } ?> Wallos - Subscription Tracker >
Wallos Logo Wallos Logo