PHP Dosya Yöneticisi

<?php

$urun = $db->query("SELECT * FROM urun WHERE dil = '{$dil}' AND link = '{$_GET['link']}' AND durum = 1 LIMIT 1")->fetch(PDO::FETCH_ASSOC);
if(!$urun){
  die('<meta http-equiv="refresh" content="0;URL='.$site.'404">');
}

if(strtolower($dil) == 'tr'){
    $_canonical     = $site.strtolower($sayfa).'/'.$urun['link'];
}else{
    $_canonical     = $site.strtolower($dil).'/'.strtolower($sayfa).'/'.$urun['link'];
}

$yorum_sayisi = $db->query("SELECT count(id) as toplam FROM urun_yorum WHERE urun_id = '{$urun['id']}' AND durum = 1")->fetch(PDO::FETCH_ASSOC);

$_title         =  $urun['baslik'];
$_description   =  $urun['kisa_aciklama'];

$ip = ip();
$ip_kontrol = $db->query("SELECT * FROM goruntulenme_log WHERE urun_id = '{$urun['id']}' AND ip = '{$ip}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
if(!$ip_kontrol){
    $ekle = $db->prepare("INSERT INTO goruntulenme_log SET urun_id = ?, ip = ?");
    $ekle = $ekle->execute(array($urun['id'],$ip));
    $guncelle = $db->prepare("UPDATE urun SET goruntulenme = ? WHERE id = ? LIMIT 1");
    $guncelle = $guncelle->execute(array(($urun['goruntulenme'] + 1),$urun['id']));
}

?>
<main class="main pages">
    <div class="page-header breadcrumb-wrap">
        <div class="container">
            <div class="breadcrumb">
                <a href="<?php echo $site; ?>" rel="nofollow"><i class="fi-rs-home mr-5"></i><?php echo $dil_sabit[0]; ?></a>
                <?php
                    $kategori = $db->query("SELECT ust_kategori, baslik FROM kategori WHERE dil = '{$dil}' AND id = '{$urun['kategori_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
                    $adresle = str_replace(' > ', '<span></span>', ust_kategori_isim_bul($kategori['ust_kategori'],$kategori['baslik'],$dil));
                    if(!empty($adresle)){
                        echo '<span></span>'.$adresle;
                    }
                ?>
                <span></span>[$_title]
            </div>
        </div>
    </div>
    <div class="container mb-30">
        <div class="row">
            <div class="col-xl-10 col-lg-12 m-auto">
                <div class="product-detail accordion-detail">
                    <div class="row  mt-30">
                        <div class="col-md-6 col-sm-12 col-xs-12 mb-md-0 mb-sm-5">
                            <div class="detail-gallery">
                                <span class="zoom-icon"><i class="fi-rs-search"></i></span>
                                <div style="float: left;width: 100%;position: relative;">
                                    <div id="mobilkontrol"></div>
                                    <div class="product-image-slider">
                                        <?php
                                            $alt_img = '';
                                            $query = $db->query("SELECT * FROM urun_resim WHERE dil = '{$dil}' AND urun_id = '{$urun['id']}' ORDER BY sira ASC", PDO::FETCH_ASSOC);
                                            if($query->rowCount()){
                                              foreach($query as $row){
                                                if(empty($alt_img)){
                                                    $_resim = $site.'upload/'.$row['resim'];
                                                }
                                                echo '<figure class="border-radius-10"><img src="upload/'.$row['resim'].'" alt="'.$row['baslik'].'" /></figure>';
                                                $alt_img.= '<div class="border-radius-10"><img src="upload/'.$row['resim'].'" alt="'.$row['baslik'].'" /></div>';
                                              }
                                            }
                                        ?>
                                    </div>
                                </div>
                                <div class="slider-nav-thumbnails">
                                    <?php echo $alt_img; ?>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6 col-sm-12 col-xs-12">
                            <div class="detail-info pr-30 pl-30 pt-30 pb-30">
                                <h1 class="title-detail"><?php echo $urun['baslik']; ?></h1>
                                <div class="clearfix product-price-cover">
                                    <div class="product-price primary-color float-left">
                                        <span class="current-price text-brand" id="guncel_fiyat">
                                            <?php echo urun_fiyat($urun['fiyat'],$urun['kur_tipi'],$bayi_id,$urun['kategori_id'],1); ?> TL
                                        </span>
                                        <?php if(!empty($urun['piyasa_fiyat'])){ ?>
                                        <span>
                                            <span class="save-price font-md color3 ml-15">
                                                <?php echo fiyat_noktali(100 - (($urun['fiyat'] / $urun['piyasa_fiyat']) * 100)); ?> % <?php echo $dil_sabit[21]; ?>
                                            </span>
                                            <span class="old-price font-md ml-15">
                                                <?php echo urun_fiyat($urun['piyasa_fiyat'],$urun['kur_tipi'],$bayi_id,$urun['kategori_id'],1); ?> TL
                                            </span>
                                        </span>
                                        <?php } ?>
                                        <?php
                                        $marka_adi = $ayar['title'];
                                        if(!empty($urun['marka_id'])){
                                            $marka = $db->query("SELECT * FROM marka WHERE id = '{$urun['marka_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
                                            $marka_adi = $marka['baslik'];
                                        ?>
                                        <span style="margin-left: 10px; text-align: center; border: 1px solid #ddd; padding: 5px 9px; font-weight: bold; border-radius: 10px;">
                                            <img src="upload/<?php echo $marka['resim']; ?>" alt="<?php echo $marka['baslik']; ?>" style="max-width: 150px;">
                                        </span>
                                        <?php } ?>
                                    </div>
                                </div>

<?php if(!empty($urun['stok_kodu'])){ ?>
                                <div class="short-desc mb-10"><p class="font-lg"><?php echo $urun['stok_kodu']; ?></p></div>
                                <?php } ?>

<?php if(!empty($urun['kisa_aciklama'])){ ?>
                                <div class="short-desc mb-10"><p class="font-lg"><?php echo $urun['kisa_aciklama']; ?></p></div>
                                <?php } ?>

<?php
                                $varyant = $db->query("SELECT id, baslik FROM urun_varyant WHERE dil = '{$dil}' AND urun_id = '{$urun['id']}'", PDO::FETCH_ASSOC);
                                if($varyant->rowCount()){
                                    foreach($varyant as $v){
                                ?>
                                <div class="attr-detail attr-size mb-10">
                                    <strong class="mr-10"><?php echo $v['baslik']; ?>: </strong>
                                    <ul class="list-filter size-filter font-small" data-anavaryant-id-dis="<?php echo $v['id']; ?>">
                                        <?php
                                        $alt_varyant = $db->query("SELECT id, baslik FROM urun_varyant_secenek WHERE dil = '{$dil}' AND urun_id = '{$urun['id']}' AND urun_vayant_id = '{$v['id']}' ", PDO::FETCH_ASSOC);
                                        if($alt_varyant->rowCount()){
                                            foreach($alt_varyant as $av){
                                                echo '<li data-alt-varyant-id="'.$av['id'].'" data-ana-varyant-id="'.$v['id'].'"><a href="#">'.$av['baslik'].'</a></li>';
                                            }
                                        }
                                        ?>
                                    </ul>
                                </div>
                                <?php }  } ?>

<div class="detail-extralink">
                                    <div class="detail-qty border radius" style="">
                                        <a href="#" class="qty-down"><i class="fi-rs-angle-small-down"></i></a>
                                        <span class="qty-val">1</span>
                                        <a href="#" class="qty-up"><i class="fi-rs-angle-small-up"></i></a>
                                    </div>
                                    <div class="product-extra-link2">
                                        <button type="submit" class="button button-add-to-cart" id="ekle"><i class="fi-rs-shopping-cart"></i><?php echo $dil_sabit[3]; ?></button>
                                        <a href="https://api.whatsapp.com/send?phone=9<?php echo $ayar['whatsapp']; ?>&text=Merhaba, <?php echo $site.'urun/'.$urun['link']; ?> <?php echo $dil_sabit[207]; ?>" style="background: #12bd60;" class="whatsapp_buton" target="_blank"><i class="la la-whatsapp ozelwp"></i><?php echo $dil_sabit[4]; ?></a>
                                        <a href="javascript:void(0)" data-favori-ekle="<?php echo $urun['id']; ?>" class="action-btn hover-up"><i class="fi-rs-heart"></i></a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="product-info mt-20">
                        <?php
                            if(isset($_SESSION['kullanici']['giris']) AND $_POST AND !empty($_POST['yorum']) AND $_POST['oran'] > 0 AND $_POST['oran'] < 6){
                                $islem = $db->prepare("INSERT INTO urun_yorum SET musteri_id = ?, urun_id = ?, yorum = ?, tarih = ?, durum = ?,  oran = ?");
                                $islem = $islem->execute(array($_SESSION['kullanici']['id'],$urun['id'],$_POST['yorum'],$tarih,0,$_POST['oran']));
                                if($islem){
                                    echo '<div class="alert alert-success" role="alert">
                                          <h4 class="alert-heading">'.$dil_sabit[5].'</h4>
                                          <p>'.$dil_sabit[6].'</p>
                                        </div>';
                                }else{
                                    echo '<div class="alert alert-danger" role="alert">
                                          <h4 class="alert-heading">'.$dil_sabit[7].'</h4>
                                          <p>'.$dil_sabit[8].'</p>
                                        </div>';
                                }
                                ?>
                                <script type="text/javascript">
                                    $(function(){
                                        $(window).on("load", function () {
                                            $([document.documentElement, document.body]).animate({
                                                scrollTop: $('.product-info').offset().top - 120
                                            }, 1000);
                                        });
                                    });
                                </script>
                                <?php
                            }
                        ?>
                        <div class="tab-style3">
                            <ul class="nav nav-tabs text-uppercase">
                                <li class="nav-item">
                                    <a class="nav-link active" id="aciklama-tab" data-bs-toggle="tab" href="#aciklama"><?php echo $dil_sabit[9]; ?></a>
                                </li>
                                <li class="nav-item">
                                    <a class="nav-link" id="yorum-tab" data-bs-toggle="tab" href="#yorum"><?php echo $dil_sabit[10]; ?> (<?php echo $yorum_sayisi['toplam']; ?>)</a>
                                </li>
                            </ul>
                            <div class="tab-content shop_info_tab entry-main-content">
                                <div class="tab-pane fade show active" id="aciklama">
                                    <div class=""><?php echo $urun['aciklama']; ?></div>
                                </div>
                                <div class="tab-pane fade" id="yorum">
                                    <div class="comments-area">
                                        <div class="row">
                                            <div class="col-lg-8">
                                                <h4 class="mb-30"><?php echo $dil_sabit[11]; ?></h4>
                                                <div class="comment-list">
                                                <?php
                                                    $query = $db->query("SELECT * FROM urun_yorum WHERE urun_id = '{$urun['id']}' AND durum = 1 ORDER BY id ASC", PDO::FETCH_ASSOC);
                                                    if($query->rowCount()){
                                                        foreach($query as $row){
                                                            $musteri = $db->query("SELECT ad, soyad FROM musteri WHERE id = '{$row['musteri_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
                                                            echo '<div class="single-comment mb-30">
                                                                <div class="user justify-content-between d-flex">
                                                                    <div class="thumb text-center">
                                                                        <img src="assets/images/pp.png" /><br>
                                                                        <a href="#" class="font-heading text-brand">'.$musteri['ad'].' '.$musteri['soyad'][0].'.</a>
                                                                    </div>
                                                                    <div class="desc" style="width:100%">
                                                                        <div class="b-10" style="float:left;width:100%;">
                                                                            <span class="font-xs text-muted">'.date('Y-m-d H:i:s',$row['tarih']).'</span>
                                                                            <div class="product-rate d-inline-block" style="float:right;">
                                                                                <div class="product-rating" style="width: '.($row['oran'] * 20).'%"></div>
                                                                            </div>
                                                                        </div>
                                                                        <p class="mb-10" style="width:100%;float:left;">'.$row['yorum'].'</p>
                                                                    </div>
                                                                </div>
                                                            </div>';
                                                        }
                                                    }else{
                                                        echo '<div class="single-comment justify-content-between d-flex mb-30">
                                                                <div class="user justify-content-between d-flex">
                                                                    <div class="desc">
                                                                        <p class="mb-10">'.$dil_sabit[12].'</p>
                                                                    </div>
                                                                </div>
                                                            </div>';
                                                    }
                                                ?>
                                                </div>
                                                <div class="comment-form">
                                                    <?php if(isset($_SESSION['kullanici']['giris'])){ ?>
                                                    <h4 class="mb-15"><?php echo $dil_sabit[13]; ?></h4>
                                                    <div class="row">
                                                        <div class="col-lg-8 col-md-12">
                                                            <form class="form-contact comment_form" action="" method="post">
                                                                <div class="row">
                                                                    <div class="col-12">
                                                                        <div class="form-group custom_select">
                                                                            <select class="form-control select-active" name="oran" required>
                                                                                <option value="5">5 <?php echo $dil_sabit[14]; ?></option>
                                                                                <option value="4">4 <?php echo $dil_sabit[14]; ?></option>
                                                                                <option value="3">3 <?php echo $dil_sabit[14]; ?></option>
                                                                                <option value="2">2 <?php echo $dil_sabit[14]; ?></option>
                                                                                <option value="1">1 <?php echo $dil_sabit[14]; ?></option>
                                                                            </select>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-12">
                                                                        <div class="form-group">
                                                                            <textarea class="form-control w-100" name="yorum" placeholder="<?php echo $dil_sabit[13]; ?>" required></textarea>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="form-group">
                                                                    <button type="submit" class="button button-contactForm"><?php echo $dil_sabit[15]; ?></button>
                                                                </div>
                                                            </form>
                                                        </div>
                                                    </div>
                                                    <?php }else{ ?>
                                                    <h4 class="mb-15"><?php echo $dil_sabit[16]; ?></h4>
                                                    <?php } ?>
                                                </div>
                                            </div>
                                            <div class="col-lg-4">
                                                <h4 class="mb-30"><?php echo $dil_sabit[17]; ?></h4>
                                                <div class="d-flex mb-30">
                                                    <div class="product-rate d-inline-block mr-15">
                                                        <div class="product-rating" style="width: <?php echo (yildiz($urun['id']) * 20); ?>%"></div>
                                                    </div>
                                                    <h6><?php echo yildiz($urun['id']); ?> / 5</h6>
                                                </div>
                                                <?php
                                                    $yildiz_1 = yildiz_sayisi($urun['id'],1);
                                                    $yildiz_2 = yildiz_sayisi($urun['id'],2);
                                                    $yildiz_3 = yildiz_sayisi($urun['id'],3);
                                                    $yildiz_4 = yildiz_sayisi($urun['id'],4);
                                                    $yildiz_5 = yildiz_sayisi($urun['id'],5);
                                                ?>
                                                <div class="progress">
                                                    <span>5 <?php echo $dil_sabit[14]; ?></span>
                                                    <div class="progress-bar" role="progressbar" style="width: <?php echo $yildiz_5; ?>%" aria-valuenow="<?php echo $yildiz_5; ?>" aria-valuemin="0" aria-valuemax="100"><?php echo $yildiz_5; ?>%</div>
                                                </div>
                                                <div class="progress">
                                                    <span>4 <?php echo $dil_sabit[14]; ?></span>
                                                    <div class="progress-bar" role="progressbar" style="width: <?php echo $yildiz_4; ?>%" aria-valuenow="<?php echo $yildiz_5; ?>" aria-valuemin="0" aria-valuemax="100"><?php echo $yildiz_4; ?>%</div>
                                                </div>
                                                <div class="progress">
                                                    <span>3 <?php echo $dil_sabit[14]; ?></span>
                                                    <div class="progress-bar" role="progressbar" style="width: <?php echo $yildiz_3; ?>%" aria-valuenow="<?php echo $yildiz_5; ?>" aria-valuemin="0" aria-valuemax="100"><?php echo $yildiz_3; ?>%</div>
                                                </div>
                                                <div class="progress">
                                                    <span>2 <?php echo $dil_sabit[14]; ?></span>
                                                    <div class="progress-bar" role="progressbar" style="width: <?php echo $yildiz_2; ?>%" aria-valuenow="<?php echo $yildiz_5; ?>" aria-valuemin="0" aria-valuemax="100"><?php echo $yildiz_2; ?>%</div>
                                                </div>
                                                <div class="progress">
                                                    <span>1 <?php echo $dil_sabit[14]; ?></span>
                                                    <div class="progress-bar" role="progressbar" style="width: <?php echo $yildiz_1; ?>%" aria-valuenow="<?php echo $yildiz_5; ?>" aria-valuemin="0" aria-valuemax="100"><?php echo $yildiz_1; ?>%</div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <?php
                        $alt_kategoriler = alt_kategori_id_bul($urun['id']);
                        $query = $db->query("SELECT id FROM urun WHERE dil = '{$dil}' AND durum = 1 AND kategori_id in({$alt_kategoriler}) ORDER BY goruntulenme ASC LIMIT 7", PDO::FETCH_ASSOC);
                        if($query->rowCount()){
                            $urun_id = array();
                            foreach($query as $row){
                                $urun_id[] = $row['id'];
                            }
                        }else{
                            $query = $db->query("SELECT id FROM urun WHERE dil = '{$dil}' AND durum = 1  ORDER BY rand() LIMIT 7", PDO::FETCH_ASSOC);
                            if($query->rowCount()){
                                $urun_id = array();
                                foreach($query as $row){
                                    $urun_id[] = $row['id'];
                                }
                            }
                        }
                        $row['baslik'] = $dil_sabit[18];
                        $row['id'] = 1;
                        include 'inc/vitrin-3.php';
                    ?>
                </div>
            </div>
        </div>
    </div>
</main>
<style type="text/css">
    @media only screen and (max-width:600px){
        #mobilkontrol{position: absolute; width: 100%; height: 100%; z-index: 99999;}
    }
</style>
<script type="application/ld+json">
    {
        "@context": "https://schema.org",
        "@type": "BreadcrumbList",
        "itemListElement":[{
            "@type": "ListItem",
            "position": 1,
            "name": "Anasayfa",
            "item": "<?php echo $site; ?>"
        }
        <?php
        if(!empty($adresle)){
            $sirasi = 2;
            foreach(explode('<span></span>', $adresle) as $adres){
                if(!empty($adres)){
                    if(strtolower($dil) == 'tr'){
                        $jsonadres     = $site.'kategori/'.sef($adres);
                    }else{
                        $jsonadres     = $site.strtolower($dil).'/'.'kategori/'.sef($adres);
                    }
                    echo ',{
                                "@type": "ListItem",
                                "position": '.$sirasi.',
                                "name": "'.$adres.'",
                                "item": "'.$jsonadres.'"
                            }';
                    $sirasi++;
                }
            }
        }
        ?>
        ]
    }
</script>
<script type="application/ld+json">
  {
    "@context": "https://schema.org/",
    "@type": "Product",
    "name": "<?php echo $urun['baslik']; ?>",
    "image": ["[$_resim]"],
    "description": "<?php echo $urun['kisa_aciklama']; ?>",
    "sku": "<?php echo $urun['stok_kodu']; ?>",
    "brand": {
      "@type": "Brand",
      "name": "<?php echo $marka_adi; ?>"
    },
    "review": {
      "@type": "Review",
      "reviewRating": {
        "@type": "Rating",
        "ratingValue": "<?php echo yildiz($urun['id']); ?>",
        "bestRating": "5"
      },
      "author": {
        "@type": "Person",
        "name": "<?php echo $ayar['title']; ?>"
      }
    },
    "aggregateRating": {
      "@type": "AggregateRating",
      "ratingValue": "<?php echo yildiz($urun['id']); ?>",
      "reviewCount": "<?php echo $yorum_sayisi['toplam'] == 0 ? 1 : $yorum_sayisi['toplam']; ?>"
    },
    "offers": {
      "@type": "AggregateOffer",
      "offerCount": "<?php echo $urun['stok']; ?>",
      "lowPrice": "<?php echo number_format($urun['fiyat'], 0, '', '.'); ?>",
      "priceCurrency": "TRY"
    }
  }
</script>

İptal

📁 PHP Dosya Yöneticisi

📝 urun.php

📝 urun.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)