query("SELECT COUNT(*) FROM assignments");
$stats['total_assignments'] = $stmt->fetchColumn();
$stmt = $pdo->query("SELECT COUNT(*) FROM assignments WHERE status = 'pending'");
$stats['pending_assignments'] = $stmt->fetchColumn();
$stmt = $pdo->query("SELECT COUNT(*) FROM assignments WHERE status = 'completed'");
$stats['completed_assignments'] = $stmt->fetchColumn();
$stmt = $pdo->query("SELECT COUNT(*) FROM users WHERE role = 'student'");
$stats['total_students'] = $stmt->fetchColumn();
} else {
$stmt = $pdo->prepare("SELECT COUNT(*) FROM assignments WHERE student_id = ?");
$stmt->execute([$user_id]);
$stats['total_assignments'] = $stmt->fetchColumn();
$stmt = $pdo->prepare("SELECT COUNT(*) FROM assignments WHERE student_id = ? AND status = 'pending'");
$stmt->execute([$user_id]);
$stats['pending_assignments'] = $stmt->fetchColumn();
$stmt = $pdo->prepare("SELECT COUNT(*) FROM assignments WHERE student_id = ? AND status = 'completed'");
$stmt->execute([$user_id]);
$stats['completed_assignments'] = $stmt->fetchColumn();
}
include 'includes/header.php';
include 'includes/sidebar.php';
?>