prepare($sql);
$stmt->bind_param("ss", $username, $username);
$stmt->execute();
$result = $stmt->get_result();
if($result->num_rows == 1){
$user = $result->fetch_assoc();
if($user['is_active'] == 0) {
$error = "Your account is deactivated. Please contact HR.";
} elseif(password_verify($password, $user['password'])){
$_SESSION['user_id'] = $user['user_id'];
$_SESSION['staff_id'] = $user['staff_id'];
$_SESSION['staff_no'] = $user['staff_no'];
$_SESSION['username'] = $user['username'];
$_SESSION['role'] = $user['role'];
$_SESSION['branch_id'] = $user['branch_id'];
$_SESSION['first_login'] = $user['first_login'];
// Update last login
$conn->query("UPDATE users SET last_login = NOW() WHERE user_id = {$user['user_id']}");
// Redirect based on role
switch($user['role']) {
case 'admin':
header("Location: admin_dashboard.php");
break;
case 'cfo':
header("Location: cfo_dashboard.php");
break;
case 'hr_manager':
header("Location: hr_dashboard.php");
break;
case 'accountant':
header("Location: accountant_dashboard.php");
break;
case 'branch_manager':
header("Location: branch_manager_dashboard.php");
break;
case 'night_manager':
header("Location: night_manager_dashboard.php");
break;
default:
header("Location: employee_dashboard.php");
}
exit;
} else {
$error = "Invalid password";
}
} else {
$error = "User not found. Please register first.";
}
}
}
?>
Login - EcoMart HR