product_filter.php

<?php include("../includes/config.php");

$main_id = $_POST['main_id'];
    $sub_id = $_POST['sub_id'];

if(isset($_POST['main_id']))
    {
        if($_POST['main_id']!='')
        {
          $sql = mysqli_query($conn,"SELECT * FROM iv_shop_products WHERE iv_shop_products_cat_id = '$main_id' ORDER BY iv_shop_products_id ");  
        }
        else
        {
            $sql = mysqli_query($conn,"SELECT * FROM iv_shop_products ORDER BY iv_shop_products_id ");  
        }
        
    }

else if(isset($_POST['sub_id']))
    {
        if($_POST['sub_id']!='')
        {
         $sql = mysqli_query($conn,"SELECT * FROM iv_shop_products WHERE iv_shop_products_sub_cat_id = '$sub_id' ORDER BY iv_shop_products_id "); 
        }
        else
        {
             $sql = mysqli_query($conn,"SELECT * FROM iv_shop_products ORDER BY iv_shop_products_id "); 
        }
        
    }

$count = mysqli_num_rows($sql);
    // echo "SELECT * FROM iv_shop_products WHERE iv_shop_products_sub_cat_id = '$sub_id' ORDER BY iv_shop_products_id "; exit;

if($count==0) echo "<div class='alert alert-danger w-100 text-center'>No Products Found</div>";

else

{

$card = "";

while($row = mysqli_fetch_array($sql))

{
            $i = $row['iv_shop_products_id'];
            $dd = explode(',',$row['iv_shop_products_var_image']);
?>
		 <div class="col-lg-3 col-md-4 col-sm-6 mb-3">
                        <div class="card">
                            <div class="card-header text-center bg-warning"><?php echo $row['iv_shop_products_name']; ?>
                            </div>
                            <div class="card-body">
                                <a href="product_details.php?pro_id=<?php echo $row['iv_shop_products_id'] ?>"><img
                                        src="assets/images/shopping/products/<?php print_r($dd[0]); ?>" alt="<?php print_r($dd[0]); ?>"
                                        width="100%" height="150px"></a>
                            </div>
                            <div class="card-footer">
                                <a href="product_details.php?pro_id=<?php echo $row['iv_shop_products_id'] ?>">
                                <div class="d-flex flex-row justify-content-between">
                                <p><b class="greenlable"> (Price) : </b><?php echo $row['iv_shop_products_price']; ?> Rs.</p>
                                <?php
                                $pro_id = $row['iv_shop_products_id'];
                                $wish_query = mysqli_query($conn,"SELECT * FROM iv_shopping_wishlist WHERE user_id='$user_id' AND product_id='$pro_id'");
                                $count = mysqli_num_rows($wish_query);
                                if($count<=0)
                                {
                                ?>
                                <a href="includes/add_wishlist.php?pro_id=<?php echo $row['iv_shop_products_id'] ?>"> 
                                    <i class="fa fa-heart mt-1" title="add to wishlist"></i></a>
                                <?php
                                } else {
                                ?>
                                <a href="includes/add_wishlist.php?pro_id=<?php echo $row['iv_shop_products_id'] ?>"> 
                                <i class="fa fa-heart mt-1 text-danger" title="added to wishlist"></i></a>
                                <?php
                                }
                                ?>
                                </div>
                                    <p><b class="greenlable"> (Stock) : </b><?php echo $row['iv_shop_products_stock']; ?></p>
                                    <p><b class="greenlable"> (Description) : </b>
                                            <?php $myString = $row['iv_shop_products_des'];
                                            if (strlen($myString) > 243) {
                                            echo substr($myString, 0, 243) . '...';
                                             } else {
                                            echo $myString;
                                            }
                                            ?>
                                    </p>                                </a>
                                <div class="d-flex">
                                    <a href="product_details.php?pro_id=<?php echo $row['iv_shop_products_id'] ?>"
                                        class="genric-btn btn-warning mt-3">View Product <i class="fa fa-eye"></i></a>
                                </div>
                            </div>
                        </div>
                    </div>
    <?php
		}

}

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/ajax

	.	4096
	..	4096
	chats	27
	download	99
	event_search	41
	gallery_images	51
	gallery_videos	51
	officer_search	61
X	product_cat.php	509
X	product_filter.php	4906
	temple_search	85
X	test_results.php	1705
X	update_quantity.php	1608