prepare("SELECT * FROM users WHERE email = ? AND role = ?"); $stmt->execute([$email, $role]); $user = $stmt->fetch(); if ($user && password_verify($password, $user['password'])) { // Password is correct, set session variables $_SESSION['user_id'] = $user['id']; $_SESSION['user_role'] = $user['role']; $_SESSION['user_email'] = $user['email']; $_SESSION['user_full_name'] = $user['full_name']; // Redirect to the respective dashboard header('Location: ' . $user['role'] . '_dashboard.php'); exit; } else { $error_message = 'Invalid email, password, or role.'; } } catch (PDOException $e) { $error_message = 'Database error: ' . $e->getMessage(); } } } require_once __DIR__ . '/includes/header.php'; ?>

School Leave System