<div class="body-content" id="top-banner-and-menu">
<div id="hero">
<div id="owl-main" class="owl-carousel owl-inner-nav owl-ui-sm">

<?php

$query = $db->query("SELECT * FROM slider ORDER BY sira ASC", PDO::FETCH_ASSOC);

if($query->rowCount()){

foreach($query as $row){

?>
<div class="item" style="background-image: url(upload/<?=$row["img"]?>);">
<div class="container">
<div class="caption bg-color vertical-center text-left">
<div class="slider-header fadeInDown-1"> <?=$row["baslik1"]?></div>
<div class="big-text fadeInDown-1"> <?=$row["baslik2"]?> </div>
<div class="excerpt fadeInDown-2 hidden-xs"> <span> <?=$row["baslik3"]?></span> </div>
<div class="button-holder fadeInDown-3"> <a href="<?=$row["link"]?>" class="btn-lg btn btn-uppercase btn-primary shop-now-button"><?=$row["byazi"]?></a> </div>
</div>
<!-- /.caption -->
</div>
<!-- /.container-fluid -->
</div>
<!-- /.item -->
<?php } } ?>

</div>
<!-- /.owl-carousel -->
</div>
<div class="container home-banner1">
<div class="row row-bottom">
<div class="col-sm-4 col-xs-12 col-md-4">
<a class="btn btn-call btn-bottom" href="tel:<?php echo $cek[
"telefon"
]; ?>">Çağrı Merkezi</a>
</div>
<div class="col-sm-4 col-xs-12 col-md-4">
<a class="btn btn-email btn-bottom" href="mailto:<?php echo $cek[
"email"
]; ?>">E-Posta Gönder</a>
</div>
<div class="col-sm-4 col-xs-12 col-md-4">
<a class="btn btn-chat btn-bottom" href="https://api.whatsapp.com/send?phone=9<?php echo $cek[
"whatsapp"
]; ?>">WhatsApp Hattı</a>
</div>
</div>
</div>



<div class="container">
<!-- ============================================== BRANDS CAROUSEL ============================================== -->

<section class="category-ellipse-section" style="margin-top:15px;">
<div class="swiper-container swiper-theme shadow-swiper show-code-action swiper-container-initialized swiper-container-horizontal swiper-container-pointer-events" data-swiper-options="{
'spaceBetween': 20,
'slidesPerView': 2,
'breakpoints': {
'576': {
'slidesPerView': 3
},
'768': {
'slidesPerView': 4
},
'992': {
'slidesPerView': 5
},
'1200': {
'slidesPerView': 6
}
}
}" style="overflow: hidden;">
<div class="swiper-wrapper" aria-live="polite" style="transform: translate3d(0px, 0px, 0px); transition-duration: 0ms; display: flex;">

<?php
$query = $db->query("SELECT * FROM hikaye ORDER BY id DESC", PDO::FETCH_ASSOC);
if($query->rowCount()){
foreach($query as $row){

?>

<div class="category category-ellipse swiper-slide-active" style="min-width:97px; max-width:97px; margin-right: 30px;" role="group" aria-label="1 / 6">
<figure class="category-media" style="border-radius: 50%;overflow: hidden;border: 0px solid #fff;">
<a href="<?=$row["link"]?>">
<img src="upload/<?=$row['kucuk_img']?>" alt="<?=$row['baslik']?>" width="100" height="100" style="background: transparent;">
</a>
</figure>
<div class="category-content">
<h4 class="category-name" style="margin-bottom: 0;text-align: center;font-size: 1.6rem;font-weight: 700;line-height: 1.2;text-transform: uppercase;letter-spacing: -0.025em;">
<a href="<?=$row["link"]?>" style="color: inherit;text-decoration: none; -webkit-transition: color 0.3s; transition: color 0.3s;"><?=$row['baslik']?></a>
</h4>
</div>
</div>


<?php } } ?>

</div>
</div>
</section>




<div class="row">
<div class="col-lg-5 col-md-5 col-sm-5 col-xs-12"><!-- ============================================== HOT DEALS ============================================== -->
<div class="sidebar-widget hot-deals wow outer-bottom-xs">
<h3 class="section-title">Haftanın Ürünleri</h3>
<div class="owl-carousel sidebar-carousel custom-carousel owl-theme outer-top-ss">

<?php

$query = $db->query("

SELECT

haftanin_urunleri.urun_id,

urun.id,

urun.baslik,

urun.sef,

urun.eski_fiyat,

urun.fiyat,

urun_img.img

FROM

haftanin_urunleri

INNER JOIN urun ON haftanin_urunleri.urun_id = urun.id

INNER JOIN urun_img ON urun.id = urun_img.urun_id

GROUP BY urun_img.urun_id

ORDER BY haftanin_urunleri.sira ASC

", PDO::FETCH_ASSOC);

if($query->rowCount()){

foreach($query as $row){
?>


<div class="item">
<div class="products">
<div class="hot-deal-wrapper">
<div class="image"> <img src="upload/<?=$row["img"]?>" alt=""> </div>

</div>
<!-- /.hot-deal-wrapper -->

<div class="product-info text-left m-t-20">
<h3 class="name"><a href="urun/<?php echo $row['sef']; ?>/"><?=$row["baslik"]?></a></h3>
<div class="rating rateit-small"></div>
<div class="product-price"> <span class="price"> <?php echo kur(fiyat($row['fiyat']), $_SESSION["kur"]); ?> </span>


<?php if(!empty($row['eski_fiyat'])){ ?>

<span class="price-before-discount"><?php echo kur(fiyat($row['eski_fiyat']), $_SESSION["kur"]); ?></span>
<?php } ?>
</div>
<!-- /.product-price -->

</div>
<!-- /.product-info -->

<div class="cart clearfix animate-effect">
<div class="action">
<div class="add-cart-button btn-group">
<button class="btn btn-primary icon" onclick="location.href='urun/<?php echo $row['sef']; ?>/';" > <i class="fa fa-shopping-cart"></i> </button>
<button class="btn btn-primary cart-btn" onclick="location.href='urun/<?php echo $row['sef']; ?>/';" type="button">Ürünü Görüntüle</button>
</div>
</div>
<!-- /.action -->
</div>
<!-- /.cart -->
</div>
</div>


<?php } } ?>

</div>
<!-- /.sidebar-widget -->
</div>
<!-- ============================================== HOT DEALS: END ============================================== --> </div>
<div class="col-lg-7 col-md-67 col-sm-7 col-xs-12">

<?php

$query = $db->query("SELECT * FROM kampanya ORDER BY sira ASC LIMIT 3", PDO::FETCH_ASSOC);

if($query->rowCount()){
$i = 0;
foreach($query as $row){
$i++;
?>
<?php if($i == 1): ?>
<div class="box1 box-category box-category-wide">
<div class="full-link box-category-image transition" style="background-image:url(upload/<?=$row["img"]?>);"></div>
<div class="full-link1">
<h3><?=$row["baslik1"]?></h3>
<a href="<?=$row["baslik3"]?>" class="btn-link1"><?=$row["baslik2"]?></a>

</div>
</div>

<?php endif; ?>

<?php if($i == 1): ?>

<div class="row">
<?php endif; if($i == 2): ?>

<div class="col col-sm-6">
<div class="box1 box-category">
<div class="full-link box-category-image transition" style="background-image:url(upload/<?=$row["img"]?>);"></div>
<a href="<?=$row["baslik3"]?>" class="full-link"> <span class="btn btn-default"><?=$row["baslik2"]?></span></a>
</div>
</div>
<?php endif; ?>
<?php if($i == 3): ?>

<div class="col col-sm-6">
<div class="box1 box-category">
<div class="full-link box-category-image transition" style="background-image:url(upload/<?=$row["img"]?>);"></div>
<a href="<?=$row["baslik3"]?>" class="full-link"> <span class="btn btn-default"><?=$row["baslik2"]?></span></a>

</div>
</div>
<?php endif; ?>
<?php if($i == 3): ?>

</div>
<?php endif; }} ?>
</div>
</div>

<!-- ============================================== INFO BOXES ============================================== -->
<div class="info-boxes wow fadeInUp" style="margin-bottom:30px">
<div class="info-boxes-inner">
<div class="row">
<div class="header-benefit">
<div class="benefit-icon"><i class="fa fa-credit-card"></i></div>
<h4 class="info-box-heading green">Kredi kartına 12 taksit imkanı</h4>
</div>


<!-- .col -->

<div class="header-benefit">
<div class="benefit-icon"><i class="fa fa-truck"></i></div>
<h4 class="info-box-heading green">1-4 İş günü içerisinde güvenli teslimat</h4>
</div>



<!-- .col -->

<div class="header-benefit">
<div class="benefit-icon"><i class="fa fa-certificate"></i></div>
<h4 class="info-box-heading green">14 Gün içerisinde iade/değişim imkanı</h4>
</div>

<!-- .col -->
</div>
<!-- /.row -->
</div>
<!-- /.info-boxes-inner -->

</div>
<!-- /.info-boxes -->
<!-- ============================================== INFO BOXES : END ============================================== -->



<?php

$query1 = $db->query("SELECT * FROM vitrin_1 ORDER BY sira ASC", PDO::FETCH_ASSOC);

if($query1->rowCount()){

foreach($query1 as $row1){

?>


<section class="section featured-product wow fadeInUp">
<div class="section-title"><h3><?php echo $row1['baslik']; ?></h3></div>
<div class="featured-block">
<div class="owl-carousel home-owl-carousel upsell-product custom-carousel owl-theme outer-top-xs">

<?php

$query = $db->query("SELECT

urun.id,

urun.baslik,

urun.sef,

urun.eski_fiyat,

urun.fiyat,

urun_img.img

FROM

vitrin_urun

INNER JOIN urun ON vitrin_urun.urun_id = urun.id

INNER JOIN urun_img ON urun.id = urun_img.urun_id

WHERE

vitrin_urun.vitrin_id = '{$row1['id']}'

GROUP BY

urun_img.urun_id

ORDER BY

vitrin_urun.sira ASC

", PDO::FETCH_ASSOC);

if($query->rowCount()){

foreach($query as $row){

?>


<div class="item item-carousel">
<div class="products">

<div class="product">
<div class="product-image">
<div class="image">
<a href="urun/<?php echo $row['sef']; ?>/"><img src="upload/<?php echo $row['img']; ?>" alt=""></a>
</div><!-- /.image -->
</div><!-- /.product-image -->

<div class="product-info text-left">
<h3 class="name"><a href="urun/<?php echo $row['sef']; ?>/"><?php echo $row['baslik']; ?></a></h3>
<div class="rating rateit-small"></div>
<div class="description"></div>

<div class="product-price">
<span class="price"><?php echo kur(fiyat($row['fiyat']), $_SESSION["kur"]); ?></span>
<?php if($row["eski_fiyat"]): ?>
<span class="price-before-discount"><?php echo kur(fiyat($row['eski_fiyat']), $_SESSION["kur"]); ?></span>
<?php endif; ?>

</div><!-- /.product-price -->

</div><!-- /.product-info -->
<div class="cart clearfix animate-effect">
<div class="action">
<ul class="list-unstyled">
<li class="add-cart-button btn-group">
<a href="urun/<?php echo $row['sef']; ?>/" class="btn btn-primary icon" data-toggle="dropdown" type="button">
<i class="fa fa-shopping-cart"></i>
</a>
<a href="urun/<?php echo $row['sef']; ?>/" class="btn btn-primary cart-btn" type="button">Ürünü Görüntüle</a>

</li>

<li class="lnk wishlist">
<a class="add-to-cart" href="urun/<?php echo $row['sef']; ?>/" title="Wishlist">
<i class="icon fa fa-heart"></i>
</a>
</li>

</ul>
</div><!-- /.action -->
</div><!-- /.cart -->
</div><!-- /.product -->

</div><!-- /.products -->
</div><!-- /.item -->


<!-- /.item -->


<?php } } ?>

<!-- /.item -->
</div>
</div>
<!-- /.home-owl-carousel -->
</section>
<?php } } ?>


<?php

$query1 = $db->query("SELECT * FROM vitrin ORDER BY sira ASC", PDO::FETCH_ASSOC);

if($query1->rowCount()){

foreach($query1 as $row1){

?>

<!-- ============================================== WIDE PRODUCTS ============================================== -->
<div class="wide-banners wow fadeInUp outer-bottom-xs" style="margin-top: 30px;">
<div class="row">
<div class="col-md-12">
<div class="wide-banner cnt-strip">
<div class="image"> <img class="img-responsive" src="upload/<?php echo $row1['img']; ?>" alt=""> </div>
<div class="strip strip-text">
<div class="strip-inner">
<h2 class="text-right"><?php echo $row1['baslik1']; ?>
<span class="shopping-needs"><?php echo $row1['baslik2']; ?></span></h2>
</div>
</div>
<div class="new-label">
<div class="text">🎁</div>
</div>
<!-- /.new-label -->
</div>
<!-- /.wide-banner -->
</div>
<!-- /.col -->

</div>
<!-- /.row -->
</div>
<!-- /.wide-banners -->
<!-- ============================================== WIDE PRODUCTS : END ============================================== -->

<!-- ============================================== FEATURED PRODUCTS ============================================== -->
<section class="section featured-product wow fadeInUp">
<div class="section-title"><h3><?php echo $row1['baslik']; ?></h3></div>
<div class="featured-block">
<div class="owl-carousel home-owl-carousel upsell-product custom-carousel owl-theme outer-top-xs">

<?php

$query = $db->query("SELECT

urun.id,

urun.baslik,

urun.sef,

urun.eski_fiyat,

urun.fiyat,

urun_img.img

FROM

vitrin_urun

INNER JOIN urun ON vitrin_urun.urun_id = urun.id

INNER JOIN urun_img ON urun.id = urun_img.urun_id

WHERE

vitrin_urun.vitrin_id = '{$row1['id']}'

GROUP BY

urun_img.urun_id

ORDER BY

vitrin_urun.sira ASC

", PDO::FETCH_ASSOC);

if($query->rowCount()){

foreach($query as $row){

?>


<div class="item item-carousel">
<div class="products">

<div class="product">
<div class="product-image">
<div class="image">
<a href="urun/<?php echo $row['sef']; ?>/"><img src="upload/<?php echo $row['img']; ?>" alt=""></a>
</div><!-- /.image -->
</div><!-- /.product-image -->

<div class="product-info text-left">
<h3 class="name"><a href="urun/<?php echo $row['sef']; ?>/"><?php echo $row['baslik']; ?></a></h3>
<div class="rating rateit-small"></div>
<div class="description"></div>

<div class="product-price">
<span class="price"><?php echo kur(fiyat($row['fiyat']), $_SESSION["kur"]); ?></span>
<?php if($row["eski_fiyat"]): ?>
<span class="price-before-discount"> <?php echo kur(fiyat($row['eski_fiyat']), $_SESSION["kur"]); ?> </span>
<?php endif; ?>

</div><!-- /.product-price -->

</div><!-- /.product-info -->
<div class="cart clearfix animate-effect">
<div class="action">
<ul class="list-unstyled">
<li class="add-cart-button btn-group">
<a href="urun/<?php echo $row['sef']; ?>/" class="btn btn-primary icon" data-toggle="dropdown" type="button">
<i class="fa fa-shopping-cart"></i>
</a>
<a href="urun/<?php echo $row['sef']; ?>/" class="btn btn-primary cart-btn" type="button">Ürünü Görüntüle</a>

</li>

<li class="lnk wishlist">
<a class="add-to-cart" href="urun/<?php echo $row['sef']; ?>/" title="Wishlist">
<i class="icon fa fa-heart"></i>
</a>
</li>

</ul>
</div><!-- /.action -->
</div><!-- /.cart -->
</div><!-- /.product -->

</div><!-- /.products -->
</div><!-- /.item -->


<!-- /.item -->


<?php } } ?>

<!-- /.item -->
</div>
</div>
<!-- /.home-owl-carousel -->
</section>
<?php } } ?>

<!-- /.section -->
<!-- ============================================== FEATURED PRODUCTS : END ============================================== -->

<!-- /.row -->

</div>
<!-- /.container -->
</div>
<!-- /#top-banner-and-menu -->