bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php

include"function.php";
    session_start();
    
    $sessionId = session_id();
    $userId = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : null;
    $uniqid ='';
    // Fetch cart data
    $cartData = fetchCartData($conn, $uniqid, $sessionId, $userId);

// $totalPrice = 0; // Initialize total price
    if ($cartData !== false) {
        $cartItems = $cartData['items'];
        $totalPrice = $cartData['totalAmount'];
        $totalItems = $cartData['totalCount'];
    }
    // $query = "SELECT c.id AS category_id, c.category_name, s.id AS subcategory_id, s.subcategory_name 
    //       FROM categories c
    //       LEFT JOIN subcategories s ON c.id = s.category_id";

// $result = $conn->query($query);
    
    // $categories = [];
    // if ($result->num_rows > 0) {
    //     while ($row = $result->fetch_assoc()) {
    //         $categories[$row['category_id']]['name'] = $row['category_name'];
    //         $categories[$row['category_id']]['subcategories'][] = [
    //             'id' => $row['subcategory_id'],
    //             'name' => $row['subcategory_name']
    //         ];
    //     }
    // }
    
    if(isset($_SESSION['user_id']) && $_SESSION['user_id'] != ""){
        updateCartUserId($conn, $sessionId, $userid);    
    }
     
    
    $bestSellers = fetchBestSellerProducts($conn);
    $schemeData = fetchSchemeData($conn);
    // print_r();
    
?>
<!DOCTYPE html>
<html lang="en">
  
<head>
        
        <title>EtsBay</title>

<meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
        
          <meta name="robots" content="index, follow">
        <meta name="author" content="EtsBay Watches">
        <meta name="description" content="Explore a wide range of high-quality, vintage, and classic watches at ETSBay. Discover timeless pieces from top brands, perfect for every occasion.">
        <meta name="keywords" content="vintage watches, classic watches, luxury watches, Seiko, Citizen, Orient, HMT, wristwatches, ETSBay watches, watch collections, men's watches, women's watches">

<meta property="og:title" content="EtsBay - Timeless Vintage Watches & Collectibles">
        <meta property="og:description" content="Explore our curated collection of vintage watches and learn about their fascinating history.">
        <meta property="og:image" content="https://www.etsbay.com/assets/img/favicon.png">
        <meta property="og:url" content="https://www.etsbay.com/">
        <meta property="og:type" content="website">
        <?php include"include/links.php";?>
        <style>
            .watch-list {
    background-color: #fff;
}
.watch-list ul {
    padding: 0;
    margin: 0;
    list-style: none;
    display: flex;
    justify-content: center;
    align-items: center;
    text-align: center;
}
.watch-list ul li {
     width: 320px;
     border-right: 1px solid #ddd;
     padding-top: 16px;
     padding-bottom: 16px;
    cursor: pointer;
     
     }

.watch-list ul li h2 {
    color: #373737;
     font-size: 14px;
    font-family: 'Roboto', sans-serif;
    font-weight: 500;
    }
    
    
 .watch-list ul li:last-child {
      border: 0;
    }
    
.watch-list li img {
    margin-bottom: 5px;
        width: 102px;
    height: 102px;
    border-radius: 50%;
    object-fit: cover;
    object-position: center;
    transition: transform 0.3s ease;
   }

.watch-list  ul li img {
    -webkit-tap-highlight-color: rgba(0, 0, 0, 0);
    transform: translateZ(0);
    box-shadow: 0 0 1px rgba(0, 0, 0, 0);

}
 .watch-list ul li:hover img {   
   transform: translateY(-5px);  }
   
@media screen and (min-width: 300px) and (max-width: 767px) {
    .watch-list ul {
        flex-wrap: wrap;
    }
    .watch-list ul li {
        width: 50%;
        padding: 6px 0;
        border-bottom: 1px solid #ddd;
    }
}

.popup-image {
            width: 100%; /* Make the image responsive */
            height: auto;
        }
        .top-list ul li {
    /*display: flex;*/
    /*align-items: center;*/
    text-align:center;
}
.prdctimg{
    display: block;
    width: 100%;
    height: 201px;
    object-fit: cover;
    object-position: center;
}      
</style>
    </head>

<main id="content" role="main">
            
            <div class="">
                <div class="container-fluid" style="padding:0;">
                    <div class="overflow-hidden" style="padding:0;">
                        <div style="padding:0;" class="bg-img-hero " style="background-image: url(assets/img/1400X420/img1.jpg);">
                            <div  style="padding:0;" id="thumbProgress" class="js-slick-carousel u-slick"
                                data-autoplay="true" 
                                data-autoplay-speed="5000" 
                                data-arrows="false" 
                                data-dots="false" 
                                data-slides-show="1" 
                                data-infinite="true"> 
                
                                <?php fetchBannerData($conn) ?>
                
                                
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            
            <div class="bg-dark">
                <marquee><p class="text-white font-weight-bold mb-0"><?=$schemeData['marque']?> </p></marquee>
            </div>
            <div class="watch-list container-fluid">
				<div class="row">
					<div class="col-md-12">
						<ul>
						    
							<?php fetchCategories($conn); ?>
							
						</ul>
				</div>
			</div>
		</div>
            
       <div class="container-fluid mt-5">
              <?php 
                    echo displayRecords($conn);
                ?>
       </div>
            
              <div class="top-list hidden-xs mb-5">
				<div class="container">
					<div class="row">
						<div class="col-12 p-0">
							<ul>
												
								<li>
									<img src="assets/img/icon/Value.png" alt="Value for Your Money">
									<div class="solid">
										<h3>Value for Your Money </h3>
										
									</div>
								</li>
															<li>
									<img src="assets/img/icon/fast-delevery.png" alt="All india Express Deliveryicon">
									<div class="solid">
										<h3>Worldwide Shipping </h3>
										
									</div>
								</li>
								<li>
									<img src="assets/img/icon/rating_2673061.png" alt="Trusted by over 50k Customers">
									<div class="solid">
										<h3>Trusted by over 50k Customers </h3>
										
									</div>
								</li>
						    	<li>
									<img src="assets/img/icon/QualityCheck.png" alt="360* Quality Check">
									<div class="solid">
										<h3>360* Quality Check </h3>
										
									</div>
								</li>
							</ul>
						</div>
					</div>
				</div>
			</div>     
            
            <div class="container-fluid  px-md-4 mt-5">
                
                <div class="mb-6">
                    
                    <div class="position-relative z-index-2 u-slick__tab">
                        <div class=" d-flex justify-content-between border-bottom border-color-1 flex-lg-nowrap flex-wrap border-md-down-top-0 border-md-down-bottom-0"><h3 class="section-title section-title__full mb-0 pb-2 font-size-22">Bestsellers</h3>

<ul class="w-100 w-lg-auto nav nav-pills nav-tab-pill nav-tab-pill-fill mb-2 pt-3 pt-lg-0 border-top border-color-1 border-lg-top-0 align-items-center font-size-15 font-size-15-lg flex-nowrap flex-lg-wrap overflow-auto overflow-lg-visble pr-0" id="pills-tab-3" role="tablist">
                                <li class="nav-item flex-shrink-0 flex-lg-shrink-1">
                                    <a class=" view-all-btn" id="Bpills-one-example1-tab" data-toggle="pill" href="#Bpills-one-example1" role="tab" aria-controls="Bpills-one-example1" aria-selected="true">Bestsellers</a>
                                </li>
                            
                            </ul>

</div>
                        
                        <div class="tab-content" id="Bpills-tabContent">
                            <div class="tab-pane fade pt-2 show active" id="Bpills-one-example1" role="tabpanel" aria-labelledby="Bpills-one-example1-tab">
                                <div class="js-slick-carousel u-slick overflow-hidden u-slick-overflow-visble pt-3 pb-6 px-1"
                                    data-pagi-classes="text-center right-0 bottom-1 left-0 u-slick__pagination u-slick__pagination--long mb-0 z-index-n1 mt-4"
                                    data-slides-show="5"
                                    data-slides-scroll="1"
                                    data-responsive='[{
                                      "breakpoint": 1400,
                                      "settings": {
                                        "slidesToShow": 5
                                      }
                                    }, {
                                        "breakpoint": 1200,
                                        "settings": {
                                          "slidesToShow": 3
                                        }
                                    }, {
                                      "breakpoint": 992,
                                      "settings": {
                                        "slidesToShow": 3
                                      }
                                    }, {
                                      "breakpoint": 768,
                                      "settings": {
                                        "slidesToShow": 1
                                      }
                                    }, {
                                      "breakpoint": 554,
                                      "settings": {
                                        "slidesToShow": 1
                                      }
                                    }]'>
                                    
                                    <?php

// Check if there are any products
                                        
                                            foreach ($bestSellers as $product) {
                                                
                                                if($product['quantity'] > 0){
                                                     echo '
                                                        <div class="js-slide products-group">
                                                            <div class="product-item">
                                                                <div class="product-item__outer h-100">
                                                                    <div class="product-item__inner px-wd-4 p-2 ">
                                                                        <div class="product-item__body pb-xl-2">
                                                                           <div class="mb-2">
                                                                               <a href="#" class="font-size-12 prct_ctg text-gray-5">' . htmlspecialchars($product['catagory']) . '</a>
                                                                            </div>
                                                                            
                                                                            <div class="mb-2">
                                                                                <a href="product.php?id='.$product['id'].'" class="d-block text-center">
                                                                                    <img class=" prdctimg" src="admin/images/' . htmlspecialchars($product['thumbnail_image']) . '" alt="' . htmlspecialchars($product['pname']) . '">
                                                                                </a>
                                                                            </div>
                                                                            <h5 class="mb-1 product-item__title">
                                                                                <a href="product.php?id='.$product['id'].'" class="text-blue">' . htmlspecialchars($product['pname']) . '</a>
                                                                            </h5>
                                                                            <div class="prodcut-price text-center mt-2 "  >
                                                                                <div class=" mb-2 text-gray-100">&dollar;<b>' . number_format($product['discountprice'], 2) . '</b>. <del>&dollar;' . number_format($product['price'], 2) . '</del></div>
                                                                             
                                                                             
                                                                             <div class="flex-center-between mb-3">
                                                                                <a href="product.php?id='.$product['id'].'" class="text-gray-6 add-to-cart font-size-13"><i class="ec ec-add-to-cart font-size-15"></i>&nbsp; Add to Cart</a>
                                                                             </div>
                                                                             
                                                                             
                                                                            </div>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </div>';    
                                                }else{
                                                     echo '
                                                        <div class="js-slide products-group">
                                                            <div class="product-item">
                                                                <div class="product-item__outer h-100">
                                                                    <div class="product-item__inner px-wd-4 p-2 ">
                                                                        <div class="product-item__body pb-xl-2">
                                                                           <div class="mb-2">
                                                                               <a href="#" class="font-size-12 prct_ctg text-gray-5">' . htmlspecialchars($product['catagory']) . '</a>
                                                                            </div>
                                                                            
                                                                            <div class="mb-2"><a href="product.php?id='.$product['id'].'" class="d-block text-center">
                                                                                    <img class=" prdctimg" src="admin/images/' . htmlspecialchars($product['thumbnail_image']) . '" alt="' . htmlspecialchars($product['pname']) . '">
                                                                                </a>
                                                                            </div>
                                                                            <h5 class="mb-1 product-item__title">
                                                                                <a href="product.php?id='.$product['id'].'" class="text-blue">' . htmlspecialchars($product['pname']) . '</a>
                                                                            </h5>
                                                                            <div class="prodcut-price text-center mt-2 "  >
                                                                                <div class=" mb-2 text-gray-100">&dollar;<b>' . number_format($product['discountprice'], 2) . '</b>. <del>&dollar;' . number_format($product['price'], 2) . '</del></div>
                                                                             
                                                                             
                                                                             <div class="flex-center-between mb-3">
                                                                                <a href="product.php?id='.$product['id'].'" class="text-gray-6 add-to-cart font-size-13" style="    background: #f90606e8; border-color: #f90606e8; color: #fff !important;"> out of stock</a>
                                                                             </div>
                                                                             
                                                                             
                                                                            </div>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </div>';
                                                }
                                                
                                                // HTML structure with PHP embedded to output product details
                                               
                                                
                                                
                                                
                                                
                                            }
                                        
                                    ?>
                                    
                                </div>
                            </div>
                            
                        </div>
                        
                    </div>
                    
                </div>

<?php 
                    
                    $productTrandingData = displayTrendingProductsByCategory($conn);
                    
                    echo $productTrandingData;
                
                ?>
            
            
           
            
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
             
                
            </div>
            
            
         <section class="mb-6 bg-light py-4 content">
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-12 mb-3">
                            <h2> EtsBay</h2>
                            <p>We are the Refurbished Watch Dealer Located in India, we are in this trade since 2014.We source the used and not working Vintage watches from all over the world and then Refurbish them and make the wearable for our customers, We Inspect physical condition of the watches and then refurbish them according to the requirement.</p>
                            <ul>
                         
                                <li>Complete purchase transactions</li>
                                <li>Watch Refurbishment</li>
                                <li>Initial watch assessment #refurbishment</li>
                                <li>Check for any mechanical issues</li>
                                <li>Assess the condition of the watch band and casing</li>
                                <li>Repair mechanical issues #refurbishment</li>
                                <li>Replace or repair damaged watch parts</li>
                                <li>Ensure the watch keeps accurate time</li>
                                <li>Cosmetic refurbishment #refurbishment</li>
                                <li>Polish watch casing and band</li>
                                <li>Replace damaged or worn out watch bands</li>
                            </ul>
                        </div>
                        <div class="col-12 mb-3">
                            <h2>Discover the Essence of Timekeeping</h2>
                            <p>At EtsBay, we believe that every watch tells a story, capturing the essence of time in a unique way. Since our inception, we have been dedicated to providing enthusiasts and collectors with an exceptional selection of vintage timepieces, each with its own history and charm. Our passion for horology drives us to curate a collection that transforms how you experience time, making each moment extraordinary.</p>
                        </div>
                        <div class="col-12 mb-3">
                            <h2>A Watch for Every Occasion</h2>
                            <p>Whether you’re celebrating a milestone or simply want to elevate your everyday style, EtsBay has the perfect timepiece for you. Our expert team scours the globe to find exquisite watches that stand the test of time. From elegant dress watches to rugged sports models, our curated selection ensures that you’ll find a watch that resonates with your personality and occasion.</p>
                            <p>What sets us apart is our commitment to quality. Every watch in our collection is meticulously inspected and restored to ensure it meets our high standards. We believe that a vintage watch is not just an accessory, but a companion that enhances your journey through life.</p>
                        </div>
                        <div class="col-12 mb-3">
                            <h2>Express Delivery of Vintage Watches Across India</h2>
                            <p>Life can be hectic, and sometimes you may find yourself in need of a last-minute gift or a statement piece for an upcoming event. That’s where we come in. At EtsBay, we offer express delivery across major cities in India, ensuring that you can always find the perfect watch, right when you need it.</p>
                            <p>Our swift and reliable delivery service means you won’t have to wait long to add a timeless piece to your collection or surprise a loved one. Each watch is packaged with care, ensuring it arrives in pristine condition, ready to make an unforgettable impression.</p>
                        </div>
                        <div class="col-12 mb-3">
                            <h2>A Curated Collection of Timeless Pieces</h2>
                            <p>Our extensive collection features a wide array of vintage watches from renowned brands, each selected for its unique character and craftsmanship. From classic mechanical timepieces to elegant quartz watches, we have something to suit every taste and occasion.</p>
                            <p>Every watch is restored with precision, ensuring that it not only looks stunning but also performs flawlessly. We take pride in offering watches that embody the artistry and innovation of horology. When you choose EtsBay, you’re not just purchasing a watch; you’re investing in a piece of history.</p>
                        </div>
                        <div class="col-12 mb-3">
                            <h2>Making Special Occasions Unforgettable</h2>
                            <p>Watches are more than just tools for telling time; they are cherished gifts that celebrate life’s special moments. Whether it’s a birthday, anniversary, graduation, or any milestone worth commemorating, a vintage watch is a meaningful gift that will be treasured for years to come.</p>
                            <p>Our diverse selection ensures that you can find awatch that perfectly matches the occasion. From sleek and sophisticated styles to bold and adventurous designs, we have the perfect timepiece for everyone on your list. When you give a vintage watch from EtsBay, you’re giving a gift that carries emotion and significance.</p>
                        </div>
                        <div class="col-12 mb-3">
                            <h2>Elevate Your Gift with EtsBay</h2>
                            <p>When you choose EtsBay, you’re opting for more than just a watch; you’re selecting a piece of art that embodies your feelings and sentiments. Our commitment to excellence ensures that every watch you purchase is a testament to your thoughtfulness and care.</p>
                            <p>Explore our online store today and discover a world of vintage watches that are as unique as the moments they commemorate. With seamless delivery and impeccable customer service, we make gifting easy and memorable. Whether you’re celebrating your own journey or that of a loved one, EtsBay is here to help you create lasting memories, one tick at a time.</p>
                        </div>
                    </div>
                </div>
            </section>
            
            
          
            
            
            
        </main>

<?php include"include/footer.php";?>

<?php include"include/script.php";?>
        <?php
            // Show the popup on page load
            showPopup($conn);
        ?>
        
        <script>
            $(window).on('load', function () {
                // initialization of HSMegaMenu component
                $('.js-mega-menu').HSMegaMenu({
                    event: 'hover',
                    direction: 'horizontal',
                    pageContainer: $('.container'),
                    breakpoint: 1199.98,
                    hideTimeOut: 0
                });

// initialization of svg injector module
                $.HSCore.components.HSSVGIngector.init('.js-svg-injector');
            });

$(document).on('ready', function () {
                // initialization of header
                $.HSCore.components.HSHeader.init($('#header'));

// initialization of animation
                $.HSCore.components.HSOnScrollAnimation.init('[data-animation]');

// initialization of unfold component
                $.HSCore.components.HSUnfold.init($('[data-unfold-target]'), {
                    afterOpen: function () {
                        $(this).find('input[type="search"]').focus();
                    }
                });

// initialization of popups
                $.HSCore.components.HSFancyBox.init('.js-fancybox');

// initialization of countdowns
                var countdowns = $.HSCore.components.HSCountdown.init('.js-countdown', {
                    yearsElSelector: '.js-cd-years',
                    monthsElSelector: '.js-cd-months',
                    daysElSelector: '.js-cd-days',
                    hoursElSelector: '.js-cd-hours',
                    minutesElSelector: '.js-cd-minutes',
                    secondsElSelector: '.js-cd-seconds'
                });

// initialization of malihu scrollbar
                $.HSCore.components.HSMalihuScrollBar.init($('.js-scrollbar'));

// initialization of forms
                $.HSCore.components.HSFocusState.init();

// initialization of form validation
                $.HSCore.components.HSValidation.init('.js-validate', {
                    rules: {
                        confirmPassword: {
                            equalTo: '#signupPassword'
                        }
                    }
                });

// initialization of show animations
                $.HSCore.components.HSShowAnimation.init('.js-animation-link');

// initialization of fancybox
                $.HSCore.components.HSFancyBox.init('.js-fancybox');

// initialization of slick carousel
                $.HSCore.components.HSSlickCarousel.init('.js-slick-carousel');

// initialization of go to
                $.HSCore.components.HSGoTo.init('.js-go-to');

// initialization of hamburgers
                $.HSCore.components.HSHamburgers.init('#hamburgerTrigger');

// initialization of unfold component
                $.HSCore.components.HSUnfold.init($('[data-unfold-target]'), {
                    beforeClose: function () {
                        $('#hamburgerTrigger').removeClass('is-active');
                    },
                    afterClose: function() {
                        $('#headerSidebarList .collapse.show').collapse('hide');
                    }
                });

$('#headerSidebarList [data-toggle="collapse"]').on('click', function (e) {
                    e.preventDefault();

var target = $(this).data('target');

if($(this).attr('aria-expanded') === "true") {
                        $(target).collapse('hide');
                    } else {
                        $(target).collapse('show');
                    }
                });

// initialization of unfold component
                $.HSCore.components.HSUnfold.init($('[data-unfold-target]'));

// initialization of select picker
                $.HSCore.components.HSSelectPicker.init('.js-select');
            });
        </script>
    </body>

</html>