1#@!#!123s

: / home / schoolcampuserp / ppssimrahi.in /
Filename : birthday.php
back
<?php 
    include('admin/database/dbconfig.php');
    
    $image_base_url = "https://kushal.amarshaktimemorialschool.in/";
    // Get today's date and extract day and month
    $today = date('Y-m-d');
    $current_day = date('d');
    $current_month = date('m');
      if (isset($conn1) && $conn1) {
    // Check if $conn1 is a valid connection and run the query
    $sql5 = "
        SELECT 
            s.id, 
            s.firstname, 
            s.image, 
            s.dob, 
            ss.class_id, 
            ss.section_id, 
            c.class AS class_name, 
            sec.section AS section_name,
            sch.session_id,
            DATEDIFF(
                DATE(CONCAT(YEAR(CURDATE()), '-', MONTH(s.dob), '-', DAY(s.dob))),
                CURDATE()
            ) AS days_until_birthday
        FROM students s
        INNER JOIN student_session ss ON s.id = ss.student_id
        INNER JOIN classes c ON ss.class_id = c.id
        INNER JOIN sections sec ON ss.section_id = sec.id
        INNER JOIN sch_settings sch ON ss.session_id = sch.session_id
        WHERE 
            DATEDIFF(
                DATE(CONCAT(YEAR(CURDATE()), '-', MONTH(s.dob), '-', DAY(s.dob))),
                CURDATE()
            ) BETWEEN 0 AND 7
        ORDER BY days_until_birthday ASC
        
    ";
    $students = mysqli_query($conn1, $sql5);

    // Check for errors in query execution
    if (!$students) {
        echo "Error executing query on conn1: " . mysqli_error($conn1);
    }
} else {
    
    $sql5 = "
        SELECT 
            id, 
            name as firstname,
            image_path, 
            dob, 
            role,
            'N/A' AS class_name, 
            'N/A' AS section_name,
            'N/A' AS session_id,
            DATEDIFF(
                DATE(CONCAT(YEAR(CURDATE()), '-', MONTH(dob), '-', DAY(dob))),
                CURDATE()
            ) AS days_until_birthday
        FROM users
        WHERE 
            DATEDIFF(
                DATE(CONCAT(YEAR(CURDATE()), '-', MONTH(dob), '-', DAY(dob))),
                CURDATE()
            ) BETWEEN 0 AND 7
        ORDER BY days_until_birthday ASC
    
    ";

$students = mysqli_query($conn, $sql5);
}
    
?>

<!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">Birthday's</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">Birthday's</li>
                </ol>    
            </div>
        </div>
    <!-- Header End -->
	 <!-- Banner Start -->
    <?php include('banner.php') ?>
    <!-- Banner End -->
    <!-- Birthday Section Start -->
    <div class="container-fluid birthday-section pb-5">
        <div class="container pb-5">
            <!-- Section Header -->
            <div class="section-header text-center mb-5">
                <h4 class="section-subtitle text-secondary fw-bold wow fadeInUp" data-wow-delay="0.1s">
                    <i class="ph-cake-fill me-2"></i>Birthday Celebrations
                </h4>
                <h1 class="section-title display-4 mb-4 wow fadeInUp" data-wow-delay="0.3s">
                    Today's & Upcoming Birthdays
                </h1>
                <p class="section-description text-muted mx-auto wow fadeInUp" data-wow-delay="0.5s">
                    Celebrating the special moments of our incredible team and students
                </p>
            </div>

            <!-- Birthday Cards Row -->
            <div class="row g-4 justify-content-center">
                <!-- Birthday Card -->
                <?php if(mysqli_num_rows($students)>0) {
                   
                        while($student = mysqli_fetch_assoc($students)){ ?>
                            
                     
                <div class="col-lg-3 col-md-6 col-sm-12 wow fadeInUp" data-wow-delay="0.1s">
                    <div class="birthday-card">
                        <div class="birthday-card-content">
                            <?php if($student['days_until_birthday'] == 0){ ?>
                            <div class="birthday-badge">Today!</div>
                            <h3 class="celebrant-name"><?php echo $student['firstname']; ?></h3>
                            <?php if (isset($conn1) && $conn1) { ?>
                            <p class="celebrant-details"><?php echo $student['class_name']; ?> (<?php echo $student['section_name']; ?>)</p>
                             <?php } else { ?>
                             <p class="celebrant-details"><?php echo $student['role']; ?></p>
                              <?php } ?>
                            <button class="btn btn-wish">Send Wishes</button>
                            
                            
                            <?php } else { ?>
                            
                            <div class="birthday-badge birthday-badge-upcoming">In <?php echo $student['days_until_birthday']; ?> Days</div>
                            <h3 class="celebrant-name"><?php echo $student['firstname']; ?></h3>
                            <?php if (isset($conn1) && $conn1) { ?>
                            <p class="celebrant-details"><?php echo $student['class_name']; ?> (<?php echo $student['section_name']; ?>)</p>
                             <?php } else { ?>
                             <p class="celebrant-details"><?php echo $student['role']; ?></p>
                              <?php } ?>
                            <?php } ?>
                        </div>
                        <?php if (isset($conn1) && $conn1) { ?>
                            <img src="<?php echo $image_base_url . $student['image']; ?>" alt="Birthday Image" class="img-fluid birthday-card-bg">
                        <?php } else { ?>
                            <img src="admin/<?php echo $student['image_path']; ?>" alt="Birthday Image" class="img-fluid birthday-card-bg">
                        <?php } ?>
                    </div>
                </div>
                <?php    }
                } ?>

                <!-- Upcoming Birthday Cards -->
                <!--<div class="col-lg-3 col-md-6 col-sm-12 wow fadeInUp" data-wow-delay="0.2s">-->
                <!--    <div class="birthday-card">-->
                <!--        <div class="birthday-card-content">-->
                <!--            <div class="birthday-badge birthday-badge-upcoming">In 3 Days</div>-->
                <!--            <h3 class="celebrant-name">Bob Smith</h3>-->
                <!--            <p class="celebrant-details">Grade 11 • Mathematics</p>-->
                <!--        </div>-->
                <!--        <img src="./img/team-1.jpg" alt="Birthday Celebrant" class="img-fluid birthday-card-bg">-->
                <!--    </div>-->
                <!--</div>-->
                <!--<div class="col-lg-3 col-md-6 col-sm-12 wow fadeInUp" data-wow-delay="0.3s">-->
                <!--    <div class="birthday-card">-->
                <!--        <div class="birthday-card-content">-->
                <!--            <div class="birthday-badge birthday-badge-upcoming">In 5 Days</div>-->
                <!--            <h3 class="celebrant-name">Charlie Davis</h3>-->
                <!--            <p class="celebrant-details">Grade 12 • Physics</p>-->
                <!--        </div>-->
                <!--        <img src="./img/team-3.jpg" alt="Birthday Celebrant" class="img-fluid birthday-card-bg">-->
                <!--    </div>-->
                <!--</div>-->
                <!--<div class="col-lg-3 col-md-6 col-sm-12 wow fadeInUp" data-wow-delay="0.4s">-->
                <!--    <div class="birthday-card">-->
                <!--        <div class="birthday-card-content">-->
                <!--            <div class="birthday-badge birthday-badge-upcoming">In 7 Days</div>-->
                <!--            <h3 class="celebrant-name">Diana White</h3>-->
                <!--            <p class="celebrant-details">Grade 9 • Chemistry</p>-->
                <!--        </div>-->
                <!--        <img src="./img/team-4.jpg" alt="Birthday Celebrant" class="img-fluid birthday-card-bg">-->
                <!--    </div>-->
                <!--</div>-->
            </div>
        </div>
    </div>
    <!-- Birthday Section End -->

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

</html>