Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
api	[ DIR ]	drwxr-xr-x
backup	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
css2	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
js2	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
scss	[ DIR ]	drwxr-xr-x
test	[ DIR ]	drwxr-xr-x
vendors	[ DIR ]	drwxr-xr-x
1Head.php	5.45 KB	-rwxr-xr-x
2HeadMenu - Copy.php	11.01 KB	-rwxr-xr-x
2HeadMenu.php	12.77 KB	-rwxr-xr-x
2banner.php	4.95 KB	-rwxr-xr-x
3Footer.php	13.11 KB	-rwxr-xr-x
4End.php	1.1 KB	-rwxr-xr-x
BBservice.php	3.2 KB	-rwxr-xr-x
Category_Machine.php	6.3 KB	-rwxr-xr-x
about_us.php	4.36 KB	-rwxr-xr-x
category.php	9.26 KB	-rwxr-xr-x
contact.php	3.87 KB	-rwxr-xr-x
detail.php	16.75 KB	-rwxr-xr-x
index.php	181 B	-rwxr-xr-x
portfolio.php	3.41 KB	-rwxr-xr-x
product.php	7.66 KB	-rwxr-xr-x
product_detail.php	9.74 KB	-rwxr-xr-x
service.php	3.51 KB	-rwxr-xr-x

Code Editor : product.php

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

.card {
        border: 1px solid #ffffff;
    }
</style>

<?PHP

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

if ($category == 0) {
    $Chk_SQL = "";
} else {
    $Chk_SQL = "AND product_category.ProductCategory_ID = $category";
}

$SQL_Category = "
SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name,
product_category.StatusProductCategory_ID, status_productcategory.StatusProductCategory_Name,product_category.ProductCategory_img , product_category.ProductCategory_Detail
FROM status_productcategory INNER JOIN product_category ON status_productcategory.StatusProductCategory_ID 
= product_category.StatusProductCategory_ID
WHERE product_category.StatusProductCategory_ID = 1 $Chk_SQL 
ORDER BY product_category.ProductCategory_ID LIMIT 1
    ";
$objQuery_Category = $objConnect->query($SQL_Category);
while ($objResult_category = mysqli_fetch_array($objQuery_Category)) {

$ProductCategoryID = $objResult_category["ProductCategory_ID"];
    $ProductCategoryName = $objResult_category["ProductCategory_Name"];
    $ProductCategoryDetail = $objResult_category["ProductCategory_Detail"];
    $ProductCategoryIMG = $objResult_category["ProductCategory_img"];
    $ProductCategoryID = $objResult_category["ProductCategory_ID"];

if($ProductCategoryDetail == "<p>-</p>"){
        $ProductCategoryDetail = "";
    }else{
        $ProductCategoryDetail = $objResult_category["ProductCategory_Detail"];
    }

.banner_area_<?= $ProductCategoryID; ?>:before {
            content: "";
            background: rgba(30, 33, 38, 0.5);
            position: absolute;
            left: 0px;
            top: 0px;
            width: 100%;
            height: 100%;
            z-index: -1;
        }
    </style>

<section class="banner_area_<?= $ProductCategoryID; ?>" style="">
        <div class="container">
            <div class="banner_inner_text">
                <h4><?= $ProductCategoryName; ?></h4>
                <?= $ProductCategoryDetail; ?>
            </div>
        </div>
    </section>
<?PHP } ?>
<section class="feature_content">
    <div class="container">
        <div class="row">
            <?PHP

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

if ($category == 0) {
                $Chk_SQL = "";
            } else {
                $Chk_SQL = "AND product_category.ProductCategory_ID = $category";
            }

$SQL_Category = "
SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name,
product_category.StatusProductCategory_ID, status_productcategory.StatusProductCategory_Name,product_category.ProductCategory_img , product_category.ProductCategory_Detail
FROM status_productcategory INNER JOIN product_category ON status_productcategory.StatusProductCategory_ID 
= product_category.StatusProductCategory_ID
WHERE product_category.StatusProductCategory_ID = 1 $Chk_SQL 
ORDER BY product_category.ProductCategory_ID
    ";
            $objQuery_Category = $objConnect->query($SQL_Category);
            while ($objResult_category = mysqli_fetch_array($objQuery_Category)) {

$ProductCategoryID = $objResult_category["ProductCategory_ID"];
                $ProductCategoryName = $objResult_category["ProductCategory_Name"];
                $ProductCategoryDetail = $objResult_category["ProductCategory_Detail"];
                $ProductCategoryIMG = $objResult_category["ProductCategory_img"];
                $ProductCategoryID = $objResult_category["ProductCategory_ID"];

$SQL_Category2 = "
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
FROM product_category2 INNER JOIN product_category 
ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
WHERE product_category2.StatusProductCategory2_ID = 1 AND
product_category.ProductCategory_ID = $ProductCategoryID
ORDER BY product_category.ProductCategory_ID
";
                $objQuery_Category2 = $objConnect->query($SQL_Category2);

?>
                <?PHP
                while ($objResult_category2 = mysqli_fetch_array($objQuery_Category2)) {
                    $ProductCategoryID = $objResult_category2["ProductCategory_ID"];
                    $ProductCategoryID2 = $objResult_category2["ProductCategory2_ID"];
                    $ProductCategoryName2 = $objResult_category2["ProductCategory2_Name"];
                    $ProductCategoryIMG2 = $objResult_category2["ProductCategory2_IMG"];

if ($ProductCategory2_ahref_status == 2) {
                        $chk_ahref_status =  $ProductCategory2_ahref_name;
                    } else {
                        $chk_ahref_status = "category.php?c1=" . $ProductCategoryID . "&c2=" . $ProductCategoryID2;
                    }
                ?>

<a href="category.php?c1=<?= $ProductCategoryID; ?>&c2=<?= $ProductCategoryID2; ?>">
                            <div class="card shadow p-3 mb-5 bg-white rounded" style="width: 100%;height: 300px;">
                                <img src="model/upload/img/IMG_Category/<?= $ProductCategoryIMG2; ?>" class="card-img-top" alt="<?= $ProductCategoryName2; ?>" style="height: 220px;object-fit: contain;">
                                <div class="card-body" style="background: #dddfe1;padding: 5px;border-radius: 2px;">
                                    <p class="card-text text_index2"><?= $ProductCategoryName2; ?>.</p>
                                </div>
                            </div>
                        </a>

</div>

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

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

${this.title}

Code Editor : product.php