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 : detail.php

<main>

<?PHP

$HomeID = '79';
    $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 LIMIT 4
";

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

$i = 1;
    while ($objResult_Home = mysqli_fetch_array($objQuery_Home)) {
        $i++;
        $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"];
        $date = date_create($HomeDate);
        $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 LIMIT 1								
";
        $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;
        }

if ($i == 1) {

?>
            <div class="login-register-wrapper section-space pb-0" style="background: #fbfafa;padding-top: 20px;padding-bottom: 20px!important;">
                <div class="container">

<?PHP } else if ($i == 2) {
                $i = 0; ?>
            <div class="login-register-wrapper section-space pb-0">
                <div class="container">
                    <div class="member-area-from-wrap">
                        <div class="row" style="margin-right: 0px;margin-left: 0px;">
                            
                            <div class="col-lg-6">
                                <?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"];
                                            ?>
                                    <img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>">
                                <?PHP } ?>
                            </div>

<div class="col-lg-6">
                                <div class="login-reg-form-wrap sign-up-form">
                                    <h2><?= $Check_HomeSub2; ?></h2>
                                    <?= $Check_HomeDetai2; ?>
                                </div>
                            </div>
                            
                        </div>
                    </div>

</div>
                <br>
            </div>
        <?PHP } ?>
    <?PHP } ?>
    <br>

<section class="banner-statistics-right">
        <div class="container">
            <div class="row">
                <?PHP

$HomeID = '88';
                $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 LIMIT 8
";

$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 LIMIT 1								
";
                    $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;
                    }

?>
                    <div class="col-md-3">
                        <a href="product.php">
                            <?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"];
                                    ?>
                                <img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="<?= $Check_HomeSub2; ?>" style="padding: 10px;">
                            <?PHP } ?>
                        </a>
                    </div>
                <?PHP } ?>
            </div>
        </div>
    </section>

<section class="new-product section-space">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <div class="section-title text-center">
                        <h2>สินค้า</h2>
                        <span>T.R.P. TOTAL SUPPLY CO.,LTD.</span>
                    </div>
                </div>
            </div>
            <div class="row mtn-40">

<?PHP

$HomeID = '84';
                $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 LIMIT 8
";

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

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

$MemberNameEN = $objResult_Home["Member_NameEN"];

// 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 LIMIT 1								
";
                    $objQuery_Home_Img = $objConnect->query($SQL_Home_Img);

?>
                    <div class="col-12 col-md-3">
                        <div class="product-item mt-40">
                            <div style="text-align: center;">
                                <a href="product_detail.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>">
                                    <?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"];
                                            ?>
                                        <img class="pri-img" src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="<?= $Check_HomeSub2; ?>" style="border-radius: 5px;object-fit: cover;height: 270px;border: 3px solid #ddaa44;">
                                    <?PHP } ?>
                                </a>
                            </div>
                            <div class="product-caption">
                                <p class="product-name">
                                    <a href="product_detail.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>" style="font-weight: 700;"><?= $Check_HomeSub2; ?></a>
                                </p>
                                <div class="price-box">
                                    <span class="price-regular" style="font-size: 13px;line-height: 0;"><?= $Check_HomeShort3; ?></span>
                                </div>
                            </div>
                        </div>
                    </div>
                <?PHP } ?>

<div class="col-12">
                    <div class="view-more-btn">
                        <a class="btn-hero btn-load-more" href="product.php">สินค้าเพิ่มเติม</a>
                    </div>
                </div>
            </div>
        </div>
    </section>

<?PHP

$HomeID = '90';
    $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");

// พากหัว หลัก
        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"];
                ?>

<section class="banner-statistics" style="background-image: url(model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>);background-size: contain;padding-top: 320px;">

</div>
                        </div>
                    </div>
                </div>
            </section>
        <?PHP } ?>
    <?PHP } ?>
    <br>
    
    <section class="latest-news section-space pt-0" style="background: #fbfafa;padding-top: 80px!important;">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <div class="section-title text-center">
                        <h2>ความรู้ทั่วไป</h2>
                        <span>T.R.P. TOTAL SUPPLY CO.,LTD.</span>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-12">
                    <div class="latest-blog-carousel slick-arrow-style slick-row-15">
                        
                        <?PHP

$HomeID = '85';
                        $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 LIMIT 1								
";
                            $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;
                            }

?>
                            <div class="blog-post-item">
                                <div class="blog-post-thumb">
                                    <a href="blog_detail.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>">
                                        <?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"];
                                                ?>
                                            <img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="<?= $Check_HomeSub2; ?>" style="object-fit: cover;height: 250px;border-radius: 10px;width: 370px;">
                                        <?PHP } ?>
                                    </a>
                                    <div class="post-date">
                                        <p class="date"><?= $NewDate1; ?></p>
                                        <p class="month"><?= $NewDate2; ?></p>
                                    </div>
                                </div>
                                <div class="post-info-wrapper">
                                    <div class="entry-header">
                                        <h2 class="entry-title">
                                            <a href="blog_detail.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><?= $Check_HomeSub2; ?></a>
                                        </h2>
                                    </div>
                                    <div class="entry-summary">
                                        <p><?= $Check_HomeShort2; ?>
                                        </p>
                                    </div>
                                    <a href="blog_detail.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>" class="btn-read">อ่านต่อ...</a>
                                </div>
                            </div>
                        <?PHP } ?>

</div>
                </div>
            </div>
        </div>
    </section>

</main>

${this.title}

Code Editor : detail.php