<?php
session_start();
include 'db_connect.php';  // Include the database connection

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $password = $_POST['password'];

    // Check the database for the user
    $stmt = $pdo->prepare("SELECT * FROM users WHERE username = ?");
    $stmt->execute([$username]);
    $user = $stmt->fetch();

    // Verify password and set session if successful
    if ($user && password_verify($password, $user['password'])) {
        $_SESSION['user_id'] = $user['id'];   // Store user ID in session
        $_SESSION['role'] = $user['role'];    // Store user role in session
        header('Location: dashboard.php');    // Redirect to dashboard
    } else {
        echo "Invalid login credentials.";
    }
}
?>