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 : category.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 (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.ProductCategory_img,
        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"];
    $ProductCategoryIMG = $objResult_category["ProductCategory_img"];

.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">
                <ul>
                    <li><a href="index.php">Home</a></li>
                    <?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"];

?>
                        <li><a href="product.php?c1=<?= $ProductCategoryID; ?>"><?= $ProductCategoryName; ?></a></li>
                    <?PHP } ?>
                </ul>
                <h4><?= $ProductCategory2Name; ?></h4>
            </div>
        </div>
    </section>
<?PHP } ?>
<section class="feature_content" style="padding: 60px 0px;background: #f1f1f1;">
    <div class="container">
        <div class="row">

<?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  = "0";
            } 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, '.', ',');

$sql_img_list = "
    SELECT ProductImg_ID , Product_ID , ProductImg_Name , ProductImg_Date , ProductImg_Time
    ProductImg_Sort , ProductImg_Status
    FROM product_img
    WHERE Product_ID = '$ProductID'
    ";
                $objQuery_imglist = $objConnect->query($sql_img_list);
                $objQuery_imglist2 = $objConnect->query($sql_img_list);
                $CHK_imglist = mysqli_num_rows($objQuery_imglist);

?>
                <div class="col-12 col-md-3">

<a href="product_detail.php?ID=<?= $ProductID; ?>&N=<?= $ProductName; ?>">
                        <div class="card shadow p-3 mb-5 bg-white rounded" style="width: 100%;">
                            <img src="model/upload/img/IMGProduct/<?= $objResult_Product["Product_Img"]; ?>" class="card-img-top" alt="<?= $ProductName; ?>">
                            <div class="card-body" style="padding: 2%;background: #0b53a1;">
                                <p class="card-text text_index2"><?= $ProductName; ?>.</p>
                            </div>
                        </div>
                    </a>

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

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

${this.title}

Code Editor : category.php