setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Query to check member credentials $stmt = $pdo->prepare("SELECT ID, formno, firstName, Surname, fullname, password, email, mobile FROM member WHERE formno = :formno"); $stmt->execute([':formno' => $membership_no]); $member = $stmt->fetch(PDO::FETCH_ASSOC); if ($member && password_verify($password, $member['password'])) { // Login successful $_SESSION['member_id'] = $member['ID']; $_SESSION['member_no'] = $member['formno']; $_SESSION['member_name'] = $member['fullname'] ?: $member['firstName'] . ' ' . $member['Surname']; $_SESSION['member_email'] = $member['email']; // Redirect to dashboard header("Location: member_dashboard.php"); exit(); } else { $error = "Invalid Membership Number or Password"; } } catch (PDOException $e) { $error = "Database error. Please try again later."; error_log("Login Error: " . $e->getMessage()); } } } ?>