Sitemde fiyat 2x cıkıyor ?

<?php require('ust.php'); ?>
<title>Alışveriş Sepetim - <?php echo $ayar['siteadi']; ?></title>


<meta name="description" content="<?php echo $ayar['des']; ?>">
<meta name="keywords" content="<?php echo $ayar['keyw']; ?>">

<?php require('menu.php'); ?>
<style>
    .kayit {
        display: flex;
    }
    .mobil-sepet-baslik {
        display: none;
    }
    .mobil-sepet-baslik1 {
        display: none;
    }
    .mobil-sepet-icerik {
        text-align: center;
    }
    .mobil-sepet-deger {
        text-align: center;
    }
    @media screen and (max-device-width: 480px) and (orientation: portrait) {
        .mobil-sepet-icerik {
            text-align: left;
        }
        .mobil-sepet-deger {
            text-align: left;
        }
        .bos {
            margin-left: -300px;
            margin-top: -20px;
        }
        .kayit {
            display: block;
        }
        .mobil-sepet-baslik {
            display: block;
            float: left;
            width: 50%;
            margin-right: 10px;
            font-weight: bold;
            font-size: 12px;
            line-height: 20px;
            height: 40px;
        }
        .mobil-sepet-baslik1 {
            display: block;
            float: left;
            width: 25%;
            margin-right: 10px;
            line-height: 20px;
            height: 40px;
            font-weight: bold;
            font-size: 12px;
        }
        .kolon8{
            font-size: 26px;
        }
        .kolon9{
            font-size: 26px;
        }
    }
</style>
<?php
if (isset($_POST['ekurunekledim'])) {
    $sepet = $_POST['sepet'];
    $ip = $_POST['ip'];
    $ekurun = $_POST['ekurun'];
    $ekurunfiyat = $_POST['ekurunfiyat'];
    $ekekle = $DB->prepare("insert into ekurun set sepet=?, ip=?, ekurun=?, ekurunfiyat=?");
    $ekekle->execute(array($sepet, $ip, $ekurun, $ekurunfiyat));

    if ($ekekle) {
        echo "<script type='text/javascript'>alert('Ek ürün sepetinize eklendi');</script>";
        echo '<meta http-equiv="refresh" content="0; url=sepet.html">';

    } else {
        echo "<script type='text/javascript'>alert('Ek Ürün Eklenemedi!');</script>";

    }

}; ?>


<div class="main-content shop-page shoppingcart-content">
    <div class="container">
        <!--<div class="breadcrumbs">
            <a href="index.html">ANASAYFA</a> / <span class="current">ALIŞVERİŞ SEPETİ</span>
        </div>-->
        <div class="row content-form" style="margin-top:30px">


            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12 content-offset">
                <?php
                $ip = ipAl();
                $sepetkontrol = $DB->prepare("SELECT * FROM sepet WHERE ip=?");
                $sepetkontrol->execute(array($ip));
                if ($sepetkontrol->rowCount()) {

                    foreach ($sepetkontrol as $value) {
                        $urFiyat += ($value['fiyat'] + $value['ekfiyat']) * $value['urunAdet'];
                    }
                    $topFiyat = $urFiyat;

                    $ytutar = number_format($topFiyat, 2, ",", ".");


                }


                if ($sepetkontrol->rowCount() == 0){
                    ?>
                    <div class="bos"><a href="index.html"/></a></div>
                    <div align="center"><img src="/img/sepett.png" width="200" style="margin-right:50px"/></div>
                    <div align="center"><h1 style="font-size:30px;">Sepetiniz henüz boş</h1></div><br>
                    <div align="center"><a href="https://redgardencicekcilik.com/">
                            <button class="bubbly-button" style="background-color:#607160">ALIŞVERİŞE DEVAM ET</button>
                        </a></div><br><br>
                <?php } else { ?>
                <br>
                <br>
                <br>
                <br>
                <br>
                <br>

                <div id="target">
                    <div class="cart-content">
                        <div class="row hidden-xs" style="display: flex; align-items: center;justify-content: center;">
                                <div class="col-md-2" style="text-align: center" product-thumb">ÜRÜN RESMİ</div>
                                <div class="col-md-2" style="text-align: center" product-name">ÜRÜN ADI</div>
                                <div class="col-md-2" style="text-align: center" price">BİRİM FİYATI</div>
                                <div class="col-md-1" style="text-align: center" quantity-item">ADET</div>
                                <div class="col-md-2" style="text-align: center" price">ULAŞIM BEDELİ</div>
                                <div class="col-md-1" style="text-align: center" quantity-item">KDV</div>
                                <div class="col-md-1" style="text-align: center" total">TOPLAM</div>
                                <div class="col-md-1" style="text-align: center" delete-item">SİL</div>
                        </div>


                    <?php

                    if ($sepetkontrol->rowCount()) {
                        $uysepet = $DB->prepare("SELECT * FROM urunler
                                    INNER JOIN sepet ON urunler.urunid = sepet.urunid  
                                    WHERE sepet.ip=? ORDER BY sepet.sepetId DESC");
                        $uysepet->execute(array($ip));
                        foreach ($uysepet as $sepet) {
                            $sepFiy = $sepet['fiyat'] + $sepet['ekfiyat'];
                            $sepetFiyat = number_format($sepFiy, 2, ',', '.');

                            ?>
                            <hr>
                            <div class="row kayit">
                                <div class="col-md-2 kolon1 product-thumb"><a
                                            href="urunler/<?php echo $sepet['seo'] ?>.html"><img
                                                src="images/urunler/thumb-<?php echo $sepet['resim'] ?>" alt="urun"></a>
                                </div>
                                <div class="col-md-2  kolon2 product-name" data-title="Ürün Adı">
                                    <div style="display: flex;">
                                        <span class="mobil-sepet-baslik1">ÜRÜN ADI :</span>
                                        <span  class="mobil-sepet-deger">
                                        <a
                                                href="urunler/<?php echo $sepet['seo'] ?>.html"
                                                class="product-name"><?php echo $sepet['urunAdi'] ?>
                                            </br>
                                            <?php echo $sepet['urunozellik'] ?>
                                            <?php echo $sepet['uoz'] ?>


                                        </a>
                                        </span>
                                    </div>
                                </div>
                                <div class="col-md-2 col-xs-6 text-center kolon3 price" data-title="Birim Fiyatı">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">BİRİM FİYAT :</span>
                                        <span  class="mobil-sepet-deger"> <?php echo $goster = $sepet['fiyat'] - $sepet['kdv']; ?> TL</span>
                                    </div>
                                </div>
                                <div class="col-md-1 col-xs-6 text-center kolon4 quantity-item" data-title="Adet">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">MİKTAR :</span>
                                        <span class="mobil-sepet-deger"> <?php echo $sepet['urunAdet'] ?> ADET</span>
                                    </div>
                                </div>
                                <div class="col-md-2 col-xs-6 text-center kolon6 quantity-item" data-title="Ulaşım Bedeli">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">ULAŞIM BEDELİ :</span>
                                        <span class="mobil-sepet-deger"> <?php echo $sepet['ekfiyat'] ?> TL</span>
                                    </div>
                                </div>
                                <div class="col-md-1 col-xs-6 text-center kolon7 quantity-item" data-title="Kdv">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">KDV :</span>
                                        <span class="mobil-sepet-deger"> <b> % <?php echo $sepet['oran'] ?> KDV </b>
                                            </br>
                                            <?php echo $sepet['kdv'] ?> TL</span>
                                    </div>


                                </div>
                                <div class="col-md-1 col-xs-12 kolon8 total text-center" data-title="Toplam"><?php $sepetson = $sepet['fiyat'] + $sepet['ekfiyat'];
                                    echo $sepettoplam = $sepet['urunAdet'] * $sepetson;

                                    ?> TL </div>
                                <div class="col-md-1 col-xs-12 kolon9 delete-item text-center" data-title="Sil"><a href="sepet.html?sepetID=<?php echo $sepet['sepetId']; ?>"><i class="fa fa-times" aria-hidden="true"></i></a></div>
                            </div>


                        <?php }
                    } ?>
                    <?php
                    $sepetim = $sepet['sepetId'];
                    $ip = ipAl();
                    $baksana = $DB->query("select * from ekurun where sepet='$sepetim' order by id asc")->fetchAll(PDO::FETCH_ASSOC);
                    foreach ($baksana as $muslera) {
                        ?>
                        <?php $ekurunbak = $muslera['ekurun']; ?>
                        <?php $gss = $DB->query("select * from ozellik where durum='1' and id='$ekurunbak' order by id asc")->fetchAll(PDO::FETCH_ASSOC);
                        foreach ($gss as $cimbom) {
                            ?>
                            <hr>
                            <div class="row kayit">
                                <div class="col-md-2 kolon1 product-thumb text-center">
                                    <a href=""><img src="images/ozellik/thumb-<?php echo $cimbom['resim'] ?>"
                                                    alt="urun"></a>
                                </div>
                                <div class="col-md-2  kolon2 product-name" data-title="Ürün Adı">
                                    <div style="display: flex;">
                                        <span class="mobil-sepet-baslik1">ÜRÜN ADI :</span>
                                        <span  class="mobil-sepet-deger">
                                        <?php echo $cimbom['baslik'] ?>
                                        </span>
                                    </div>
                                </div>
                                <div class="col-md-2 col-xs-6 text-center kolon3 price" data-title="Birim Fiyatı">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">BİRİM FİYAT :</span>
                                        <span  class="mobil-sepet-deger"> <?php echo $muslera['ekurunfiyat']; ?> TL</span>
                                    </div>
                                </div>
                                <div class="col-md-1 col-xs-6 text-center kolon4 quantity-item" data-title="Adet">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">MİKTAR :</span>
                                        <span class="mobil-sepet-deger"> 1 ADET</span>
                                    </div>
                                </div>
                                <div class="col-md-2 col-xs-6 text-center kolon6 quantity-item" data-title="Ulaşım Bedeli">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">ULAŞIM BEDELİ :</span>
                                        <span class="mobil-sepet-deger"> 0 TL</span>
                                    </div>
                                </div>
                                <div class="col-md-1 col-xs-6 text-center kolon7 quantity-item" data-title="Kdv">
                                    <div class="mobil-sepet-icerik">
                                        <span class="mobil-sepet-baslik">KDV :</span>
                                        <span class="mobil-sepet-deger"> EK ÜRÜN</span>
                                    </div>


                                </div>
                                <div class="col-md-1 col-xs-12 kolon8 total text-center" data-title="Toplam">
                                    <?php echo $muslera['ekurunfiyat']; ?> TL
                                </div>
                                <div class="col-md-1 col-xs-12 kolon9 delete-item text-center" data-title="Sil"><a href="ekurunsil=<?php echo $muslera['id']; ?>"><i class="fa fa-times" aria-hidden="true"></i></a></div>
                            </div>
                        <?php }
                    } ?>


                    <tr class="checkout-cart group-button">
                        <td colspan="7" class="left" style="height:0">
                            <div class="left">
                                <form action="" method="POST"/>
                                <input type="hidden" value="<?php echo $ip; ?>" name="ip"/>
                                </form>
                            </div>
                            <div class="right">

                                <form action="" method="POST"/>
                                <input type="hidden" value="<?php echo $ip; ?>" name="ip"/>
                                <div class="row">
                                    <div class="col-md-6 col-xs-6">
                                        <input type="text" placeholder="Kupon Kodunu Giriniz" class="input-info"
                                               style="width: 100%;border-radius: 4px;border: 2px solid #a4a5a799;height: 40px;" name="kupon"/>
                                    </div>
                                    <div class="col-md-6 col-xs-6">
                                        <button class="btn btn-success" style="background-color: #00b556; width: 100%;height: 40px; line-height: 40px;padding: 0;" type="submit"
                                                name="sepetguncelle">SEPETİ GÜNCELLE
                                        </button>
                                    </div>
                                </div>


                                </form>
                            </div>
                        </td>
                    </tr>


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


        <div class="col-xs-12 col-sm-12 col-md-8 col-lg-8" style="padding-right: 20px;">
            <div id="target">
                <div class="cart-content" style="padding-bottom: 60px;">
                    <div class="shopping-cart-content">
                        <div class="text row">
                            <div class="row" align="center" style="margin-top:15px;margin-bottom:15px;">
                                <a class="product-thumb" style="font-weight: bold;
    color: #000000;text-align:center;padding:15px">EK ÜRÜNLER</a></div>

                        </div>


                        <div class="row">

                            <?php $ekurunler = $DB->query("select * from ozellik where durum='1' order by id asc")->fetchAll(PDO::FETCH_ASSOC);
                            foreach ($ekurunler as $ekurunlerimiz) {
                                ?>

                                <div class="col-md-4 col-xs-6">

                                    <img src="images/ozellik/thumb-<?php echo $ekurunlerimiz['resim']; ?>" alt="urun">
                                    <br>
                                    <p style="font-size: 12px;color: #000000;line-height: 18px; height:60px; font-weight: bold;"><?php echo $ekurunlerimiz['baslik']; ?></p>
                                    <br >
                                    <p style="font-size: 18px;color: #ed2c7a;line-height: 20px; height:20px; font-weight: bold;"><?php echo $ekurunlerimiz['link']; ?> TL</p>
                                    <br>
                                    <form action="" method="POST"/>
                                    <input type="hidden" value="<?php echo $ip; ?>" name="ip"/>
                                    <input type="hidden" value="<?php echo $sepet['sepetId']; ?>" name="sepet"/>
                                    <input type="hidden" value="<?php echo $ekurunlerimiz['id']; ?>" name="ekurun"/>
                                    <input type="hidden" value="<?php echo $ekurunlerimiz['link']; ?>"
                                           name="ekurunfiyat"/>
                                    <button class="bubbly-buttons" style="background-color: #E00103;width: 104px !important;" type="submit" name="ekurunekledim">EKLE</button>
                                    </form>
                                </div>

                            <?php } ?>

                        </div>


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


        <div class="col-xs-12 col-sm-12 col-md-4 col-lg-4 ">
            <div class="proceed-checkout">

                <div class="content">
                    <h4 class="main-title">ALIŞVERİŞ DETAYLARI</h4>
                    <h5 class="title">ÖDEME BİLGİLERİ</h5>
                    <?php $query = $DB->query("SELECT SUM(kdv) FROM sepet WHERE ip='$ip'")->fetch(PDO::FETCH_ASSOC);
                    foreach ($query as $row) {
                        ?>
                        <?php $kargom = $DB->query("SELECT SUM(ekfiyat) FROM sepet WHERE ip='$ip'")->fetch(PDO::FETCH_ASSOC);
                        foreach ($kargom as $ulkargom) {
                            ?>
                            <div class="info-checkout">
                                <span class="text">Ara Tutar : </span><span
                                        class="item"><?php echo $aratutar = $topFiyat - $row - $ulkargom; ?> TL</span>
                            </div>
                            <div class="info-checkout">
                                <span class="text">KDV Bedeli : </span><span class="item"><?php echo $row; ?> TL</span>
                            </div>
                        <?php } ?>

                        <div class="info-checkout shipping">
                            <span class="text">Toplam Yol Ucreti :</span><span class="item"><?php echo $ulkargom; ?>
                                TL</span>
                        </div>
                    <?php } ?>

                    <?php
                    $eksepetim = $sepet['sepetId'];
                    $ekurunekledim = $DB->query("SELECT SUM(ekurunfiyat) FROM ekurun WHERE sepet='$eksepetim'")->fetch(PDO::FETCH_ASSOC);
                    foreach ($ekurunekledim as $ekurununfiyati) {
                        ?>
                        <?php if ($ekurununfiyati > '0') { ?>
                            <div class="info-checkout shipping">
                                <span class="text">Ek Ürünlerin Bedeli :</span><span
                                        class="item"><?php echo $ekurununfiyati; ?> TL</span>
                            </div>
                        <?php } ?>
                    <?php } ?>


                    <?php if ($sepet['kupon'] > '0') { ?>
                        <div class="info-checkout shipping">
                            <span class="text" style="font-size: 12px;color: red !important;font-weight: bold;">İndirim Kuponu Bedeli :</span><span
                                    class="item"
                                    style="font-size: 13px;color: red !important;font-weight: bold;">- <?php echo $sepet['kupon']; ?>
                                TL <a href="sepet.html?kuponsil=<?php echo $sepet['sepetId']; ?>"><i class="fa fa-times"
                                                                                                     aria-hidden="true"></i></a></span>
                        </div>
                    <?php } ?>
                    <div class="total-checkout">
                        <span class="text">Ödenecek Tutar </span><span
                                class="price"><?php echo $ode = $ekurununfiyati + $topFiyat - $sepet['kupon']; ?>
                            TL</span>
                    </div>

                    <div class="group-button">
                        <a style="width: 100%!important; font-weight: bold; padding: 15px;height: 100%;" href="satin-al.html" class="btn btn-success form-control">SONRAKİ ADIM</a>
                    </div>


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


    <?php } ?>


</div>
</div>


<?php require('footer.php'); ?>