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

<?PHP
include '1Head.php';
include '2HeadMenu.php';
?>

<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="blog-main-wrapper section-space pb-0">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <div class="blog-item-wrapper">
                        <div class="row mbn-30">

<?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="col-lg-4 col-md-6 col-sm-6">
                                    <div class="blog-post-item mb-30">
                                        <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="height: 250px;    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>
                                </div>
                            <?PHP } ?>

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

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

${this.title}

Code Editor : blog.php