Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
test	[ DIR ]	drwxr-xr-x
.htaccess	495 B	-rwxr-xr-x
1Head.php	7.36 KB	-rwxr-xr-x
2HeadMenu.php	2.36 KB	-rwxr-xr-x
3Footer.php	8.95 KB	-rwxr-xr-x
4End.php	1.52 KB	-rwxr-xr-x
about.php	6.79 KB	-rwxr-xr-x
contact.php	5.99 KB	-rwxr-xr-x
detail.php	33.98 KB	-rwxr-xr-x
gallery.php	6.12 KB	-rwxr-xr-x
googlef0da6945598bd8e7.html	53 B	-rwxr-xr-x
index.php	142 B	-rwxr-xr-x
news.php	5.83 KB	-rwxr-xr-x
news_detail.php	4.31 KB	-rwxr-xr-x
service.php	5.88 KB	-rwxr-xr-x
service_detail.php	4.55 KB	-rwxr-xr-x

Code Editor : news.php

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

<section class="page-title-area">
            <div class="container">
                <h1>บทความ</h1>
                <ul>
                    <li><a href="index.php"><i class="flaticon-grid"></i> หน้าแรก</a></li>
                    <li>บทความ</li>
                </ul>
            </div>
        </section>

<section class="blog-area ptb-100">
            <div class="container">
                <div class="row">
                <?PHP

$HomeID = '76';
$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"];
    $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;
    }

?>
    <?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-lg-4 col-md-6">
                        <div class="single-blog-post-box">
                            <div class="blog-image">
                                <a href="news_detail.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="ชีทไพล์ ตอกชีทไพล์ เบลสซิ่ง ระบบป้องกันดินพัง <?= $Check_HomeSub2; ?>" style="height: 200px;width: 100%;object-fit: cover;"></a>
                            </div>

<h3><a href="news_detail.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><?= $Check_HomeSub2; ?></a></h3>
                                <ul class="post-meta">
                                    <li><i class="flaticon-user-1"></i> <a>Admin</a></li>
                                    <li><i class="flaticon-calendar"></i> <a><?= $NewDate; ?></a></li>
                                </ul>
                                <p style="display: -webkit-box;-webkit-line-clamp: 4;-webkit-box-orient: vertical;overflow: hidden"><?= $Check_HomeShort2; ?></p>
                            </div>
                        </div>
                    </div>
                    <?PHP } ?>
                <?PHP } ?>

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

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

${this.title}

Code Editor : news.php