<?php
    //get rows query
    $query = $db->query("SELECT pd.Product_Details_ID,pd.Slide_Photos,pd.rate,pm.Product_Name,pm.Product_ID,pm.gender from product_details as pd INNER JOIN product_master as pm ON pd.Product_ID=pm.Product_ID where pm.gender='$gender' ");
    if($query->num_rows > 0){
        while($row = $query->fetch_assoc()){
           // $str = $row["Product_Details_ID"];

       // print_r($row);exit;

            /*
            $Product_Details_ID = $row["Product_Details_ID"];
            $productname= $row["Product_Name"];
            $rate = $row["rate"]
            $Product_ID = $row["Product_ID"];


            $_SESSION['Product_Details_ID'] = $Product_Details_ID;
            $_SESSION['Product_ID']= $Product_ID;
            $_SESSION['Product_Name']=$productname;
            $_SESSION['rate']=$rate;*/
    ?>

                        <!--1st div1 -->


             <div class="col-sm-4 ">
                                <div class="productBox">
                                    <div class="productImage clearfix">
                                        <img src="<?php echo $row["Slide_Photos"]; ?>" alt="products-img">
                                        <div class="productMasking">
                                            <ul class="list-inline btn-group" role="group">
                                                <li><a class="btn btn-default btn-wishlist"><i class="fa fa-heart-o"></i></a></li>




                                                <li><a href="temp.php?action=addToCart&Product_Details_ID=<?php echo $row["Product_Details_ID"]; ?>&gender=<?php echo $row["gender"]; ?>" class="btn btn-default" data-toast data-toast-type="success" data-toast-position="topRight" data-toast-icon="icon-circle-check" data-toast-title="Product" data-toast-message="successfuly added to cart!" class="btn btn-default"   onclick="alert('product added successfully.')"><i class="fa fa-shopping-basket"></i></a></li>




                                                <li><a class="btn btn-default" href="product_info.php?Product_Details_ID=<?php echo $row["Product_Details_ID"]; ?>"><i class="fa fa-eye"></i></a></li>
                                            </ul>
                                        </div>
                                    </div>
                                    <div class="productCaption clearfix">
                                        <a href="single-product.html">
                                            <h5><?php echo $row['Product_Name']; ?> <?php echo $row["Product_Details_ID"]; ?></h5>
                                        </a>
                                        <h3><?php echo $row["rate"]; ?></h3>
                                    </div>
                                </div>
                            </div>


                          <?php } }else{ ?>
    <p>Product(s) not found.....</p>
    <?php } ?>