<?php 


include "../connection.php"; 




$sql1 = "SELECT COUNT(*) AS Notice FROM notification WHERE userid=? AND status = 'Unread'"; 
$stmt = $con->prepare($sql1);

$stmt->bind_param("i", $userid); 

$stmt->execute();
$stmt->bind_result($Notice);
$stmt->fetch();
$stmt->close();


$Notice = $Notice ?? 0; 

 
?>

<header> 

<!-- Navigation Menu -->
        <div class="navbar fixed-bottom nav-card">
            <div class="container">
                <div class="row w-100 text-center">
                    <div class="col-3">
                        <a href="index.php" class="nav-link nav-comp"><i class="font fa-regular fa-home"></i> <br> হোম </a>
                    </div>
                    <div class="col-3">
                        <a href="view-profile.php" class="nav-link nav-comp"><i class="font fa-regular fa-user"></i> <br>প্রোফাইল </a>
                    </div>
                    <div class="col-3">
                        <a href="notification.php" class="nav-link nav-comp" ><i class="font fa-regular fa-bell">
						<sup class="text-danger"><strong><?php echo $Notice;?> </strong></sup></i> <br> নোটিশ </a>
                    </div>
                    <div class="col-3">
                        <a href="logout.php" class="nav-link nav-comp text-danger"><i class="font fa-regular fa-arrow-up-from-square fa-rotate-270"></i> <br> লগ আউট </a>
                    </div>
                </div>
            </div>
        </div>
    </header> 