category_search.php

<?php 
    define('Access', TRUE);
    include "./AdditionalPHP/startSession.php";




    // <!--========== PHP CONNECTION TO DATABASE: MALAKO ==========-->
    
        include_once 'connection.php';
        include_once 'numOfItemsInCart.php';




        // <!--========== PHP FETCH PRODUCT DETAILS ==========-->

        
        
        $cat_id= $_REQUEST['cat_id'];
        // $Q_fetch_product_by_cat_id = "SELECT * FROM products WHERE categoryID = '$cat_id' ; ";
        
        $Q_fetch_product_by_cat_id = "SELECT * FROM products INNER JOIN product_category ON products.productID = product_category.productID WHERE product_category.categoryID = '$cat_id'";




            $run_get_product_by_cat_id = mysqli_query($conn, $Q_fetch_product_by_cat_id); 
            while($row_product = mysqli_fetch_assoc($run_get_product_by_cat_id)){
                $product_id = $row_product['productID'];
                

                    echo ' <div class="featured__products" id="product__card">
                                <div class="featured__box">
                                    <div class="featured__new">NEW</div>
                                    <div class=""><a href="product.php?product_id='. $product_id.' "><i class="bx bxs-cart-add bx-tada-hover featured__new_cart"></i></a></div>
                                    <a href="product.php?product_id='. $product_id.' " >
                                                <img src=" '. $row_product['p_img'].' " alt="" class="featured__img avoid__clicks"
                                                style="
                                                    object-fit: cover;
                                                    width:  232px;
                                                    height: 232px;" />
                                            </a>
                                </div>

                            <div class="featured__data">';
                    $product_id = $row_product['productID'];
                    echo '<a href="product.php?product_id='.$product_id.' " class="product__name" id="product__name"style="text-decoration: none;">'. $row_product['p_name'].'</a></br>
                            <span class="featured__price">Rs '. $row_product['p_price'].'</span>
                                
                            </div>
                            </div>';

                
            }

                ?>