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

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

<section id="blog" class="bg-lighter" style="background-color: #fff  !important;padding: 50px;">
  <div class="container" style="background: #fff;padding: 40px;">
    <div class="section-title mb-10">
      <div class="row" style="border-bottom: 4px solid #FF9800;">
        <div class="col-md-10">
          <h2 style="font-weight: 600;color: #0b1592;">ข้อมูลทั่วไป</h2>
        </div>
      </div>
    </div>
    <div class="section-content">
      <div class="row">
        <?PHP

$HomeID = '114';

$SQL_Home_ALL = "
        SELECT home.Home_ID, home.StatusHome_ID, home.StatusShowPage_ID          
        FROM home
        WHERE home.StatusHome_ID = 1 AND home.StatusShowPage_ID = '$HomeID'
        ORDER BY home.Home_ID DESC
        ";
      $objQuery_Home_All = $objConnect->query($SQL_Home_ALL);
      $Num_Home_ALL = mysqli_num_rows($objQuery_Home_All);

if (isset($_GET['offset'])) {
        $CHK_offset = trim($_GET['offset']);
      } else {
        $CHK_offset = 0;
      }
      $CHK_limit = 12;
      $result_previous = $CHK_offset - 3;
      $result_next = $CHK_offset + 3;
      $result = $Num_Home_ALL / $CHK_limit;
      $CHK_round_up =  floor($result);

$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 $CHK_limit OFFSET $CHK_offset
          ";

// $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 9
    // ";

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

$i=0;
        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"];
          $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");

// 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-6 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_promotion.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><img src="model/upload/img/IMG_Home/<?= $HomeImg_Img; ?>" alt="<?= $Check_HomeSub2; ?>" class="img-responsive img-fullwidth"> </a>
                  </div>
                </div>
                <div class="entry-content p-20 pr-10 bg-white">
                  <div class="entry-meta media mt-0 no-bg no-border">
                    <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_promotion.php?id=<?= $HomeID; ?>&s=<?= $StatusShowPageID; ?>"><?= $Check_HomeSub2; ?></a></h4>
                      </div>
                    </div>
                  </div>

<?PHP } ?>

<?PHP

if(isMobile()){
  
  if($i==2){
    $i=0;
    echo '</div> <div class="row">';
  }

}else{
 
  if($i==3){
    $i=0;
    echo '</div> <div class="row">';
  }

}

//echo $i;
?>

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

<div class="text-center">
      <nav>
        <ul class="pagination">
          <li><a href="tip.php?offset=<?= $result_previous; ?>" aria-label="Previous"><span aria-hidden="true">«</span></a></li>      
          <?PHP
          for ($x = 0; $x <= $CHK_round_up; $x += 1) {
            $result_page = $x * $CHK_limit;
            //  echo   'result_page = '.$result_page;
          ?>
            <li class="  <?PHP echo ($CHK_offset == $result_page ? 'active' : ''); ?>  ">
              <a href="tip.php?offset=<?= $result_page; ?>"><?= $x + 1; ?></a>
            </li>
          <?PHP } ?>
          <li><a href="tip.php?offset=<?= $result_next; ?>" aria-label="Next"><span aria-hidden="true">»</span></a></li>
        </ul>
      </nav>
    </div>

</div>
</section>

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

${this.title}

Code Editor : tip.php