
<footer>
   <div class="container">
      <div class="row g-4">
         <div class="col-lg-12 mb-4">
            <div class="row g-4">
               <div class="col-lg-12">
                  <h6 class="mb-4 fw-bold">Top Store</h6>
                  <div class="sub_top_store">
                     <span class="most_searched">Electronics:</span>
                     <a class="most_searched_item" href="./research/<?=('mobile')?>">Mobiles</a>
                     <a class="most_searched_item" href="./research/<?=('phone')?>">Phone</a>
                     <a class="most_searched_item" href="./research/<?=('smart-watches')?>">Watches</a>
                     <a class="most_searched_item" href="./research/<?=('laptops')?>">Laptops</a>
                     <a class="most_searched_item" href="./research/<?=('tablets')?>">Tablets</a>
                     <a class="most_searched_item" href="./research/<?=('speakers')?>">Speakers</a>
                     <a class="most_searched_item" href="./research/<?=('camera')?>">Camera</a>
                     <a class="most_searched_item" href="./research/<?=('memory-cards')?>">Memory Cards</a>
                     <a class="most_searched_item" href="./research/<?=('pendrive')?>">Pendrive</a>
                     <a class="most_searched_item" href="./research/<?=('mouse')?>">Mouse</a>
                     <a class="most_searched_item" href="./research/<?=('mobile-chargers')?>">Mobile chargers</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">TVs & Appliances:</span>
                     <a class="most_searched_item" href="./research/<?=('television')?>">Television</a>
                     <a class="most_searched_item" href="./research/<?=('washing-machine')?>">Washing Machine</a>
                     <a class="most_searched_item" href="./research/<?=('air-conditioners')?>">Air Conditioners</a>
                     <a class="most_searched_item" href="./research/<?=('refrigerators')?>">Refrigerators</a>
                     <a class="most_searched_item" href="./research/<?=('electric-cookers')?>">Electric Cookers</a>
                     <a class="most_searched_item" href="./research/<?=('heater')?>">Heater</a>
                     <a class="most_searched_item" href="./research/<?=('inverters')?>">Inverters</a>
                     <a class="most_searched_item" href="./research/<?=('irons')?>">Irons</a>
                     <a class="most_searched_item" href="./research/<?=('grinders')?>">Grinders</a>
                     <a class="most_searched_item" href="./research/<?=('juicer')?>">Juicer</a>
                     <a class="most_searched_item" href="./research/<?=('mixer')?>">Mixer</a>
                     <a class="most_searched_item" href="./research/<?=('ovens')?>">Ovens</a>
                     <a class="most_searched_item" href="./research/<?=('vacuum-cleaners')?>">Vacuum Cleaners</a>
                     <a class="most_searched_item" href="./research/<?=('water-purifie')?>">Water Purifier</a>
                     <a class="most_searched_item" href="./research/<?=('network-components')?>">Fan</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Men:</span>
                     <a class="most_searched_item" href="./research/<?=('footwear')?>">Footwear</a>
                     <a class="most_searched_item" href="./research/<?=('t-shirts')?>">T-shirts</a>
                     <a class="most_searched_item" href="./research/<?=('jeans')?>">Jeans</a>
                     <a class="most_searched_item" href="./research/<?=('kurta')?>">Kurta</a>
                     <a class="most_searched_item" href="./research/<?=('suits')?>">Suits</a>
                     <a class="most_searched_item" href="./research/<?=('blazers')?>">Blazers</a>
                     <a class="most_searched_item" href="./research/<?=('ties')?>">Ties</a>
                     <a class="most_searched_item" href="./research/<?=('socks')?>">Socks</a>
                     <a class="most_searched_item" href="./research/<?=('caps')?>">Caps</a>
                     <a class="most_searched_item" href="./research/<?=('sunglasses')?>">Sunglasses</a>
                     <a class="most_searched_item" href="./research/<?=('belts')?>">Belts</a>
                     <a class="most_searched_item" href="./research/<?=('wallets')?>">Wallets</a>
                     <a class="most_searched_item" href="./research/<?=('raincoats')?>">Raincoats</a>
                     <a class="most_searched_item" href="./research/<?=('watches')?>">Watches</a>
                     <a class="most_searched_item" href="./research/<?=('trimmers')?>">Trimmers</a>
                     <a class="most_searched_item" href="./research/<?=('shavers')?>">Shavers</a>
                     <a class="most_searched_item" href="./research/<?=('jackets')?>">Jackets</a>
                     <a class="most_searched_item" href="./research/<?=('tracksuits')?>">Tracksuits</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Women:</span>
                     <a class="most_searched_item" href="./research/<?=('jeans')?>">Jeans</a>
                     <a class="most_searched_item" href="./research/<?=('shorts')?>">Shorts</a>
                     <a class="most_searched_item" href="./research/<?=('skirts')?>">Skirts</a>
                     <a class="most_searched_item" href="./research/<?=('trousers')?>">Trousers</a>
                     <a class="most_searched_item" href="./research/<?=('party-dresses')?>">Party Dresses</a>
                     <a class="most_searched_item" href="./research/<?=('capris')?>">Capris</a>
                     <a class="most_searched_item" href="./research/<?=('night-dresses')?>">Night Dresses</a>
                     <a class="most_searched_item" href="./research/<?=('sarees')?>">Sarees</a>
                     <a class="most_searched_item" href="./research/<?=('dupattas')?>">Dupattas</a>
                     <a class="most_searched_item" href="./research/<?=('footwear')?>">Footwear</a>
                     <a class="most_searched_item" href="./research/<?=('sandals')?>">Sandals</a>
                     <a class="most_searched_item" href="./research/<?=('slippers')?>">Slippers</a>
                     <a class="most_searched_item" href="./research/<?=('handbags')?>">Handbags</a>
                     <a class="most_searched_item" href="./research/<?=('watches')?>">Watches</a>
                     <a class="most_searched_item" href="./research/<?=('jewellery')?>">Jewellery</a>
                     <a class="most_searched_item" href="./research/<?=('personal-care-appliances')?>">Personal Care Appliances</a>
                     <a class="most_searched_item" href="./research/<?=('clutches')?>">Clutches</a>
                     <a class="most_searched_item" href="./research/<?=('winter-wear')?>">Winter Wear</a>
                     <a class="most_searched_item" href="./research/<?=('sports-wear')?>">Sports Wear</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Fashion:</span>
                     <a class="most_searched_item" href="./research/<?=('shoes')?>">Shoes</a>
                     <a class="most_searched_item" href="./research/<?=('watches')?>">Watches</a>
                     <a class="most_searched_item" href="./research/<?=('sunglasses')?>">Sunglasses </a>
                     <a class="most_searched_item" href="./research/<?=('lifestyle-&-leisure')?>">Lifestyle & Leisure</a>
                     <a class="most_searched_item" href="./research/<?=('party-dresses')?>">Party Dresses</a>
                     <a class="most_searched_item" href="./research/<?=('formal-dresses')?>">Formal Dresses</a>
                     <a class="most_searched_item" href="./research/<?=('outfits')?>">Outfits</a>
                     <a class="most_searched_item" href="./research/<?=('jackets')?>">Jackets</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Gifts:</span>
                     <a class="most_searched_item" href="./research/<?=('anniversary-gifts')?>">Anniversary Gifts</a>
                     <a class="most_searched_item" href="./research/<?=('birthday-gifts')?>">Birthday Gifts</a>
                     <a class="most_searched_item" href="./research/<?=('wedding-gifts')?>">Wedding Gifts</a>
                     <a class="most_searched_item" href="./research/<?=('personalised-gift')?>">Personalised Gifts</a>
                     <a class="most_searched_item" href="./research/<?=('adult-gift')?>">Adult Gifts</a>
                     <a class="most_searched_item" href="./research/<?=('other-gadgets')?>">Other Gadgets</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Baby & Kids:</span>
                     <a class="most_searched_item" href="./research/<?=('kids-clothinge')?>">Kids Clothing</a>
                     <a class="most_searched_item" href="./research/<?=('boys-clothing')?>">Boys Clothing</a>
                     <a class="most_searched_item" href="./research/<?=('girls-clothing')?>">Girls Clothing</a>
                     <a class="most_searched_item" href="./research/<?=('baby-boys-clothing')?>">Baby Boys Clothing</a>
                     <a class="most_searched_item" href="./research/<?=('baby-girls-clothing')?>">Baby Girls Clothing</a>
                     <a class="most_searched_item" href="./research/<?=('kids-footwear')?>">Kids Footwear</a>
                     <a class="most_searched_item" href="./research/<?=('boys-footwear')?>">Boys Footwear</a>
                     <a class="most_searched_item" href="./research/<?=('infant-footwear')?>">Infant Footwear</a>
                     <a class="most_searched_item" href="./research/<?=('haracter-shoes')?>">Character Shoes</a>
                     <a class="most_searched_item" href="./research/<?=('kids-winter-wear')?>">Kids Winter Wear</a>
                     <a class="most_searched_item" href="./research/<?=('boys-winter-wear')?>">Boys Winter Wear</a>
                     <a class="most_searched_item" href="./research/<?=('toys')?>">Toys</a>
                     <a class="most_searched_item" href="./research/<?=('school-supplies')?>">School Supplies</a>
                     <a class="most_searched_item" href="./research/<?=('baby-care')?>">Baby Care</a>
                     <a class="most_searched_item" href="./research/<?=('featured-brands')?>">Featured brands</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Home & Furniture:</span>
                     <a class="most_searched_item" href="./research/<?=('beds')?>">Beds</a>
                     <a class="most_searched_item" href="./research/<?=('sofa')?>">Sofa</a>
                     <a class="most_searched_item" href="./research/<?=('lamps')?>">Lamps</a>
                     <a class="most_searched_item" href="./research/<?=('curtains')?>">Curtains</a>
                     <a class="most_searched_item" href="./research/<?=('pillows')?>">Pillows</a>
                     <a class="most_searched_item" href="./research/<?=('cabinets')?>">Cabinets</a>
                     <a class="most_searched_item" href="./research/<?=('chairs')?>">Chairs</a>
                     <a class="most_searched_item" href="./research/<?=('clocks')?>">Clocks</a>
                     <a class="most_searched_item" href="./research/<?=('desks')?>">Desks</a>
                     <a class="most_searched_item" href="./research/<?=('lunch-boxes')?>">Lunch Boxes</a>
                     <a class="most_searched_item" href="./research/<?=('dinner-set')?>">Dinner Set</a>
                     <a class="most_searched_item" href="./research/<?=('tawas')?>">Tawas</a>
                     <a class="most_searched_item" href="./research/<?=('bed-sheet')?>">Bed Sheet</a>
                     <a class="most_searched_item" href="./research/<?=('cupboards')?>">Cupboards</a>
                     <a class="most_searched_item" href="./research/<?=('dressers')?>">Dressers</a>
                     <a class="most_searched_item" href="./research/<?=('hutch')?>">Hutch</a>
                     <a class="most_searched_item" href="./research/<?=('gardening-store')?>">Gardening Store</a>
                     <a class="most_searched_item" href="./research/<?=('blankets')?>">Blankets</a>
                     <a class="most_searched_item" href="./research/<?=('wardrobes')?>">Wardrobes</a>
                     <a class="most_searched_item" href="./research/<?=('mattresses')?>">Mattresses</a>
                     <a class="most_searched_item" href="./research/<?=('bulbs')?>">Bulbs</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Sports, Books & More:</span>
                     <a class="most_searched_item" href="./research/<?=('sports')?>">Sports</a>
                     <a class="most_searched_item" href="./research/<?=('exercise-fitness')?>">Exercise Fitness</a>
                     <a class="most_searched_item" href="./research/<?=('food-essentials')?>">Food Essentials</a>
                     <a class="most_searched_item" href="./research/<?=('health-&-nutrition')?>">Health & Nutrition</a>
                     <a class="most_searched_item" href="./research/<?=('books')?>">Books</a>
                     <a class="most_searched_item" href="./research/<?=('stationery')?>">Stationery</a>
                     <a class="most_searched_item" href="./research/<?=('auto-accessories')?>">Auto Accessories</a>
                     <a class="most_searched_item" href="./research/<?=('industrial-&-scientific-tools')?>">Industrial & Scientific tools</a>
                     <a class="most_searched_item" href="./research/<?=('medical-supplies')?>">Medical Supplies</a>
                     <a class="most_searched_item" href="./research/<?=('musical-instruments')?>">Musical Instruments</a>
                     <a class="most_searched_item" href="./research/<?=('shoes')?>">Gaming Accessories</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Footwear:</span>
                     <a class="most_searched_item" href="./research/<?=('shoes')?>">Shoes</a>
                     <a class="most_searched_item" href="./research/<?=('sandals')?>">Sandals</a>
                     <a class="most_searched_item" href="./research/<?=('slipper')?>">Slipper</a>
                     <a class="most_searched_item" href="./research/<?=('flip-flops')?>">Flip Flops</a>
                     <a class="most_searched_item" href="./research/<?=('army-boots')?>">Army Boots</a>
                     <a class="most_searched_item" href="./research/<?=('loafers')?>">Loafers</a>
                     <a class="most_searched_item" href="./research/<?=('ankle-boots')?>">Ankle Boots</a>
                     <a class="most_searched_item" href="./research/<?=('monks')?>">Monks</a>
                     <a class="most_searched_item" href="./research/<?=('wedges')?>">Wedges</a>
                     <a class="most_searched_item" href="./research/<?=('figure-skates')?>">Figure Skates</a>
                     <a class="most_searched_item" href="./research/<?=('ballet-flats')?>">Ballet Flats</a>
                     <a class="most_searched_item" href="./research/<?=('mary-janes')?>">Mary Janes</a>
                     <a class="most_searched_item" href="./research/<?=('moccasins')?>">Moccasins</a>
                     <a class="most_searched_item" href="./research/<?=('mules')?>">Mules</a>
                     <a class="most_searched_item" href="./research/<?=('brogues')?>">Brogues</a>
                     <a class="most_searched_item" href="./research/<?=('kitten-heels')?>">Kitten Heels</a>
                     <a class="most_searched_item" href="./research/<?=('slingbacks')?>">Slingbacks</a>
                     <a class="most_searched_item" href="./research/<?=('uggs')?>">Uggs</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Groceries:</span>
                     <a class="most_searched_item" href="./research/<?=('hand-wash')?>">Hand Wash</a>
                     <a class="most_searched_item" href="./research/<?=('soap')?>">Soap</a>
                     <a class="most_searched_item" href="./research/<?=('cashew-nuts')?>">Cashew Nuts</a>
                     <a class="most_searched_item" href="./research/<?=('sunflower-oil')?>">Sunflower Oil</a>
                     <a class="most_searched_item" href="./research/<?=('eggs')?>">Eggs</a>
                     <a class="most_searched_item" href="./research/<?=('toilet-cleaner')?>">Toilet Cleaner</a>
                     <a class="most_searched_item" href="./research/<?=('harpic-toilet-cleaner')?>">Harpic Toilet Cleaner</a>
                     <a class="most_searched_item" href="./research/<?=('dettol-soap')?>">Dettol Soap</a>
                     <a class="most_searched_item" href="./research/<?=('>mustard-oil')?>">Mustard Oil</a>
                     <a class="most_searched_item" href="./research/<?=('biscuits')?>">Biscuits</a>
                     <a class="most_searched_item" href="./research/<?=('cheese')?>">Cheese</a>
                     <a class="most_searched_item" href="./research/<?=('tea')?>">Tea</a>
                  </div>
                  <div class="sub_top_store">
                     <span class="most_searched">Top Tranding:</span>
                     <a class="most_searched_item" href="./research/<?=('portable-air-cooler')?>">Portable Air Cooler</a>
                     <a class="most_searched_item" href="./research/<?=('bags')?>">Bags</a>
                     <a class="most_searched_item" href="./research/<?=('books')?>">Books</a>
                     <a class="most_searched_item" href="./research/<?=('toys')?>">Toys</a>
                     <a class="most_searched_item" href="./research/<?=('candles')?>">Candles</a>
                     <a class="most_searched_item" href="./research/<?=('helmets')?>">Helmets</a>
                     <a class="most_searched_item" href="./research/<?=('wall-clocks')?>">Wall Clocks</a>
                     <a class="most_searched_item" href="./research/<?=('baby-food')?>">Baby Food</a>
                     <a class="most_searched_item" href="./research/<?=('chocolates')?>">Chocolates</a>
                     <a class="most_searched_item" href="./research/<?=('cycles')?>">Cycles</a>
                     <a class="most_searched_item" href="./research/<?=('calculators')?>">Calculators</a>
                     <a class="most_searched_item" href="./research/<?=('lipsticks')?>">Lipsticks</a>
                     <a class="most_searched_item" href="./research/<?=('mask')?>">Mask</a>
                     <a class="most_searched_item" href="./research/<?=('vertiv-ups')?>">Vertiv UPS</a>
                     <a class="most_searched_item" href="./research/<?=('fastrack-watches')?>">Fastrack Watches</a>
                     <a class="most_searched_item" href="./research/<?=('wallets')?>">Wallets</a>
                     <a class="most_searched_item" href="./research/<?=('handbags')?>">Handbags</a>
                  </div>
               </div>
            </div>
         </div>
      </div>
      <div class="row">
         <div class="footer-bottom">
            <img src="images/web-images/logo/<?=$company_logo?>" alt="logo" title="logo" class="img-fluid mb-2">
            <!-- Social media icon -->
            <ul class="list-inline s-icons mb-2 mt-3">
               <?php    $sql = "SELECT * FROM social_media";
                  $myquery=$conn->query($sql);
                  $mydara= $myquery->fetchAll()  ;
                  
                  $rows_found = $myquery->rowCount();
                  foreach($mydara as $row){
                  
                  $social_url_1 = $row["social_url_1"];
                  $social_url_2 = $row["social_url_2"];
                  $social_url_3 = $row["social_url_3"];
                  $social_url_4 = $row["social_url_4"];
                  $social_1 = $row["social_1"];
                  $social_2 = $row["social_2"];
                  $social_3 = $row["social_3"];
                  $social_4 = $row["social_4"];
                  }
                  ?>
               <li class="list-inline-item"> <a target="_blank" class="p-2" href="<?=$social_url_1?>"><i class="<?=$social_1?>"></i></a> </li>
               <li class="list-inline-item"> <a target="_blank" class="p-2" href="<?=$social_url_2?>"><i class="<?=$social_2?>"></i></a> </li>
               <li class="list-inline-item"> <a target="_blank" class="p-2" href="<?=$social_url_3?>"><i class="<?=$social_3?>"></i></a> </li>
               <li class="list-inline-item"> <a target="_blank" class="p-2" href="<?=$social_url_4?>"><i class="<?=$social_4?>"></i></a> </li>
            </ul>
         </div>
      </div>
      <div class="row justify-content-center align-items-center pt-3">
         <!--copyright Begin-->
         <div class="col-md-6 text-center text-lg-start"><small><?=$copyright?> </small></div>
         <!--copyright End-->
         <div class="col-md-6">
            <ul class="list-inline mb-0 text-center text-lg-end">
               <li class="list-inline-item mb-0"> <a href="about-us.php"><small>About us</small></a> </li>
               <li class="list-inline-item mb-0"> <a href="terms-condition.php"><small>Terms Condition</small></a> </li>
               <li class="list-inline-item mb-0"> <a href="privacy-policy.php"><small>Privacy Policy</small></a> </li>
               <li class="list-inline-item mb-0"> <a href="contact.php"><small>Contact us</small></a> </li>
            </ul>
         </div>
      </div>
   </div>
</footer>



