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

<?PHP
include '1Head.php';
include '2HeadMenu.php';
include '2banner.php';
?>
<style>
  .post {
    position: relative;
    overflow: hidden;
    height: 440px;
}
</style>
<?PHP

if (empty($_GET['c1'])) {
  $category  = "";
} else {
  $category = trim($_GET['c1']);
}

if (empty($_GET['c2'])) {
  $category2  = "";
} else {
  $category2 = trim($_GET['c2']);
}

if ($category == 0) {
  $Chk_SQL = "";
} else {
  $Chk_SQL = "AND product_category2.ProductCategory2_ID = $category2";
}

$SQL_Category = "

SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name, 
					product_category.StatusProductCategory_ID, product_category2.ProductCategory2_ID,
					product_category2.StatusProductCategory2_ID, product_category2.ProductCategory2_IMG,
					product_category2.ProductCategory2_Name, product_category2.ProductCategory2_img , product_category2.ProductCategory2_Detail
					FROM product_category2 INNER JOIN product_category 
					ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
					WHERE product_category2.StatusProductCategory2_ID = 1 $Chk_SQL 
					ORDER BY product_category.ProductCategory_ID

";
$objQuery_Category = $objConnect->query($SQL_Category);
while ($objResult_category = mysqli_fetch_array($objQuery_Category)) {

$ProductCategory2ID = $objResult_category["ProductCategory2_ID"];
  $ProductCategory2Name = $objResult_category["ProductCategory2_Name"];
  $ProductCategory2Detail = $objResult_category["ProductCategory2_Detail"];
  $ProductCategory2IMG = $objResult_category["ProductCategory2_img"];
  $ProductCategory2ID = $objResult_category["ProductCategory2_ID"];

?>
  <section style="background: #ebebeb;">
    <div class="container" style="padding-top: 0px;padding-bottom: 120px;padding: 40px;">
      
      <div class="section-content">
        <div class="row">
          <div class="col-md-12">
            <h2 class="title text-white" style="color: #0b1592!important;font-size: 33px;font-weight: 600;"><?= $ProductCategory2Name; ?></h2>
            <hr style="border-bottom: 4px solid #FF9800;">
           
            <div class="text_res">
              <?= $ProductCategory2Detail; ?>
            </div>
          </div>
        </div>
      </div>
    </div>
  </section>

<?PHP } ?>

<?PHP

if (empty($_GET['c1'])) {
          $category  = "";
        } else {
          $category = trim($_GET['c1']);
        }

if (empty($_GET['c2'])) {
          $category2  = "";
        } else {
          $category2 = trim($_GET['c2']);
        }

if (empty($_GET['c3'])) {
          $category3  = "";
        } else {
          $category3 = trim($_GET['c3']);
        }

if ($category == 0) {
          $category1 = "";
        } else {
          $category1 = "AND product.ProductCategory_ID = $category";
        }

if ($category2 == 0) {
          $category2 = "";
        } else {
          $category2 = "AND product.ProductCategory2_ID = $category2";
        }

if ($category3 == 0) {
          $category3 = "";
        } else {
          $category3 = "AND product.ProductCategory3_ID = $category3";
        }

//echo $category;

$Str_SQL = "
SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name, product.ProductCategory2_ID, product_category2.ProductCategory2_Name,product.ProductCategory2_ID,
 product.ProductCategory3_ID, product_category3.ProductCategory3_Name, product.StatusProduct_ID, status_product.StatusProduct_Name, product.Member_ID, status_product.StatusProduct_Name, product.Member_ID, member.Member_NameEN, member.Position_ID, position.Position_Name, product.Product_Name, product.Product_Num, product.Product_Unit, product.Product_Price, product.Product_Detail, product.Product_PVScore, product.Product_Img, product.Product_Time, product.Product_Date, product.Product_Visitors, product.Product_Detail2, product.Product_Detail3, product.Product_Color
FROM product_category3 INNER JOIN (product_category2 INNER JOIN (product_category INNER JOIN (status_product INNER JOIN (product INNER JOIN (position INNER JOIN member ON position.Position_ID = member.Position_ID) ON product.Member_ID = member.Member_ID) ON status_product.StatusProduct_ID = product.StatusProduct_ID) ON product_category.ProductCategory_ID = product.ProductCategory_ID) ON product_category2.ProductCategory2_ID = product.ProductCategory2_ID) ON product_category3.ProductCategory3_ID = product.ProductCategory3_ID
WHERE product.StatusProduct_ID = 1 $category1 $category2 $category3
ORDER BY product.Product_ID DESC
";
        $objQuery = $objConnect->query($Str_SQL);

<?PHP

while ($objResult_Product = mysqli_fetch_array($objQuery)) {
          $objResult_ProductName1 = $objResult_Product["ProductCategory_Name"];
          $objResult_ProductName = $objResult_Product["ProductCategory2_Name"];
          $ProductCategory2ID = $objResult_Product["ProductCategory2_ID"];
          $ProductName = $objResult_Product["Product_Name"];
          $ProductPrice = $objResult_Product["Product_Price"];
          $ProductDetail3 = $objResult_Product["Product_Detail3"];
          $ProductDetail = $objResult_Product["Product_Detail"];
          $ProductID = $objResult_Product["Product_ID"];
          $NewformatProductPrice =  number_format((float) $ProductPrice, 2, '.', ',');
        ?>
          <div class="col-xs-12 col-sm-6 col-md-4" style="padding: 10px;">
            <article class="post clearfix mb-sm-30" style="-webkit-box-shadow: 0px 0px 5px 0px rgba(0,0,0,0.75);-moz-box-shadow: 0px 0px 11px 0px rgba(0,0,0,0.75);box-shadow: 0px 0px 11px 0px rgba(0,0,0,0.75);">
              <div class="entry-header">
                <div class="post-thumb thumb">
                  <a href="shool.php?ID=<?= $ProductID; ?>&N=<?= $ProductName; ?>"><img src="model/upload/img/IMGProduct/<?= $objResult_Product["Product_Img"]; ?>" alt="" 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" style="font-weight: 600;font-size: 20px;"><a href="shool.php?ID=<?= $ProductID; ?>&N=<?= $ProductName; ?>"><?= $ProductName; ?></a></h4>
                      <br>
                    </div>
                  </div>
                </div>
                <div class="text_res22" style="display: -webkit-box;-webkit-line-clamp: 3;-webkit-box-orient: vertical;overflow: hidden;">
                <?= $ProductDetail; ?>
                </div>
                <div class="clearfix"></div>
              </div>
            </article>
          </div>
        <?PHP } ?>

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

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

${this.title}

Code Editor : city.php