<?php include "nav.php" ;
$sql="SELECT * FROM events WHERE  EID={$_GET['id']}";
$res=$connect->query($sql);
if($res->num_rows>0){
    $r=$res->fetch_assoc();
}
?>
<style>
    .event-image-banner {
    display: flex;
    align-items: center; /* Centers the content vertically */
    height: 350px; /* Adjust the height as needed */
    background-image: url("assets/images/bg/bg-image-10.jpg");
    background-size: cover;
    background-position: center;
}

</style>
<div class="event-image-banner">
  <div class="container">
  <ul class="page-list text-white" style="color:#fff!important">
                                <li class="rbt-breadcrumb-item text-white"><a href="index.php text-white">Home</a></li>
                                <li>
                                    <div class="icon-right"><i class="feather-chevron-right"></i></div>
                                </li>
                                <li class="rbt-breadcrumb-item active text-white">Event</li>
                            </ul>
                            <h2 class="title mb--0 text-white"><?php echo $r["ENAME"] ;?></h2>
  </div>
</div>
   <!-- <div class="rbt-breadcrumb-default rbt-breadcrumb-style-3">
        <div class="breadcrumb-inner">
            <img class="event-banner" src="assets/images/bg/bg-image-10.jpg" alt="Vethathiri School Images">
        </div>
        <div class="container">
            <div class="row">
                <div class="col-lg-8">
                    <div class="content">
                        <div class="content text-start">
                            <ul class="page-list text-white" style="color:#fff!important">
                                <li class="rbt-breadcrumb-item text-white"><a href="index.php text-white">Home</a></li>
                                <li>
                                    <div class="icon-right"><i class="feather-chevron-right"></i></div>
                                </li>
                                <li class="rbt-breadcrumb-item active text-white">Event</li>
                            </ul>
                            <h2 class="title mb--0 text-white"><?php echo $r["ENAME"] ;?></h2>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div> -->
    <div class="rbt-course-details-area rbt-section-gap-event">
        <div class="container">
            <div class="row g-5">
                <div class="col-lg-12">
                    <div class="course-details-content">
                        
                        <div class="rbt-feature-box  thuumbnail">
                            <!-- <?php  
                            
                            $sqll = "SELECT e.EID,e.EIMAGE,e.EDES   
                            FROM events e  INNER JOIN evt_highlights h ON h.EID = h.EID 
                            WHERE e.EID = " . intval($_GET['id']);
                   
                   $ress = $connect->query($sqll);
                   
                   if ($ress === false) {
                       // Query execution failed
                       echo "Error: " . $connect->error;
                   } else {
                       // Query executed successfully
                       if ($ress->num_rows > 0) {
                           $rr = $ress->fetch_assoc();
                       } else {
                           // No results found
                           echo "";
                       }
                   }
?>                    -->
                       <img class="w-100 evt-img" src="admin/<?php echo $r["EIMAGE"] ;?>" >
                        </div>
                    </div>
                </div>
            </div>
                  <!-- Start Course Feature Box  -->
                        <div class="rbt-feature-box mt--60">
                            <div class="row g-5">
                                <!-- Start Feture Box  -->
                                <div class="col-lg-12">
                                    <div class="section-title">
                                        <h4 class="title mb--20">Event Description</h4>
                                    </div>
                                    <p><?php echo $r["EDES"] ;?></p>
                                   
                                </div>
                                <!-- End Feture Box  -->
                            </div>
                        </div>
                        <!-- End Course Feature Box  -->

        
                   
            <?php
if(isset($_GET['id']) && is_numeric($_GET['id'])) {
    $sql2 = "SELECT e.EID,e.EIMAGE,e.EDES,h.EHIGHLIGHT   
    FROM events e  INNER JOIN evt_highlights h ON h.EID = e.EID 
    WHERE e.EID = {$_GET['id']}";
  
    $res2 = $connect->query($sql2);

    if ($res2) {
        if ($res2->num_rows > 0) {
            ?>

            <div class="row  mt--60">
            <div class="col-lg-8">
                <?php
            echo '<h4 class="title mb--20">Event Highlights </h4>';
            $highlightsFound = false; // Flag to check if highlights are found
            while ($r2 = $res2->fetch_assoc()) {
                $highlights = json_decode($r2["EHIGHLIGHT"], true);

                if ($highlights !== null) { // Check if decoding was successful
                    $highlightsFound = true; // Set flag to true as highlights are found
                    foreach ($highlights as $highlight) {
                        echo '<span class="description"><span class="fa fa-check fa_check"></span> ' . htmlspecialchars($highlight) . '</span><br>';
                    }
                } else {
                    echo '<p class="description mt--30">Failed to parse highlights.</p>';
                }
            }
            ?>
                </div>
            <div class="col-lg-6">
                   
                     
                         
            </div>
    </div>
            <?php
            // If no highlights are found, display a message
            if (!$highlightsFound) {
                echo '<p class="description mt--30">No highlights found for this event.</p>';
            }
        } else {
            // No highlights found, so don't display heading
            echo '<p class="description mt--30"></p>';
        }
    } else {
        echo '<p class="description mt--30">Error in executing SQL query: ' . $connect->error . '</p>';
    }
} else {
    echo '<p class="description mt--30">Invalid or missing ID parameter.</p>';
}
?>





                         
        
            <div class="row">
                <div class="col-12 ">
                       
                 <?php
$sqlll = "SELECT e.EID, g.IMAGE    
          FROM gallery g 
          INNER JOIN events e ON g.EID = e.EID 
          WHERE e.EID = " . intval($_GET['id']) . " 
          LIMIT 8";

$resss = $connect->query($sqlll);
if ($resss->num_rows > 0) {
    $i = 0;
    ?>
    <div class="rbt-gallery-area rbt-section-gap">
    <div class="row g-0 parent-gallery-container">
    <?php
    while ($rrr = $resss->fetch_assoc()) {
        $i++;
?>
        <a href='admin/<?php echo $rrr["IMAGE"]; ?>'
           class="child-gallery-single col-lg-3 col-md-4 col-sm-6 col-6">
            <div class="rbt-gallery">
                <img class="w-100 evt-gallery" src='admin/<?php echo $rrr["IMAGE"]; ?>' alt="Card image">
            </div>
        </a>
<?php
    }?>
</div></div>
<?php
}
?>

       
                </div>
            </div>
                  <!-- Start Course Feature Box  -->
                  <div class="rbt-feature-box">
    <div class="row g-5">
        <!-- Start Feature Box  -->
        <!-- <?php
        $sql1 = "SELECT * FROM winners WHERE EID={$_GET['id']}";
        $res1 = $connect->query($sql1);
        if ($res1->num_rows > 0) {
        ?>
            <div class="col-lg-12">
                <div class="section-title">
                    <h4 class="title mb--20">Winner</h4>
                </div>
            </div>
        <?php
        }
        ?> -->
        <!-- End Feature Box  -->
    </div>
</div>
<div class="">
    <div class="container">
        <div class="row">
            <div class="col-lg-12">
           
                    <!-- Start Single Card  -->
               
                    <?php
$sqlw = "SELECT e.EID, w.SIMAGE, w.SNAME, w.POSITION FROM winner w INNER JOIN events e ON w.EID = e.EID WHERE e.EID = {$_GET['id']}";

$resw=$connect->query($sqlw);
    if ($resw->num_rows > 0) {
        $i = 0;?>
        <h4 class="title mb--20">Participants</h4>
        <div class="rbt-course-grid-column">
            <?php
        while ($rw = $resw->fetch_assoc()) {
            $i++;
?>
            <div class="course-grid-3">
                <div class="rbt-card variation-01 rbt-hover">
                    <div class="rbt-card-img">
                        <a>
                            <img class="evt-gallery" src="admin/<?php echo $rw["SIMAGE"]; ?>" alt="Card image">
                        </a>
                    </div>
                    <div class="rbt-card-body">
                        <h3 class="rbt-card-title"><?php echo $rw["SNAME"]; ?></h3>
                        <p class="rbt-card-text"><?php echo $rw["POSITION"]; ?> </p>
                    </div>
                </div>
            </div>
<?php
        }
    } else {
        // No winners found
        echo "";
    }

?>

                    <!-- End Single Card  -->
                </div>
            </div>
        </div>
    </div>
</div>

    </div>
                        <!-- End Course Feature Box  -->
        </div>
    </div>

    
    <div class="rbt-separator-mid">
        <div class="container">
            <hr class="rbt-separator m-0">
        </div>
    </div>
    <div class="rbt-rbt-blog-area rbt-section-gapTop bg-color-darker rbt-round-bottom-shape">
        <div class="wrapper pb--50 rbt-index-upper">
            <div class="container">
                <div class="row g-5 align-items-end mb--60">
                    <div class="col-lg-6 col-md-12 col-12">
                        <div class="section-title text-start">
                            <h2 class="title color-white">Join us</h2>
                            <p class="description color-white-off mt--20">In our school, we have values, education,
                                morale, and a safe environment suited to feed bright little minds. </p>
                        </div>
                    </div>
                    <div class="col-lg-6 col-md-12 col-12">
                        <div class="load-more-btn text-start text-lg-end">
                            <a class="rbt-btn btn-sm btn-border color-white-off" href="">
                                Know More
                            </a>
                        </div>
                    </div>
                </div>
                <!-- Start Card Area -->
                <div class="row g-5">
                    <!-- Start Splash Service  -->
                    <div class="col-lg-4 col-md-6 col-sm-12 col-12" data-sal-delay="150" data-sal="slide-up"
                        data-sal-duration="800">
                        <div class="rbt-splash-service no-translate h-100">
                            <div class="inner">
                                <div class="icon">
                                    <img src="assets/images/home/documentation.png" alt="Icons Images">
                                </div>
                                <div class="content">
                                    <h4 class="title"><a href="contact-us.php">Details</a></h4>
                                    <p class="description">To know more about our school</p>
                                    <a class="rbt-btn bg-primary-opacity hover-icon-reverse w-100" target="_blank"
                                        href="about-us.php">
                                        <span class="icon-reverse-wrapper">
                                            <span class="btn-text">View</span>
                                            <span class="btn-icon"><i class="feather-arrow-right"></i></span>
                                            <span class="btn-icon"><i class="feather-arrow-right"></i></span>
                                        </span>
                                    </a>
                                    <!--<ul class="liststyle">
                                        <li>Lorem ipsum dolor sit, amet consectetur adipisicing elit. Repellat,
                                            Asperiores nobis.</li>
                                    </ul>-->
                                </div>
                            </div>
                        </div>
                    </div>
                    <!-- End Splash Service  -->

                    <!-- Start Splash Service  -->
                    <div class="col-lg-4 col-md-6 col-sm-12 col-12" data-sal-delay="200" data-sal="slide-up"
                        data-sal-duration="800">
                        <div class="rbt-splash-service no-translate support h-100">
                            <div class="inner">
                                <div class="icon">
                                    <img src="assets/images/home/support.png" alt="Icons Images">
                                </div>
                                <div class="content">
                                    <h4 class="title"><a href="contact-us.php">Contact us</a></h4>
                                    <p class="description">Get assistance with the admission</p>
                                    <a class="rbt-btn bg-secondary-opacity hover-icon-reverse w-100" target="_blank"
                                        href="contact-us.php">
                                        <span class="icon-reverse-wrapper">
                                            <span class="btn-text">Get Support</span>
                                            <span class="btn-icon"><i class="feather-arrow-right"></i></span>
                                            <span class="btn-icon"><i class="feather-arrow-right"></i></span>
                                        </span>
                                    </a>
                                    <ul class="liststyle">
                                        <li><span>Support Time:</span> Monday – Friday</li>
                                        <li><span>Response Time:</span> Maximum 24 hours</li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                    <!-- End Splash Service  -->

                    <!-- Start Splash Service  -->
                    <div class="col-lg-4 col-md-6 col-sm-12 col-12" data-sal-delay="250" data-sal="slide-up"
                        data-sal-duration="800">
                        <div
                            class="rbt-splash-service no-translate support h-100 bg-gradient-7 rbt-splash-service-white border-0">
                            <div class="inner">
                                <div class="icon">
                                    <img src="assets/images/home/hire.png" alt="Icons Images">
                                </div>
                                <div class="content">
                                    <h4 class="title color-white">Academics </h4>
                                    <!-- <p class="description color-white">Need you any custom job</p> -->
                                    <p class="description color-white opacity-75">For all Academics related queries like
                                        timing, holidays, homework, directly contact us.

                                    </p>
                                    <a class="rbt-btn btn-white hover-icon-reverse w-100" target="_blank"
                                        href="contact-us.php">
                                        <span class="icon-reverse-wrapper">
                                            <span class="btn-text">Contact</span>
                                            <span class="btn-icon"><i class="feather-arrow-right"></i></span>
                                            <span class="btn-icon"><i class="feather-arrow-right"></i></span>
                                        </span>
                                    </a>
                                    <ul class="plan-offer-list rbt-list-white-opacity mt--20">
                                        <li>
                                            <i class="feather-check"></i>Response Time: 2 Hours
                                        </li>
                                        <li>
                                            <i class="feather-check"></i> Personal response from our staff.
                                        </li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                    <!-- End Splash Service  -->
                </div>
                <!-- End Card Area -->
            </div>
        </div>
    </div>
    
    <footer class="rbt-footer footer-style-1 pt--100">
        <div class="footer-top">
            <div class="container">
                <div class="row row--15 mt_dec--30">
                    <div class="col-lg-6 col-md-6 col-sm-6 col-12 mt--30">
                        <div class="footer-widget">
                            <div class="logo text-center text-lg-start"> <a href="index.php"> <img
                                        src="assets/images/logo/logo.png" alt="Vethathiri School"> </a>
                            </div>
                            <p class="description mt--20 text-center text-lg-start">Ever since the blossoming of our
                                school in Tharamangalam in 2012, we have impacted more than 2,000 lives, setting a new
                                benchmark for education. We're one of the top schools in Tamil Nadu.</p>
                            <div class="contact-btn mt--30 text-center text-lg-start"> <a
                                    class="rbt-btn hover-icon-reverse btn-border-gradient radius-round"
                                    href="contact-us.php">
                                    <div class="icon-reverse-wrapper"> <span class="btn-text">Contact With Us</span>
                                        <span class="btn-icon"><i class="feather-arrow-right"></i></span> <span
                                            class="btn-icon"><i class="feather-arrow-right"></i></span>
                                    </div>
                                </a> </div>
                        </div>
                    </div>
                    <div class="offset-lg-1 col-lg-2 col-md-6 col-sm-6 col-12 mt--30">
                        <div class="footer-widget">
                            <h5 class="ft-title text-center text-lg-start">Useful Links</h5>
                            <ul class="ft-link text-center text-lg-start">
                                <li> <a href="index.php">Home</a> </li>
                                <li> <a href="about-us.php">About Us</a> </li>
                                <li> <a href="facilities.php">Facilities</a> </li>
                                <li> <a href="careers.php">Careers</a> </li>
                                <li> <a href="contact-us.php">Contact Us</a> </li>
                            </ul>
                        </div>
                    </div>

                    <div class="col-lg-3 col-md-6 col-sm-6 col-12 mt--30">
                        <div class="footer-widget">
                            <h5 class="ft-title text-center text-lg-start">Get Contact</h5>
                            <ul class="ft-link text-center text-lg-start">
                                <li><span>Phone:</span> <a href="tel:9976477520">(+91) 99764 77520</a></li>
                                <li><span>E-mail:</span> <a href="mailto:vmmschool@gmail.com">vmmschool@gmail.com</a>
                                </li>
                                <li><span>Location:</span> <a href="https://goo.gl/maps/QDLbFpMsQZxERTzm9"
                                        target="_blank">Tharamangalam, Salem.</a></li>
                            </ul>
                            <ul
                                class="social-icon social-default icon-naked justify-content-center  justify-content-lg-start mt--20">
                                <li><a href="https://www.facebook.com/vethathirimaharishismartschool" target="_blank">
                                        <i class="feather-facebook"></i> </a> </li>
                                <li><a href="https://www.instagram.com/vethathirimaharishismartschool/" target="_blank">
                                        <i class="feather-instagram"></i> </a> </li>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </footer>
    <div class="rbt-separator-mid">
        <div class="container">
            <hr class="rbt-separator m-0">
        </div>
    </div>
    <div class="copyright-area copyright-style-1 ptb--20">
        <div class="container">
            <div class="row align-items-center">
                <div class="col-xxl-8 col-xl-8 col-lg-8 col-md-12 col-12">
                    <p class="rbt-link-hover text-lg-start text-center">© 2023 All
                        Rights
                        Reserved | Designed
                        with <i class="fa fa-heart text-danger"></i> by <a href="http://thedotstudios.com/"
                            target="_blank">TheDotStudios</a></p>
                </div>
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-12 col-12">
                    <ul
                        class="social-icon social-default icon-naked justify-content-center  justify-content-lg-end  m-0">
                        <li><a href="https://www.facebook.com/thedotstudios/" target="_blank"> <i
                                    class="feather-facebook"></i> </a>
                        </li>
                        <li><a href="https://mobile.twitter.com/thedotstudios"> <i class="feather-twitter"
                                    target="_blank"></i> </a>
                        </li>
                        <li><a href="https://www.instagram.com/thedotstudios/"> <i class="feather-instagram"
                                    target="_blank"></i>
                            </a> </li>
                        <li><a href="https://in.linkedin.com/company/thedotstudios"> <i class="feather-linkedin"
                                    target="_blank"></i> </a> </li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
    <div class="rbt-progress-parent">
        <svg class="rbt-back-circle svg-inner" width="100%" height="100%" viewBox="-1 -1 102 102">
            <path d="M50,1 a49,49 0 0,1 0,98 a49,49 0 0,1 0,-98" />
        </svg>
    </div>
    <script src="assets/js/vendor/modernizr.min.js"></script>
    <script src="assets/js/vendor/jquery.js"></script>
    <script src="assets/js/vendor/bootstrap.min.js"></script>
    <script src="assets/js/vendor/sal.js"></script>
    <script src="assets/js/vendor/swiper.js"></script>
    <script src="assets/js/vendor/magnify.min.js"></script>
    <script src="assets/js/vendor/jquery-appear.js"></script>
    <script src="assets/js/vendor/odometer.js"></script>
    <script src="assets/js/vendor/backtotop.js"></script>
    <script src="assets/js/vendor/isotop.js"></script>
    <script src="assets/js/vendor/imageloaded.js"></script>
    <script src="assets/js/vendor/wow.js"></script>
    <script src="assets/js/vendor/waypoint.min.js"></script>
    <script src="assets/js/vendor/easypie.js"></script>
    <script src="assets/js/vendor/text-type.js"></script>
    <script src="assets/js/vendor/jquery-one-page-nav.js"></script>
    <script src="assets/js/vendor/bootstrap-select.min.js"></script>
    <script src="assets/js/vendor/jquery-ui.js"></script>
    <script src="assets/js/vendor/magnify-popup.min.js"></script>
    <script src="assets/js/vendor/paralax-scroll.js"></script>
    <script src="assets/js/vendor/paralax.min.js"></script>
    <script src="assets/js/vendor/countdown.js"></script>
    <script src="assets/js/main.js"></script>

</body>

</html>