PHP Dosya Yöneticisi

<?php
$query = $db->prepare("SELECT * FROM urun where sef=:sef LIMIT 1");
$urun = $query->execute(array(":sef"=>$_GET['sef']));
$urun = $query->fetch(PDO::FETCH_ASSOC);

if(!$urun){
  echo '<meta http-equiv="refresh" content="0;URL=index.php">';
}

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

<div class="container" <?php if(!empty($urun['video'])){ echo 'data-video="1"'; } ?>>
	<div class="row mt-10 mb-10">
		<div class="col-md-12">
			<ul class="adres_cubugu">
				<li><a href="index.php"><i class="las la-home"></i> Anasayfa</a> <span><i class="las la-angle-right"></i></span></li>
				<li><a href="urun/<?php echo $urun['sef']; ?>/"><?php echo $urun['baslik']; ?></a></li>
			</ul>
		</div>
	</div>
	<div class="row mt-10">
		<div class="col-md-6">
			<div class="p15 bg2 border">
				<div id="sync1" class="owl-carousel mb-15">
					<?php
						if(!empty($urun['video'])){
							echo '<div class="item"><video autoplay loop muted>
													  <source src="upload/'.$urun['video'].'" type="video/mp4" />
													  Your browser does not support the video tag.
													</video></div>';
						}

$alt_img = '';
			            $query = $db->query("SELECT * FROM urun_img WHERE urun_id = '{$urun['id']}' ", PDO::FETCH_ASSOC);
			            if($query->rowCount()){
			              foreach($query as $row){
		          			echo '<div class="item"><img class="img-responsive" src="upload/'.$row['img'].'"></div>';
		          			$alt_img.= '<div class="item"><img class="img-responsive" src="upload/'.$row['img'].'"></div>';
		          		  }
		          		}
		          	?>
		       </div>
		       <div id="sync2" class="owl-carousel hidden-xs">
		          <?php 
		          if(!empty($urun['video'])){
		          	echo '<div class="item"><img class="img-responsive" src="assets/images/video.png"></div>';
		          }
		          echo $alt_img;
		          ?>
		       </div>
	       </div>
		</div>
		<div class="col-md-6">
			<div class="p15 bg2 border urun_detay">

<?php if(isset($_SESSION['admin']['login'])){ ?>
					<a href="<?php echo $site; ?>panel/urun/duzenle/<?php echo $urun['id']; ?>" class="btn btn-success mb-10">Ürünü Düzenle</a>
				<?php } ?>
				<div class="row border-b mb-10"><div class="col-md-12"><h1><?php echo $urun['baslik']; ?></h1></div></div>
				<div class="row">
					<div class="col-md-12">
						<div class="degerlendirme_paylas mb-10">
							<div class="yildiz pull-left">   
				              <span class="aktif">★★★★★</span>
				            </div>
				            <div class="paylas pull-right">
		                        <a href="https://www.facebook.com/sharer.php?u=<?php echo $site.'urun/'.$urun['sef']; ?>" target="_blank">
		                        	<i class="lab la-facebook" data-toggle="tooltip" data-placement="bottom" title="Sosyal Medya'da Paylaş"></i>
		                        </a>
		                        <a href="https://twitter.com/intent/tweet?url=<?php echo $site.'urun/'.$urun['sef']; ?>" target="_blank"s>
		                        	<i class="lab la-twitter" data-toggle="tooltip" data-placement="bottom" title="Sosyal Medya'da Paylaş"></i>
		                        </a>
		                        <a href="http://www.linkedin.com/shareArticle?mini=true&amp;url=<?php echo $site.'urun/'.$urun['sef']; ?>" target="_blank">
		                        	<i class="lab la-linkedin" data-toggle="tooltip" data-placement="bottom" title="Sosyal Medya'da Paylaş"></i>
		                        </a>
		                        <a href="https://api.whatsapp.com/send?text=<?php echo $site.'urun/'.$urun['sef']; ?>" target="_blank">
		                        	<i class="lab la-whatsapp" data-toggle="tooltip" data-placement="bottom" title="Sosyal Medya'da Paylaş"></i>
		                        </a>
		                    </div>
						</div>
						<?php 
						if($urun['marka_id'] != 0){
							$marka = $db->query("SELECT * FROM marka WHERE id = '{$urun['marka_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
						?>
						<div class="marka mb-10">
							<a href="#" data-toggle="tooltip" data-placement="bottom" title="<?php echo $marka['baslik']; ?>"><img src="upload/<?php echo $marka['img']; ?>" alt="<?php echo $marka['baslik']; ?>" title="<?php echo $marka['baslik']; ?>"></a>
						</div>
						<?php } ?>
						<?php 
						if(!empty($urun['kisa_aciklama'])){
						?>
						<div class="pt-10 pb-10">
							<?php echo $urun['kisa_aciklama']; ?>
						</div>
						<?php } ?>
						<div class="stok_kod_durum mb-10">
							<div><span>Stok Kodu : </span><strong><?php echo $urun['stok_kodu']; ?></strong> / <span>Stok Durumu : </span><strong class="durum<?php echo $urun['stok']; ?>"><?php echo $urun['stok'] > 0 ? 'Mevcut' : 'Tükendi'; ?></strong></div> 
						</div>
						<div class="fiyat">
							<?php if(!empty($urun['eski_fiyat'])){ ?>
							<div class="row eski_fiyat border-t">
								<div class="col-md-4">Önceki Fiyat <span class="pull-right">:</span></div>
								<div class="col-md-4"><span><?php echo fiyat($urun['eski_fiyat']); ?> TL</span></div>
								<div class="col-md-4">
					                <div class="eski">
					                  <span style="background: #0d7ef3;color: #fff;font-weight: bold;font-size: 15px;">%<?php echo ceil((($urun['eski_fiyat'] - $urun['fiyat']) / $urun['eski_fiyat']) * 100);  ?> İndirim</span>
					                </div>
								</div>
							</div>
							<?php } ?>
							<div class="row yeni_fiyat border-t border-b">
								<div class="col-md-4"><i class="las la-tags"></i> Fiyat <span class="pull-right">:</span></div>
								<div class="col-md-8"><span data-guncel-fiyat="<?php echo $urun['fiyat']; ?>"><?php echo fiyat($urun['fiyat']); ?> TL</span></div>
							</div>
						</div>
						<?php
					      $query = $db->query("SELECT * FROM urun_secenek WHERE urun_id = '{$urun['id']}' ", PDO::FETCH_ASSOC);
					      if($query->rowCount()){
					        foreach( $query as $row ){
					    ?>
						<div class="row varyant mb-10 border-b pt-10 pb-10">
							<div class="col-md-12">
								<strong><?php echo $row['baslik']; ?></strong>
							</div>
							<div class="col-md-12">
								<ul>
									<?php
							          $query1 = $db->query("SELECT * FROM urun_secenek_alt WHERE urun_secenek_id = '{$row['id']}' ORDER BY id ASC", PDO::FETCH_ASSOC);
							          if($query1->rowCount()){
							            foreach( $query1 as $row1 ){
							            	echo '<li data-stok="'.$row1['stok'].'" data-fiyat="'.$row1['fiyat'].'" data-secenek-id="'.$row1['id'].'">'.$row1['baslik'].'</li>';
							            }
							          }
							        ?>
								</ul>
							</div>
						</div>
						<?php } } ?>

<?php
					      $query = $db->query("SELECT * FROM urun_renk WHERE urun_id = '{$urun['id']}' ", PDO::FETCH_ASSOC);
					      if($query->rowCount()){
					    ?>
						<div class="row varyant4 mb-10 border-b pt-10 pb-10">
							<div class="col-md-12">
								<strong>Diğer Renkler</strong>
							</div>
							<div class="col-md-12">
								<ul>
									<?php
							            foreach( $query as $row1 ){
							            	$u = $db->query("SELECT sef FROM urun WHERE id = '{$row1['renk_urun_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
							            	$uimg = $db->query("SELECT img FROM urun_img WHERE urun_id = '{$row1['renk_urun_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
							            	echo '<li><a href="urun/'.$u['sef'].'/"><img src="upload/'.$uimg['img'].'" style="max-width:80px;" class="img-responsive"></a></li>';
							          }
							        ?>
							     </ul>
							</div>
						</div>
						<?php  } ?>

<div class="row border-b pb-10" id="sepete_ekle_durum"></div>
						<div class="row border-b pb-10 mt-10">
							<div class="adet_butonlar">
								<div class="col-md-3">
									<div class="adet">
										<input type="text" class="form-control"  name="adet" id="adet" value="1">
										<button class="btn arti" ><i class="las la-angle-up"></i></button>
										<button class="btn eksi" ><i class="las la-angle-down"></i></button>
									</div>
								</div>
								<div class="col-md-4">
									<button class="btn btn-primary" data-sepete-ekle="<?php echo $urun['id']; ?>"><i class="las la-shopping-cart"></i> Sepete Ekle</button>
								</div>
								<div class="col-md-5 whatsappdis" style="padding-left: 0px">
									<a href="https://api.whatsapp.com/send?phone=9<?php echo $cek['whatsapp']; ?>&amp;text=<?php echo $site.'urun/'.$urun['sef']; ?> Merhaba, bu ürünü sipariş vermek istiyorum." class="btn btn-success" target="_blank" style="width: 100%;"><i class="lab la-whatsapp"></i> Whatsapp İle Sipariş</a>
								</div>
							</div>
						</div>
					</div>

</div>
			</div>
		</div>
	</div>
	<?php

if($_POST){
			$_POST['yorum'] = strip_tags($_POST['yorum']);
			$islem = $db->prepare("INSERT INTO urun_yorum SET kullanici_id = ?, urun_id = ?, yorum = ?, durum = ?, tarih = ?");
		    $islem = $islem->execute(array($_SESSION['kullanici']['id'],$urun['id'],$_POST['yorum'],0,$time));
		   
		    if($islem){
		       echo '<div class="row yorum_sonuc"><div classs="col-md-12"><center><img src="assets/images/basari.png" class="img-responsive" style="width:100px"><br>Yorumunuz başarı ile oluşturuldu, yönetici onaylandıktan sonra gösterilecektir.</center></div></div>';
		    }else{
		        echo '<div class="row yorum_sonuc"><div classs="col-md-12"><center><img src="assets/images/hata.png" class="img-responsive" style="width:100px"><br>Yorumunuz eklenirken bir hata oluştu.</center></div></div>';
		    }
		    ?>
		    <script type="text/javascript">
		    	$(function(){
		    		$([document.documentElement, document.body]).animate({
				        scrollTop: $(".yorum_sonuc").offset().top
				    }, 2000);
		    	});
		    </script>
		    <?php
		}

?>
	<div class="col-md-12 bg2 border mt-20">
		<div class="row">
			<ul class="urun_detay_tab_1 border-b">
				<li data-utabdis="1">Ürün Açıklaması</li>
				<li data-utabdis="2">Ürün Yorumları</li>
				<li data-utabdis="3">İade Koşulları</li>
			</ul>
			<div class="urun_detay_tab_2">
				<div data-utabic="1"><?php echo $urun['aciklama']; ?></div>
				<div data-utabic="2">
						
						<ul class="media-list">
							<?php
			                  $query = $db->query("
			                  	SELECT
									kullanici.ad,
									urun_yorum.yorum,
									urun_yorum.tarih
									FROM
									urun_yorum
									INNER JOIN kullanici ON urun_yorum.kullanici_id = kullanici.id
									WHERE
									urun_yorum.urun_id = '{$urun['id']}' AND
									urun_yorum.durum = 1
									", PDO::FETCH_ASSOC);
			                  if($query->rowCount()){
			                    foreach($query as $row){
			                       echo'<li class="media">
				                            <div class="media-body">
				                                <h4 class="media-heading">'.$row['ad'].'<br><small>'.date('Y-m-d H:i', $row['tarih']).'</small></h4>
				                                <p>'.$row['yorum'].'</p>
				                            </div>
				                        </li>';
			                    }
			                  }else{
			                  	echo '<li><h3>Yorum bulunamadı..</h3></li>';
			                  }
			                ?>
	                    </ul>
	                    <div style="float: left;width: 100%;">
	                    <?php 
	                    	if(isset($_SESSION['kullanici']['login'])){ ?><br><br><br><br>
	                    <form action="" method="post">
	                    	<div class="row">
	                    		<div class="col-md-6">
	                    			<textarea class="form-control" placeholder="Yorumunuzu Yazınız..." name="yorum" required=""></textarea>
	                    			<button class="btn btn-primary mt-10 pull-right" type="submit">Yorum Yaz</button>
	                    		</div>
	                    	</div>
	                    </form>
	                	<?php 
	                		}else{
	                			echo '<h5>Yorum yapmak için giriş yapmanız gerekiyor...</h5>';
	                		}
	                	?>
	                	</div>

</div>
				<div data-utabic="3">
					<?php
						$iade_kosullari = $db->query("SELECT * FROM sayfa WHERE sef = 'iade-kosullari' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
						echo $iade_kosullari['aciklama'];
					?>
				</div>
			</div>
		</div>
	</div>
 	
    <div class="vitrin_baslik mt-20"><span class="bg3">Popüler Ürünler</span></div>
    <div class="slider1 owl-carousel mb-15" style="width: 100;float: left;">
      <?php
        $query = $db->query("SELECT
							urun.id,
							urun.baslik,
							urun.sef,
							urun.fiyat,
							urun.eski_fiyat,
							urun_img.img
							FROM
							urun
							INNER JOIN urun_img ON urun.id = urun_img.urun_id
							GROUP BY
							urun_img.urun_id
							ORDER BY RAND()
							LIMIT 7

", PDO::FETCH_ASSOC);
        if($query->rowCount()){
          foreach($query as $row){

$imgs = '';
	          $query_img = $db->query("SELECT img FROM urun_img WHERE urun_id = '{$row['id']}'", PDO::FETCH_ASSOC);
	          if($query_img->rowCount()){
	            foreach($query_img as $img){
	              $imgs .= $img['img'].'|';
	            }
	          }

$imgs = rtrim($imgs, '|');
      ?>
      <div class="item">
        <div class="urun">
            <a href="urun/<?php echo $row['sef']; ?>/" title="<?php echo $row['baslik']; ?>" data-img="<?php echo $imgs; ?>"><img src="upload/<?php echo $row['img']; ?>" alt="" title="<?php echo $row['baslik']; ?>"><div></div></a>
            <a href="urun/<?php echo $row['sef']; ?>/" title="<?php echo $row['baslik']; ?>" class="link"><?php echo $row['baslik']; ?></a>
            <div class="fiyat">
                <?php if(!empty($row['eski_fiyat'])){ ?>
                <div class="eski">
                  <span><?php echo fiyat($row['eski_fiyat']); ?> TL</span>
                  <span>%<?php echo ceil((($row['eski_fiyat'] - $row['fiyat']) / $row['eski_fiyat']) * 100);  ?></span>
                </div>
                <?php } ?>
                <span class="guncel"><?php echo fiyat($row['fiyat']); ?> TL</span>
            </div>
          </div>
      </div>
      <?php } } ?>
    </div>

</div>

</style>

İptal

📁 PHP Dosya Yöneticisi

📝 urun.php

📝 urun.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)