Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
.htaccess	495 B	-rwxr-xr-x
1Head.php	2.39 KB	-rwxr-xr-x
2HeadMenu.php	5.69 KB	-rwxr-xr-x
2banner.php	1.58 KB	-rwxr-xr-x
3Footer.php	806 B	-rwxr-xr-x
4End.php	395 B	-rwxr-xr-x
about.php	5.03 KB	-rwxr-xr-x
blog.php	8.82 KB	-rwxr-xr-x
blog_detail.php	4.46 KB	-rwxr-xr-x
contact.php	8.55 KB	-rwxr-xr-x
detail.php	27.02 KB	-rwxr-xr-x
gallery.php	8.92 KB	-rwxr-xr-x
index.php	181 B	-rwxr-xr-x
product.php	8.96 KB	-rwxr-xr-x
product_detail.php	18.04 KB	-rwxr-xr-x

Code Editor : gallery.php

<?PHP
include '1Head.php';
include '2HeadMenu.php';
?>
<link href="https://fonts.googleapis.com/css?family=Droid+Sans:400,700" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/baguettebox.js/1.8.1/baguetteBox.min.css">
<link rel="stylesheet" href="assets/css/gallery-grid.css">

<main style="margin-top: 6%;">
    
    <div class="breadcrumb-area common-bg">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <div class="breadcrumb-wrap">
                        <nav aria-label="breadcrumb">
                            <h1>แกลลอรี่</h1>
                            <ul class="breadcrumb">
                                <li class="breadcrumb-item"><a href="index.php"><i class="fa fa-home"></i></a></li>
                                <li class="breadcrumb-item active" aria-current="page">แกลลอรี่</li>
                            </ul>
                        </nav>
                    </div>
                </div>
            </div>
        </div>
    </div>

<div class="shop-main-wrapper section-space pb-0">
        <div>
            <div class="row justify-content-md-center" style="margin-right: 0px;margin-left: 0px;">

<div class="col-lg-12 order-1 order-lg-2">
                    <div class="shop-product-wrapper">

<div class="shop-product-wrap grid-view row mbn-40">
                            
                            <div class="tz-gallery">
                                <h1 style="text-align: center; color: #fff;">รูปภาพ</h1>
                                <div class="row">
                                    <?PHP

$HomeID = '87';
                                    $SQL_Home = "
SELECT home.Home_ID, home.Member_ID, member.Member_NameEN, member.Position_ID, 
position.Position_Name, home.Home_Date, home.Home_Time, home.Home_Visitors, home.Home_Sub, 
home.Home_Short,home.Home_Short2,home.Home_Short3, home.Home_Detail, home.Home_Category, home.StatusHome_ID, 
status_home.StatusHome_Name, home.StatusShowPage_ID, status_showpage.StatusShowPage_Name
FROM status_showpage INNER JOIN (status_home 
INNER JOIN (position INNER JOIN (member
INNER JOIN home ON member.Member_ID = home.Member_ID) 
ON position.Position_ID = member.Position_ID)
ON status_home.StatusHome_ID = home.StatusHome_ID) 
ON status_showpage.StatusShowPage_ID = home.StatusShowPage_ID
WHERE home.StatusHome_ID = 1 AND home.StatusShowPage_ID = '$HomeID'
ORDER BY home.Home_ID asc
";

$objQuery_Home = $objConnect->query($SQL_Home);

while ($objResult_Home = mysqli_fetch_array($objQuery_Home)) {

$HomeID = $objResult_Home["Home_ID"];
                                        $HomeSub = $objResult_Home["Home_Sub"];
                                        $HomeShort = $objResult_Home["Home_Short"];
                                        $HomeDetail = $objResult_Home["Home_Detail"];
                                        $HomeShort2 = $objResult_Home["Home_Short2"];
                                        $HomeShort3 = $objResult_Home["Home_Short3"];
                                        $HomeDate = $objResult_Home["Home_Date"];
                                        $StatusShowPageID = $objResult_Home["StatusShowPage_ID"];

$MemberNameEN = $objResult_Home["Member_NameEN"];

$date = date_create($HomeDate);
                                        $NewDate1 = date_format($date, "d");
                                        $NewDate2 = date_format($date, "F");
                                        $NewDate = date_format($date, "F d , Y");

// Show img only  LIMIT 1
                                        $SQL_Home_Img = "
SELECT img_home.Home_ID, img_home.ImgHome_Img,
img_home.ImgHome_Sort, img_home.StatusImgHome_ID
FROM img_home
WHERE img_home.Home_ID = $HomeID 
ORDER BY img_home.ImgHome_Sort ASC 							
";
                                        $objQuery_Home_Img = $objConnect->query($SQL_Home_Img);

// พากหัว หลัก
                                        if ($HomeSub == "-") {
                                            $Check_HomeSub2 = "";
                                        } else {
                                            $Check_HomeSub2 = $HomeSub;
                                        }

//map
                                        if ($HomeShort == "-") {
                                            $Check_HomeShort2 = "";
                                        } else {
                                            $Check_HomeShort2 = $HomeShort;
                                        }

//เกริน
                                        if ($HomeDetail == "-") {
                                            $Check_HomeShort3 = "";
                                        } else {
                                            $Check_HomeShort3 = $HomeShort2;
                                        }

//เวลา
                                        if ($HomeDetail == "-") {
                                            $Check_HomeShort4 = "";
                                        } else {
                                            $Check_HomeShort4 = $HomeShort3;
                                        }

//รายละเอียด
                                        if ($HomeDetail == "-") {
                                            $Check_HomeDetai2 = "";
                                        } else {
                                            $Check_HomeDetai2 = $HomeDetail;
                                        }

?>
                                        <?PHP
                                        while ($objResult_Home_Img = mysqli_fetch_array($objQuery_Home_Img)) {
                                            $HomeID_Img = $objResult_Home_Img["Home_ID"];
                                            $HomeImg_Img = $objResult_Home_Img["ImgHome_Img"];
                                            ?>
                                            <div class="col-sm-6 col-md-3">

<a class="lightbox" href="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>">
                                                    <img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="" style="height: 450px;">
                                                </a>
                                            </div>
                                        <?PHP } ?>
                                    <?PHP } ?>
                                </div>
                            </div>
                            <script src="https://cdnjs.cloudflare.com/ajax/libs/baguettebox.js/1.8.1/baguetteBox.min.js"></script>
                            <script>
                                baguetteBox.run('.tz-gallery');
                            </script>

</div>
                        
                    </div>

</div>
            </div>
            
        </div>
    </div>
    </div>
    
</main>
<br>

<?PHP
include '3Footer.php';
include '4End.php';
?>

${this.title}

Code Editor : gallery.php