PDO::ERRMODE_EXCEPTION]; try { $pdo = new PDO($dsn, $user, $pass, $options); } catch (PDOException $e) { die("Database connection failed: " . $e->getMessage()); } // ---------------- Helper Functions ---------------- function getUserById($pdo, $id) { $stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([$id]); return $stmt->fetch(PDO::FETCH_ASSOC); } function addTransaction($pdo, $user_id, $type, $amount, $description) { $stmt = $pdo->prepare("INSERT INTO transactions (user_id, type, amount, description) VALUES (?, ?, ?, ?)"); $stmt->execute([$user_id, $type, $amount, $description]); } // ---------------- Authentication ---------------- if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (isset($_POST['register'])) { $username = $_POST['username']; $email = $_POST['email']; $password = password_hash($_POST['password...
Comments
Post a Comment