Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
UserFiles	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
1Head.php	8.88 KB	-rw-r--r--
2HeadMenu.php	2.27 KB	-rw-r--r--
2banner.php	105 B	-rw-r--r--
2banner_mo.php	9.16 KB	-rw-r--r--
2banner_pc.php	3.81 KB	-rw-r--r--
3Footer.php	227 B	-rw-r--r--
4End.php	1.39 KB	-rw-r--r--
about.php	3.46 KB	-rw-r--r--
banner_next_country.php	3.1 KB	-rw-r--r--
banner_next_student_reviews.ph...	3.13 KB	-rw-r--r--
call_contact_mo.php	16.06 KB	-rw-r--r--
call_contact_pc.php	4.2 KB	-rw-r--r--
city.php	7.28 KB	-rw-r--r--
contact.php	5.92 KB	-rw-r--r--
country.php	5.72 KB	-rw-r--r--
detail.php	284 B	-rw-r--r--
detail_gallery.php	4.28 KB	-rw-r--r--
detail_mo.php	39.4 KB	-rw-r--r--
detail_promotion.php	3.01 KB	-rw-r--r--
detail_student_reviews.php	2.89 KB	-rw-r--r--
detail_tip.php	3.56 KB	-rw-r--r--
footer_mo.php	6.66 KB	-rw-r--r--
footer_pc.php	6.79 KB	-rw-r--r--
gallery.php	7.37 KB	-rw-r--r--
head_footer_3.php	3.59 KB	-rw-r--r--
hotpromotion.php	6.83 KB	-rw-r--r--
index.php	171 B	-rw-r--r--
index_country.php	121 B	-rw-r--r--
index_country_mo.php	4.38 KB	-rw-r--r--
index_country_pc.php	4 KB	-rw-r--r--
index_gallery.php	9.77 KB	-rw-r--r--
index_hot_promotion.php	9.2 KB	-rw-r--r--
index_student_reviews.php	9.87 KB	-rw-r--r--
index_video.php	4.54 KB	-rw-r--r--
shool.php	4.71 KB	-rw-r--r--
student_reviews.php	6.77 KB	-rw-r--r--
tip.php	7.84 KB	-rw-r--r--

Code Editor : index_student_reviews.php

<section id="blog" class="bg-lighter" style="background-color: #ef8332  !important;padding-top: 50px;padding-bottom: 50px;">
  <div class="container" style="background: #fff;padding: 20px;">
    <div class="section-title mb-10">
      <div class="row" style="border-bottom: 4px solid #FF9800;">
        <div class="col-xs-10 col-sm-10 col-md-10">
          <h2 style="font-weight: 600;color: #0b1592;">Student Reviews</h2>
        </div>
        <div class="col-xs-2 col-sm-2 col-md-2" style="margin-top: 20px;">
          <a href="student_reviews.php">
            <h2 style="font-size: 18px;color: #0b1592;font-weight: 600;">อ่านทั้งหมด</h2>
          </a>
        </div>
      </div>
    </div>
    <div class="section-content">

<div class="row">
        <?PHP

$HomeID = '107';

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

$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"];
          $Home_Visitors = $objResult_Home["Home_Visitors"];
          $date = date_create($HomeDate);
          $NewDate = date_format($date, "F d , Y");
          $NewDate1 = date_format($date, "d");
          $NewDate2 = date_format($date, "F");

$HomeID_LIMIT1 = $HomeID;

// 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-xs-12 col-sm-12 col-md-4" style="padding: 10px;">
              <article class="post clearfix mb-sm-30">
                <div class="entry-header">
                  <div class="post-thumb thumb">
                    <a href="detail_student_reviews.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="<?= $Check_HomeSub2; ?>" class="img-responsive img-fullwidth img_pc_index img_mo2_index"> </a>
                  </div>
                </div>
                <div class="entry-content bg-white">
                  <div class="entry-meta media mt-0 no-bg no-border"  style="height: 75px;text-overflow: ellipsis;overflow: hidden;">
                    <div class="media-body pl-15">
                      <div class="event-content pull-left flip" >
                        <h4 class="entry-title text-white text-uppercase m-0 mt-5"><a href="detail_student_reviews.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><?= $Check_HomeSub2; ?></a></h4>
                        <p class="mt-10"><?= $Check_HomeShort2; ?></p>
                      </div>
                    </div>
                  </div>

<?PHP

$HomeID = '107';

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

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

$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-xs-12 col-sm-6 col-md-4" style="padding: 10px;">
              <article class="post clearfix mb-sm-30">
                <div class="entry-header">
                  <div class="post-thumb thumb">
                    <a href="detail_student_reviews.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="<?= $Check_HomeSub2; ?>" class="img-responsive img-fullwidth img_pc_index img_mo2_index"> </a>
                  </div>
                </div>
                <div class="entry-content bg-white">
                  <div class="entry-meta media mt-0 no-bg no-border" style="height: 75px;text-overflow: ellipsis;overflow: hidden;">
                    <div class="media-body pl-15">
                      <div class="event-content pull-left flip">
                        <h4 class="entry-title text-white text-uppercase m-0 mt-5"><a href="detail_student_reviews.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><?= $Check_HomeSub2; ?></a></h4>
                        <p class="mt-10"><?= $Check_HomeShort2; ?></p>
                      </div>
                    </div>
                  </div>

</div>

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

${this.title}

Code Editor : index_student_reviews.php