<?php

include "php/header.php";
?>
<div class="contents">
    <div class="custom-container">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <ol class="breadcrumb">
                    <li><a href="<?= $siteUrlMain; ?>">Home</a></li>
                    <li><a href="<?= $siteUrlMain; ?>videos">Videos</a></li>
                    <?php
                    if (isset($_GET['id']) && $_GET['id'] != "") {
                        $sqlVdsNv = mysqli_query($conn, "select title FROM videos WHERE urlPage='" . $_GET['id'] . "' ");
                        $numRowVdsNv = mysqli_num_rows($sqlVdsNv);
                        if ($numRowVdsNv > 0) {
                            $rowsVdsNv = mysqli_fetch_array($sqlVdsNv);
                            echo '<li class="active">' . $rowsVdsNv['title'] . '</li>';
                        } else {
                            echo '<li class="active">Video</li>';
                        }
                    } else {
                        echo '<li class="active">Video</li>';
                    }
                    ?>
                </ol>
            </div>
            <div class="col-lg-9 col-md-12 col-sm-12 col-xs-12 equalcol conentsection">
                <div class="clearfix"></div>
                <div class="blogdetail sections pageTxt">
                    <?php
                    $sqlNws = mysqli_query($conn, "select * from videos where urlPage='" . $_GET['id'] . "' ");
                    $numRowNws = mysqli_num_rows($sqlNws);
                    if ($numRowNws > 0) {
                        $rows = mysqli_fetch_array($sqlNws);
                        $sqlCondton = "where id<>" . $rows['id'] . "";
                        echo '<div class="bootstrap-carousel">';
                        if ($rows['youtubeID'] != "") {
                            echo '<iframe class="embed-responsive-item" width="100%" height="400" src="http://www.youtube.com/embed/' . $rows['youtubeID'] . '?autoplay=1" allowfullscreen></iframe> ';
                        } else {
                            echo '<img src="' . $siteUrlMain . 'php/timthumb.php?src=' . $siteUrlMain . 'img/' . (($rows['newsImg'] != "") ? $rows['newsImg'] : 'noImg.jpg') . '&h=330&w=816&zc=1" alt="img" />';
                        }
                        echo '</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="blogtext">
<h2 class="heading">' . $rows['title'] . '</h2>
<div class="clearfix"></div>
<div class="blogmetas">
<ul>
<li><i class="fa fa-calendar"></i>' . date('d M, Y', strtotime($rows['createdDate'])) . '</li>
</ul>
<div class="clearfix"></div>
</div>
<div class="descInfo">' . $rows['description'] . '</div>

<div class="clearfix"></div>
<div class="blogmetas">
<ul>
<li><i class="fa fa-share"></i> Share On </li>
<li> 
<a target="_blank" data-title="' . $rows['title'] . '" href="https://www.facebook.com/sharer/sharer.php?u=' . videoUrl($rows['id']) . '&title=' . $rows['title'] . '"><i class="fa fa-facebook"></i>Facebook</a>  &nbsp;
<a target="_blank" href="https://twitter.com/intent/tweet?url=' . videoUrl($rows['id']) . '"><i class="fa fa-twitter"></i>Twitter</a>  &nbsp;
<a target="_blank" href="https://plus.google.com/share?url=' . videoUrl($rows['id']) . '"><i class="fa fa-google-plus"></i>Google Plus</a>
</li>
</ul>
<div class="clearfix"></div>
</div>

</div>
</div>
</div>';
                    } else {
                        echo '<p>No data found.</p>';
                    }

                    ?>


                </div>

                <div class="clearfix"></div>
                <?php
                $sqlRelPst = mysqli_query($conn, "select id,title,pgImg,createdDate from videos  " . $sqlCondton . " order by id desc LIMIT 6");
                $numRowRP = mysqli_num_rows($sqlRelPst);
                if ($numRowRP > 0) {
                    echo '<div class="clearfix"></div>
<div class="sections">
<h2 class="heading">Related Videos</h2>
<div class="clearfix"></div>
<div class="row">';
                    while ($rowRelPst = mysqli_fetch_array($sqlRelPst)) {
                        echo '<div class="col-lg-4 col-md-6 col-sm-6 col-xs-12">
<div class="blogposttwo">
<figure>
<a href="' . videoUrl($rowRelPst['id']) . '">
<img src="' . $siteUrlMain . 'img/' . (($rowRelPst['pgImg'] != "") ? $rowRelPst['pgImg'] : 'noImg.jpg') . '" class="img-responsive hovereffect" alt="' . $rowRelPst['title'] . '" />
</a>
</figure>
<div class="text">
<h4><a href="' . videoUrl($rowRelPst['id']) . '">' . $rowRelPst['title'] . '</a></h4>
<ul>
<li><i class="fa fa-calendar"></i>' . date('d M, Y', strtotime($rowRelPst['createdDate'])) . '</li>
</ul>
</div>
</div>
<div class="clearfix"></div>
</div>';
                    }
                    echo '</div>
</div>';
                }
                ?>
                <div class="clearfix"></div>
            </div>
            <?php include "php/sideBar.php"; ?>
        </div>
    </div>
</div>
<?php include "php/footer.php"; ?>