1#@!#!123s

: / home / schoolcampuserp / jeevanjyotipublicschoolfatehpurmore.in /
Filename : topper1.php
back
<?php
          
    $currentYear = date('Y');
    $nextYear = $currentYear + 1;
    $currentSession = "$currentYear-" . substr($nextYear, -2);
    $session = intval($currentSession);
    $sqlX = "SELECT * FROM toppers WHERE session = $session AND class = 'X' ORDER BY percentage DESC";
    $toppersX = mysqli_query($conn, $sqlX);
    
    $sqlXII = "SELECT * FROM toppers WHERE session = $session AND class = 'XII' ORDER BY percentage DESC";
    $toppersXII = mysqli_query($conn, $sqlXII);

  
    ?>
    <div class="container-fluid team pb-5">
        <div class="container-fluid px-lg-5 pb-5">
            <!-- Section Header -->
            <div class="pb-4 text-center">
                <h4 class="text-secondary sub-title fw-bold wow fadeInUp mt-5" data-wow-delay="0.1s">Toppers <?php echo $session; ?></h4>
                <h1 class="display-4 mb-4 wow fadeInUp text-primary " data-wow-delay="0.3s">CBSE Class X & XII Result</h1>
            </div>
            <!-- Toppers Grid -->
            <div class="row g-3 justify-content-center owl-carousel topper-carousel" style="height:300px;">
                <!-- Toppers -->
                <?php if(mysqli_num_rows($toppersX)>0){
                        while($topper = mysqli_fetch_assoc($toppersX)){ 
                ?>
                          
                <div class="col-lg-2 col-md-3 col-6 wow fadeInUp mt-3 mb-3" data-wow-delay="0.1s" style="height:270px; width:160px;">
                    <div class="card border-0 shadow-sm h-100 hover-effect">
                        <div class="card-img-top position-relative">
                            <img src="admin/<?php echo $topper['photo_path']; ?>" alt="Toppers Photo" class="img-fluid w-100" style="object-fit: cover; height:170px;">
                        </div>
                        <div class="card-body text-center">
                            <h6 class="fw-bold mb-1 text-primary"><?php echo $topper['name']; ?></h6>
                            <p class="mb-1 text-muted small">Class: <?php echo $topper['class']; ?></p>
                            <p class="text-danger fw-bold mb-0"><?php echo $topper['percentage']; ?>%</p>
                        </div>
                    </div>
                </div>  
                
                <?php } } ?>
            </div>

            <div class="row g-4 justify-content-center mt-3 owl-carousel topper-carousel" style="height:300px;">
                <!-- Toppers -->
                <?php if(mysqli_num_rows($toppersXII)>0){
                        while($topper = mysqli_fetch_assoc($toppersXII)){ 
                ?>
                      
                <div class="col-lg-2 col-md-3 col-sm-6 wow fadeInUp mt-3 mb-3" data-wow-delay="0.1s" style="height:270px; width:160px">
                    <div class="card border-0 shadow-sm h-100 hover-effect">
                        <div class="card-img-top position-relative">
                            <img src="admin/<?php echo $topper['photo_path']; ?>" alt="Toppers Photo" class="img-fluid w-100" style="object-fit: cover; height:170px;">
                        </div>
                        <div class="card-body text-center">
                            <h6 class="fw-bold mb-1 text-primary"><?php echo $topper['name']; ?></h6>
                            <p class="mb-1 text-muted small">Class: <?php echo $topper['class']; ?></p>
                            <p class="text-danger fw-bold mb-0"><?php echo $topper['percentage']; ?>%</p>
                        </div>
                    </div>
                </div>  
                      
                <?php   } } ?>
                
            </div>
            
        </div>
    </div>