 <?php
    include("admin/connection.php");
    include('include/header.php');
    ?>

 <body id="top">
     <!-- HEADER AREA START -->

     <!-- HEADER AREA END -->


     <div class="breadcumb-wrapper" data-bg-src="<?php path() ?>assets/img/banner/video.jpg">
         <div class="container z-index-common">
             <div class="breadcumb-content">
                 <h1 class="breadcumb-title">Our <span class="inner-text">Video</span></h1>
                 <div class="breadcumb-menu-wrap">
                     <ul class="breadcumb-menu">
                         <li><a href="index.php">Home</a></li>
                         <li>Our <span class="inner-text">Video</span></li>
                     </ul>
                 </div>
             </div>
         </div>
     </div>

     <section class="space-extra-bottom space-top">
         <div class="container">


             <div class="row">
                 <?php
                    $gallery = mysqli_query($con, "SELECT * FROM media WHERE page_name = 'Video' ORDER BY id DESC");

                    while ($row = mysqli_fetch_array($gallery)) {
                        $photo = $row['photo'];
                        $caption = $row['caption']; // For video links
                        $video_path = 'admin/assets/images/gallery/' . $photo;

                        echo '<div class="col-xl-3 col-lg-4 col-md-6 col-sm-12 mb-4">';
                        echo '<div class="team-style1" style="background: #f9f9f9; padding: 10px; border-radius: 10px;">';

                        // Display uploaded video file
                        if (!empty($photo) && file_exists($video_path)) {
                            echo '<video style="width: 100%; height: 250px; border-radius: 8px;" controls>
                                <source src="' . $video_path . '" type="video/mp4">
                                Your browser does not support the video tag.
                            </video>';
                        }
                        // Display embedded YouTube or Vimeo links
                        elseif (!empty($caption)) {
                            // YouTube
                            if (strpos($caption, 'youtube.com') !== false || strpos($caption, 'youtu.be') !== false) {
                                parse_str(parse_url($caption, PHP_URL_QUERY), $youtube_params);
                                $youtube_id = $youtube_params['v'] ?? '';

                                if (!$youtube_id && strpos($caption, 'youtu.be') !== false) {
                                    $youtube_id = basename(parse_url($caption, PHP_URL_PATH));
                                }

                                if ($youtube_id) {
                                    echo '<iframe width="100%" height="250" src="https://www.youtube.com/embed/' . $youtube_id . '" frameborder="0" allowfullscreen style="border-radius: 8px;"></iframe>';
                                } else {
                                    echo '<a href="' . htmlspecialchars($caption) . '" target="_blank">View Video</a>';
                                }
                            }
                            // Vimeo
                            elseif (strpos($caption, 'vimeo.com') !== false) {
                                $vimeo_id = basename(parse_url($caption, PHP_URL_PATH));
                                echo '<iframe src="https://player.vimeo.com/video/' . $vimeo_id . '" width="100%" height="250" frameborder="0" allowfullscreen style="border-radius: 8px;"></iframe>';
                            }
                            // Other link
                            else {
                                echo '<a href="' . htmlspecialchars($caption) . '" target="_blank">View Video</a>';
                            }
                        }
                        // No video
                        else {
                            echo '<p>No video available.</p>';
                        }

                        echo '</div>'; // .team-style1
                        echo '</div>'; // .col
                    }
                ?>
             </div>

         </div>

     </section>
     <!-- End -->
     <?php
        include_once('include/footer.php');
        ?>