1#@!#!123s

: / home / schoolcampuserp / educationalprepschool.in /
Filename : announcements.php
back
<?php 
    include('admin/database/dbconfig.php');
    
    $sql3 = "SELECT * FROM announcements Order BY created_at DESC";
    $announcements = mysqli_query($conn, $sql3);
    
?>
<!DOCTYPE html>
<html lang="en">

    <?php include('head.php'); ?>

    <body>

         <?php include('header.php') ?>


        <!-- Header Start -->
        <div class="container-fluid bg-breadcrumb">
            <div class="container text-center py-5" style="max-width: 900px;">
                <h3 class="text-primary display-3 wow fadeInDown" data-wow-delay="0.1s">Noticeboard | Announcements</h1>
                <ol class="breadcrumb justify-content-center text-white mb-0 wow fadeInDown" data-wow-delay="0.3s">
                    <li class="breadcrumb-item"><a href="index.php" class="text-dark">Home</a></li>
                    <li class="breadcrumb-item active text-primary">Noticeboard</li>
                </ol>    
            </div>
        </div>
        <!-- Header End -->
		

         <!-- Banner Start -->
    <?php include('banner.php') ?>
    <!-- Banner End -->


        <!-- About Start -->
        <div class="container-fluid py-5">
            <div class="container py-5">
                <div class="row g-5 align-items-center justify-content-center">
                    <!-- Left Side: Notice Board -->
                    <div class="col-lg-12 wow fadeInLeft" data-wow-delay="0.1s">
                        <div class="notice-board bg-white text-dark rounded shadow-sm p-4">
                            <h4 class="text-primary fw-bold border-bottom pb-2 mb-3">Announcements</h4>
                            <div class="notice-content" style="max-height: 500px; overflow-y: auto;">
                                <table class="table  text-dark">
                                    <thead>
                                        <th>Sl no.</th>
                                        <th>Title</th>
                                        <th>Description</th>
                                        <th>Download</th>
                                    </thead>
                                    <tbody>
                                        <?php if(mysqli_num_rows($announcements) > 0) {
                                            $i=1;
                                        while ($announcement = mysqli_fetch_assoc($announcements)) {
                                            $created_at = new DateTime($announcement['created_at']); // Assuming 'created_at' is in the format 'YYYY-MM-DD HH:MM:SS'
                                            $today = new DateTime();
                                            $interval = $today->diff($created_at);
                                            $is_new = $interval->days <= 1; 
                                        ?>
                                        <tr>
                                            <td>
                                                <?php echo $i; ?>
                                            </td>
                                            <td>
                                                <?php echo $announcement['title']; ?>
                                                
                                            </td>
                                            <td>
                                                <?php echo $announcement['description']; ?>
                                                <?php if ($is_new): ?>
                                                    <span class="badge bg-info text-dark">New</span>
                                                <?php endif; ?>
                                            </td>
                                            <td>
                                                <a href="admin/<?php echo $announcement['file_path']; ?>" target="_blank" class="text-primary text-decoration-none"> view/download </a>
                                            </td>
                                        </tr>
                                        <?php $i++;}} ?>
                                    </tbody>
                                </table>
                                
                                
                                
                                
                                
                                <ul class="list-unstyled">
                                    <?php if(mysqli_num_rows($announcements) > 0) {
                                        while ($announcement = mysqli_fetch_assoc($announcements)) {
                                            $created_at = new DateTime($announcement['created_at']); // Assuming 'created_at' is in the format 'YYYY-MM-DD HH:MM:SS'
                                            $today = new DateTime();
                                            $interval = $today->diff($created_at);
                                            $is_new = $interval->days <= 3; 
                                ?>
                                        
                                <li class="mb-3">
                                    <a href="admin/<?php echo $announcement['file_path']; ?>" target="_blank" class="text-white text-decoration-none">
                                       <strong>Notification:</strong> <?php echo $announcement['title'];  ?> 
                                        <?php if ($is_new): ?>
                                            <span class="badge bg-info text-dark">New</span>
                                        <?php endif; ?>
                                    </a>
                                </li>
                                <?php }} ?>
                                </ul>
                            </div>
                        </div>
                    </div>                
                </div>
            </div>
        </div>
        <!-- About End -->
         <!-- Counter Facts Start -->
    <?php include('bg_new.php') ?>
    <!-- Counter Facts End -->

                
        <?php include('footer.php') ?>
    </body>

</html>