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_Machine.php

<?PHP
		include '1Head.php';	  
		include '2HeadMenu.php';	
		
					
					if ( isset($_GET['ID']) AND isset($_GET['Name']) ) {

$ID = trim($_GET['ID']);					
						$Name = trim($_GET['Name']);					
					}else{
						$ID = "0";						
						$Name = "0";						
					}
				
			
				
				//  $srtingSQL="	
				// SELECT ProductCategory3_ID , ProductCategory_ID  ,ProductCategory2_ID , ProductCategory3_Name	
				// ProductCategory3_Name
				// FROM product_category3
				// WHERE ProductCategory2_ID = $ID
                // ";
                
                $srtingSQL="	
                SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name, product.Product_Date, product.Product_Time, product.Product_PVScore, product.Product_Detail, product.ProductCategory2_ID, product.Member_ID, product.Product_Name, product.Product_Num, product.Product_Unit, product.Product_Price, product.Product_Img, product.StatusProduct_ID, product_category2.ProductCategory2_Name, product.ProductCategory3_ID, product_category3.ProductCategory3_Name
                FROM product_category3 INNER JOIN (product_category2 INNER JOIN (member INNER JOIN (product_category INNER JOIN product ON product_category.ProductCategory_ID = product.ProductCategory_ID) ON member.Member_ID = product.Member_ID) ON product_category2.ProductCategory2_ID = product.ProductCategory2_ID) ON product_category3.ProductCategory3_ID = product.ProductCategory3_ID
                WHERE product.ProductCategory3_ID = $ID AND product.StatusProduct_ID = 1
                ";

$SQL_Category = "
                SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name, product_category2.ProductCategory2_ID, product_category2.ProductCategory2_Name, product_category3.ProductCategory3_ID, product_category3.ProductCategory3_Name
                FROM product_category3 INNER JOIN (product_category2 INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID) ON product_category3.ProductCategory2_ID = product_category2.ProductCategory2_ID
                WHERE product_category3.ProductCategory3_ID = $ID
                ";

$objQuery = $objConnect->query($srtingSQL);                
                $objQuery1 = $objConnect->query($SQL_Category);

$CHK_NUM_objQuery = mysqli_num_rows($objQuery); // คำสั่งตรวจสอบจำนวนสินค้า

while($objResult1 = mysqli_fetch_array($objQuery1)) {

$objResult1_ProductCategoryID = $objResult1["ProductCategory_ID"];	
                    $objResult1_ProductCategoryID2 = $objResult1["ProductCategory2_ID"];	
                    $objResult1_ProductCategoryID3 = $objResult1["ProductCategory3_ID"];

$objResult1_ProductCategoryName = $objResult1["ProductCategory_Name"];	
                    $objResult1_ProductCategoryName2 = $objResult1["ProductCategory2_Name"];	
                }

?>
	
        
        <section class="banner_area" style="background: url(img/002.jpg); background-size: cover">
            <div class="container">
                <div class="banner_inner_text">

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

<section class="feature_content" style="
    background: #f5f5f5;
">
                <div class="container">                  
                    
                <?PHP if($CHK_NUM_objQuery ==0) { // คำสั่งตรวจสอบจำนวนสินค้า ถ้ามีค่าเป็น 0 ให้แสดง ?> 
                    <div class="alert alert-light" role="alert">
                    Product Not Found!
                    </div>
                <?PHP }else{ // คำสั่งตรวจสอบจำนวนสินค้า ถ้ามีค่า ไม่เป็น 0 ให้แสดง ?>

<?PHP
                    while($objResult = mysqli_fetch_array($objQuery)) {
                        $ProductCategory3ID = $objResult["ProductCategory3_ID"];					
                        $ProductCategory3_Name = $objResult["ProductCategory3_Name"];
                        $ProductName = $objResult["Product_Name"];
                        $ProductImg = $objResult["Product_Img"];

$ProductID = $objResult["Product_ID"];
                        $ProductPVScore = $objResult["Product_PVScore"];
                        
                    ?>

<a href="product_detail.php?h=<?=$ProductID;?>&s=<?=$ProductPVScore;?>">
                                <div class="row no-gutters bg-light position-relative shadow-lg p-3 mb-5 bg-white rounded">
                                    <div class="col-md-6 mb-md-0 p-md-4">
                                        <img src="model/upload/img/IMGProduct/<?=$ProductImg;?>" alt="<?=$ProductName;?>" class="w-100" style="height: 100px;">

</div>
                                    <div class="col-md-6 position-static p-4 pl-md-0" style="padding-right: 0!important;padding-top: 10%!important;color: #014c11;
                                ">
                                        <p class="mt-0">MACHINE : <?=$ProductName;?></p>
                                      
                                    </div>
                                </div>
                        </a>

</div>

<?PHP } ?>

</div>
                 <?PHP 
                } // ปีกกา ปิดคำสั่งตรวจสอบจำนวนสินค้า
                 ?>
                </div>
			</section>
			
       
	  
	   <style>
iframe {
    border: none;
    max-width: 100%;
		}	
img {
    max-width: 100%;
	}
	   </style>
	<?PHP	 			 
		include '3Footer.php';	 	
		include '4End.php';	
	?>

${this.title}

Code Editor : Category_Machine.php