1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / ranafurnicos.com / public_html / switch /
Filename : related-products.php
back
<?php

$Infoproduct = "SELECT sub_category_id,category_name FROM `interface_procategories` t1
left join interface_categories t2 on t1.sub_category_id	=t2.category_id
WHERE product_id  = '".$_REQUEST['code']."'";
$resInfoProduct = mysqli_query($conn,$Infoproduct) or die(mysqli_error());
$fetchRealtedcat=mysqli_fetch_assoc($resInfoProduct);





 $Getproduct = "SELECT * FROM `interface_product`

                    LEFT JOIN `interface_product_images` ON `interface_product`.`product_id` = `interface_product_images`.`product_id` 

                    LEFT JOIN `interface_manufactured` ON `interface_product`.`manufactured_id` = `interface_manufactured`.`manufactured_id` 

					LEFT JOIN  `interface_procategories`  ON interface_product.`product_id` = interface_procategories.`product_id`

					LEFT JOIN  `interface_category_discount` ON interface_procategories.`sub_category_id` = interface_category_discount.`category` 												

                    WHERE `interface_procategories`.`sub_category_id`= '" . $fetchRealtedcat['sub_category_id'] . "' and `interface_product`.`product_id`!='".$_REQUEST['code']."' limit 20";
 $resProduct = mysqli_query($conn,$Getproduct) or die(mysqli_error());

						
?>						
<div class="product-related-box single-layout">
                    <div class="biolife-title-box lg-margin-bottom-26px-im">
                       			<img src="assets/images/furnitures.png" style="width:56px;">

                        <span class="subtitle">All the best item for You</span>
                        <h3 class="main-title">Related Products</h3>
                    </div>
                    <ul class="products-list biolife-carousel nav-center-02 nav-none-on-mobile" data-slick='{"rows":1,"arrows":true,"dots":false,"infinite":false,"speed":400,"slidesMargin":0,"slidesToShow":4, "responsive":[{"breakpoint":1200, "settings":{ "slidesToShow": 4}},{"breakpoint":992, "settings":{ "slidesToShow": 3, "slidesMargin":20 }},{"breakpoint":768, "settings":{ "slidesToShow": 1, "slidesMargin":10}}]}'>

<?php while($fetchPro=mysqli_fetch_assoc($resProduct)){
	
	
	

                                                $url = explode('.', $fetchPro['img_1']);



                                                $url[0] = trim($url[0]);



                                                if (file_exists("admin/upload/$url[0].jpg")) {

                                                    $img = 'admin/upload/' . $url[0] . '.jpg';
                                                } else if (file_exists("admin/upload/$url[0].JPG")) {

                                                    $img = 'admin/upload/' . $url[0] . '.JPG';
                                                } else if (file_exists("admin/upload/$url[0].jpeg")) {

                                                    $img = 'admin/upload/' . $url[0] . '.jpeg';
                                                } else if (file_exists("admin/upload/$url[0].JPEG")) {

                                                    $img = 'admin/upload/' . $url[0] . '.JPEG';
                                                } else if (file_exists("admin/upload/$url[0].png")) {

                                                    $img = 'admin/upload/' . $url[0] . '.png';
                                                } else if (file_exists("admin/upload/$url[0].PNG")) {

                                                    $img = 'admin/upload/' . $url[0] . '.PNG';
                                                } else {

                                                    $img = 'admin/upload/default.png';
                                                }	
												
	//product prices
	 $selPrices2 = "SELECT * FROM `interface_price` t1 

	LEFT JOIN  `interface_procategories` t2 ON t1.`product_id` = t2.`product_id`

	LEFT JOIN  `interface_category_discount` t3 ON t2.`sub_category_id` = t3.`category` 														

	WHERE t1.product_id = '" . $fetchPro['product_id'] . "' AND t1.product_price != ''";

	$resPrices2 = mysqli_query($conn,$selPrices2) or die(mysqli_error());

	$dataPrices2 = mysqli_fetch_assoc($resPrices2);
	
	 if ($dataPrices2["category_discount"] != '' and $dataPrices2["discount_status"] == 'Active' and ( $dataPrices2['product_s_price'] == '' or $dataPrices2['product_s_price'] == '0')) {


 $price2 = $dataPrices2["product_price"] - (($dataPrices2["product_price"] * $dataPrices2["category_discount"]) / 100);
                            } else if ($dataPrices2['product_s_price'] > 0) {








                                $price2 = $dataPrices2['product_s_price'];
                            } else {







                                $price2 = $dataPrices2["product_price"];
                            }
	
$pmyname_new6 = str_replace( array(' '),'',$fetchPro['product_name']);
$smyname_new_6 = str_replace( array('%'),'-',$pmyname_new6);
$zmyname_new_7 = str_replace( array('&amp;'),'',$smyname_new_6);
$Main = str_replace( array('-'),'',$zmyname_new_7);
												
?>
                        <li class="product-item relpro">
                            <div class="contain-product layout-default">
                                <div class="product-thumb">
                                    <a href="<?php echo $Main; ?>&amp;code=<?php echo $dataPrices2['product_id']; ?>.html" class="link-to-product">
                                        <img src="<?php echo $img; ?>" alt="dd" width="270" height="270" class="product-thumnail">
                                    </a>
                                </div>
                                <div class="info">
                                    <b class="categories"><?php echo $fetchRealtedcat['category_name'];?></b>
                                    <h4 class="product-title"><a href="<?php echo $Main; ?>&amp;code=<?php echo $dataPrices2['product_id']; ?>.html" class="pr-name"><?php echo $fetchPro['product_name'];?></a></h4>
                                    <div class="price">
                                        <ins><span class="price-amount"><span class="currencySymbol">Rs.</span>  <?php echo $price2; ?></span></ins>
                                        <del><span class="price-amount"><span class="currencySymbol">Rs.</span><?php echo $dataPrices2["product_price"]; ?></span></del>
                                    </div>
                                    <div class="slide-down-box">
                                       
                                        <div class="buttons">
                                           <?php
												
												 $selPrice_2 = "SELECT * FROM `interface_price` WHERE `product_id` = '" . $dataPrices2['product_id'] . "' AND product_price!=''";
													$resPrice_2 = mysqli_query($conn,$selPrice_2) or die(mysqli_error());
													$dataPrice_2 = mysqli_fetch_assoc($resPrice_2);
												
                                                $in_session = "0";

                                                if (!empty($_SESSION["cart_item"])) {

                                                    $session_code_array = array_keys($_SESSION["cart_item"]);

                                                    if (in_array($dataPrice_2["code"], $session_code_array)) {

                                                        $in_session = "1";
                                                    }
                                                }
                                                ?>
                                                <input type="hidden" id="qty_<?php echo $dataPrice_2["code"]; ?>" name="quantity" class="incdec" value="1" size="2" />
                                            
											  <?php if ($_SESSION['customer_id'] != '') { ?>       
											  
											 <a  href="javascript:void(0);" title="Wishlist" class="add_<?php echo $dataPrice_2["code"]; ?> btn wishlist-btn" onClick = "wishlistAction('add', '<?php echo $dataPrice_2["code"]; ?>')" style="cursor:pointer;">

											<i class="icon fa fa-heart wl-button" aria-hidden="true"></i></a>

										<?php } else { ?>


											<a href="login" title="Wishlist"><i class="fa fa-heart" aria-hidden="true"></i></a>


										<?php } ?>
											 
											 
											 
											 
                                                        <a href="javascript:void(0);" id="add_<?php echo $dataPrice_2["code"]; ?>" class="btn add-to-cart-btn btnAddAction cart-action" onClick = "cartAction('add', '<?php echo $dataPrice_2["code"]; ?>')" <?php if ($in_session != "0") { ?>style="display:none;" <?php } ?>>Add to cart</a>
                                                        
                                                      <a href="javascript:void(0);" id="added_<?php echo $dataPrice_2["code"]; ?>" class="btn add-to-cart-btn btnAddAction cart-action" <?php if ($in_session != "1") { ?>style="display:none" <?php } ?>>Added</a>  
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </li>
                        
          <?php }?>              
                        
                        
                        
                        

                    </ul>
                </div>