1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / ranafurnicos.com / public_html /
Filename : index.php
back
<?php
session_start();
error_reporting(0);
include 'admin/config/config.php';


$SubcatListing = "SELECT * FROM `interface_categories` where parent_id='0' and cat_status='Active' limit 1";
$SubresultListing = mysqli_query($conn,$SubcatListing) or die(mysqli_error($conn));
						
$resultSubCategory=mysqli_fetch_assoc($SubresultListing);
							
$mynameMenudata = str_replace( array(',',' '),'-',$resultSubCategory['category_name']);	
$myname_newMenudata = str_replace( array('--'),'-',$mynameMenudata);	
$Menumyname_new_data = str_replace( array('&-'),'',$myname_newMenudata);
$Menumyname_new_2_data = str_replace( array('%'),'',$Menumyname_new_data);	


$catListingTop = "SELECT * FROM `interface_categories` where cat_status='Active' and parent_id='0' and menu_department='Yes'";

$resultListingTop = mysqli_query($conn,$catListingTop) or die(mysqli_error($conn));


//select banners from table mobile_app_banners

$SelBanners = "SELECT * from mobile_app_banners where banners_status='Active' order by banners_orders";

$resBanners = mysqli_query($conn,$SelBanners) or die(mysqli_error());


//get department(categories for listing)

$catListing = "SELECT * FROM `interface_categories` where cat_status='Active' and parent_id='0' and menu_department='Yes'";

$resultListing = mysqli_query($conn,$catListing) or die(mysqli_error($conn));
//Trending Products
$trending = "SELECT * FROM `interface_procategories` 

			LEFT JOIN  `interface_product` ON `interface_product`.`product_id` = `interface_procategories`.`product_id` 
			LEFT JOIN  `interface_manufactured`  ON interface_product.`manufactured_id` = interface_manufactured.`manufactured_id` 
			
			WHERE sub_category_id = '24' and `interface_product`.`product_status` = 'Enable'";

$resulttrending = mysqli_query($conn,$trending) or die(mysqli_error($conn));



?>

<!DOCTYPE html>
<html class="no-js" lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Rana Furnicos</title>
	<meta name="description" content="Online Furniture Shopping in India: Shop from our online store in India for Furniture, Home Decor, Furnishings, Homeware and more at best prices. &#10004;95,000+ Choices &#10004;Free Shipping &#10004;No Cost EMI &#10004;Easy Returns" />
    <meta name="keywords" content="furniture stores near me, big lots furniture, furniture shop near me, furniture stores, home furniture, office furniture, online furniture, online furniture shopping, furniture stores, online furniture store, furniture online shopping,  online stores in India, home shopping,Sofa Loungers, sofas, sofa set, l shaped sofa, couch, sofa come bed, recliner, furtons,home furnishings, designer furnishings, living room furnishings, luxury home furnishings, furniture in Dhanbad, furniture in Jharkhand, Best furniture in India, discount furniture,Interior designing in dhanbad, interior designer in dhanbad." />
    
     <?php include("inc/header-files.php");?>
</head>
<body class="biolife-body">

  

    <!-- HEADER -->
	    <?php include("inc/header.php");?>


    <!-- Page Contain -->
    <div class="page-contain">

        <!-- Main content -->
        <div id="main-content" class="main-content">

            <!-- Block 01: Main slide block-->
            <div class="main-slide block-slider">
                <ul class="biolife-carousel nav-none-on-mobile" data-slick='{"arrows": true, "dots": false, "slidesMargin": 0, "slidesToShow": 1, "infinite": true, "speed": 800}' >
<?php while($fetchBanners=mysqli_fetch_assoc($resBanners)){ ?>                  

				  <li>
                        <div class="slide-contain slider-opt03__layout01 mode-02 slide-bgr-01">
                            <div class="media" style="background-image:url('admin/<?php echo $fetchBanners['banner_desktop_img'];?>');"></div>
                            <div class="text-content text-center">
                                <i class="first-line"><?php echo $fetchBanners['banner_content_1'];?></i>
                                <h1 class="second-line"><?php echo $fetchBanners['banner_content_2'];?></h1>
                               
                            </div>
                        </div>
                    </li>
<?php }?>        
                </ul>
            </div>
			        
<div class="wrap-category xs-margin-top-80px sm-margin-top-50px">
                <div class="container">
                  

                    <ul class="biolife-carousel nav-center-bold nav-none-on-mobile" data-slick='{"arrows":true,"dots":false,"infinite":false,"speed":400,"slidesMargin":30,"slidesToShow":4, "responsive":[{"breakpoint":1200, "settings":{ "slidesToShow": 3}},{"breakpoint":992, "settings":{ "slidesToShow": 3}},{"breakpoint":768, "settings":{ "slidesToShow": 2}}, {"breakpoint":500, "settings":{ "slidesToShow": 1}}]}'>
                        
					 <?php while($TopCategory=mysqli_fetch_assoc($resultListingTop)){ 

							

						$departTop = str_replace( array(' ',','),'-',$TopCategory['category_name']);

						
						//count category
						$CountCat = "SELECT count(added_id) as TotalCount FROM `interface_procategories` where sub_category_id='".$TopCategory['category_id']."'";

						$SubCountCat = mysqli_query($conn,$CountCat) or die(mysqli_error($conn));
						
						$fetchCount=mysqli_fetch_assoc($SubCountCat);
						
				?>		
						
						<li>
                            <div class="biolife-cat-box-item">
                               
                                <a class="cat-info" href="<?php echo  strtolower($departTop); ?>-<?php echo $TopCategory['category_id'];?>.htm">
                                    <h4 class="cat-name"><?php echo $TopCategory['category_name'];?></h4>
                                    <span class="cat-number">(<?php echo $fetchCount['TotalCount'];?> items)</span>
                                </a>
                            </div>
                        </li>
                        
					 <?php }?>        
                    </ul>

                </div>
            </div>
			
			<section class="home-section-2 home-background">
				<div class="container">
						<div class="row">
						    
								<!-- Project Single -->
								<div class="col-sm-12">
									<p class="quote"><b>Hurry! <br>Best deals on our <br>select range of products</b> </p>
									
									
								</div>
						</div>
				</div>
			</section>
           
        <div class="product-tab  biolife-product-tab__special home-08__elm-02 xs-margin-top-80px sm-margin-top-50px">
			<div class="biolife-title-box biolife-title-box__icon-at-top-style hidden-icon-on-mobile">
			<img src="assets/images/furnitures.png" style="width:56px;">
                    <span class="subtitle">Quick access to our products</span>
                    <h3 class="main-title">Shop by Categories</h3>
                </div>
            <div class="container-fluid">
                <div class="row">
                <?php 
				
				while($resultCategory=mysqli_fetch_assoc($resultListing)){ 

							

				$depart = str_replace( array(' ',','),'-',$resultCategory['category_name']);

				$SubcatListing = "SELECT * FROM `interface_categories` where parent_id='".$resultCategory['category_id']."' and cat_status='Active' limit 3";

				$SubresultListing = mysqli_query($conn,$SubcatListing) or die(mysqli_error($conn));
						
				?>		
		
                    <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12">
                        <div class="biolife-banner__style-20 biolife-banner__style-20--elm-01">
                            <a href="<?php 
							if($resultCategory['category_id']==21){
								
								echo 'customize-product-request';
								
							}else{
							
							echo  strtolower($depart); ?>-<?php echo $resultCategory['category_id'];?>.htm<?php }?>" class="media" style="background:url(admin/<?php echo $resultCategory['menu_banner'];?>) no-repeat center center;"></a>
                            <!--<div class="text-contain">
                                <h3 class="f-title">Upto 70% Flate</h3>
                                <b class="desc">Lorem Ipsum is simply dummy texting of the printings and typeset amet industry has industry'.</b>
                            </div>-->
                            <a style="color:#00c730" href="<?php 
							if($resultCategory['category_id']==21){
								
							echo 'customize-product-request';
							
							}else{ echo  strtolower($depart); ?>-<?php echo $resultCategory['category_id'];?>.htm<?php }?>" class="btn"><?php echo $resultCategory['category_name'];?></a>
                        </div>
                    </div>
                    
              <?php }?>      
                    
                </div>
            </div>
        </div>
			<section class="home-section-2 home-background-2">
				<div class="container">
						<div class="row">
						    
								<!-- Project Single -->
								<div class="col-sm-12">
									<p class="quote-2"><b>“Design creates culture. Culture shapes values. <br>Values determine the future.”</b> </p>
									<p class="writer"><b>Robert Peters</b></p>
									
								</div>
						</div>
				</div>
			</section>
		<div id="main-content" class="main-content">
          <div class="biolife-title-box biolife-title-box__icon-at-top-style hidden-icon-on-mobile">
			<img src="assets/images/furnitures.png" style="width:56px;margin-top:50px;">
                    <h3 class="main-title">Trending Products</h3>
                </div>

                        <div class="container">
                  
                    <ul class="biolife-carousel nav-center xs-margin-top-34px nav-none-on-mobile" data-slick='{"rows":1,"arrows":true,"dots":false,"infinite":false,"speed":400,"slidesMargin":30,"slidesToShow":3, "responsive":[{"breakpoint":1200, "settings":{ "slidesToShow": 3}},{"breakpoint":992, "settings":{ "slidesToShow": 2}},{"breakpoint":768, "settings":{ "slidesToShow": 2}},{"breakpoint":600, "settings":{ "slidesToShow": 1}}]}'>
                        <?php 
				
				while($fetchtrending=mysqli_fetch_assoc($resulttrending)){ 

							

				    $selProduct = "SELECT interface_product.product_id,img_1,product_name,category_discount,discount_status,product_s_price,product_price FROM `interface_product`

                    left JOIN `interface_product_images` ON `interface_product`.`product_id` = `interface_product_images`.`product_id` 
					left JOIN `interface_price` ON `interface_product`.`product_id` = `interface_price`.`product_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_product`.`product_id`= '" . $fetchtrending['product_id'] . "' AND  `interface_product`.`product_status` = 'Enable' ";

                        $resProduct = mysqli_query($conn,$selProduct) or die(mysqli_error($conn));

                        $dataProduct = mysqli_fetch_assoc($resProduct);
					  
                        
						$myname_new2 = str_replace( array(' '),'',$dataProduct['product_name']);
						$myname_new_2 = str_replace( array('%'),'-',$myname_new2);
						$myname_new_3 = str_replace( array('&amp;'),'',$myname_new_2);
						$myname_new_4 = str_replace( array('-'),'',$myname_new_3);
						
				?>
						<li>
                            <div class="post-item effect-01 style-bottom-info layout-03">
                               
                               <div class="thumbnail">
							                     <?php if ($dataProduct["category_discount"] != '' and $dataProduct["discount_status"] == 'Active' and ( $dataProduct['product_s_price'] == '' or $dataProduct['product_s_price'] == '0')) { ?>







                                    <div class="card-tag-wrapper">
                                         <span class="mania_deals" style="margin-left: 1px;">Upto <?php echo round($dataProduct["category_discount"]); ?>% off</span>
                                    </div>  



                                    <?php
                                }



                                if ($dataProduct['product_s_price'] > 0) {



                                    $specialPrice = (($dataProduct['product_price'] - $dataProduct['product_s_price']) * 100) / $dataProduct['product_price'];
                                    
									//echo $dataProduct['sub_category_id'];
									
									?>  								   



                                   <div class="card-tag-wrapper">
                                         <span class="mania_deals" style="margin-left: 1px;">Upto <?php echo round($specialPrice); ?>% off</span>
                                    </div>  



                                <?php } ?> 
                                    <a class="link-to-post" href="<?php echo $myname_new_4; ?>&amp;code=<?php echo $dataProduct['product_id']; ?>.html"><img src="admin/upload/<?php echo $dataProduct['img_1']; ?>" style="width:370px;height:295px;" alt=""></a>
                                   
                                </div>
                                <div class="post-content">
                                    <a href="<?php echo $myname_new_4; ?>&amp;code=<?php echo $dataProduct['product_id']; ?>.html"><h4 class="post-name"> <?php echo $dataProduct['product_name']; ?></h4>
                                    
                                  
                                    </a>
                                </div>
                            </div>
                        </li>
				<?php } ?>
                       
                    </ul>
                </div>
        </div>
        </div>
    </div>

    <!-- FOOTER -->

  <?php include("inc/footer.php");?>
  <?php include("inc/footer-files.php");?>

</body>

</html>