PHP Dosya Yöneticisi

<?php

$query = $db->prepare("SELECT * FROM kategori where sef=:sef LIMIT 1");

$kategori = $query->execute(array(":sef"=>$_GET['sef']));

$kategori = $query->fetch(PDO::FETCH_ASSOC);

if(!$kategori){

echo '<meta http-equiv="refresh" content="0;URL=index.php">';

}

$_title         =  $kategori['baslik'];

$_description   =  $kategori['kisa_aciklama'];

<li><a href="index.php"><i class="las la-home"></i> Anasayfa</a> <span><i class="las la-angle-right"></i></span></li>

</ul>

</div>

</div>

<?php

$bir_ust = $db->query("SELECT * FROM kategori WHERE id = '{$kategori['ust_kategori']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if($bir_ust){

echo '<li><a href="kategori/'.$bir_ust['sef'].'/" title="" style="font-weight: bold;color: green;"><i class="las la-angle-right"></i> Üst Kategoriye Dön</a></li>';

}

$query = $db->query("SELECT * FROM kategori WHERE ust_kategori = '{$kategori['id']}' ORDER BY sira ASC", PDO::FETCH_ASSOC);

if($query->rowCount()){

foreach($query as $row){

echo '<li><i class="las la-angle-right"></i><a href="kategori/'.$row['sef'].'/" title="'.$row['baslik'].'">'.$row['baslik'].'</a></li>';

}

}else{

$query = $db->query("SELECT * FROM kategori WHERE ust_kategori = '{$kategori['ust_kategori']}' ORDER BY sira ASC", PDO::FETCH_ASSOC);

if($query->rowCount()){

foreach($query as $row){

echo '<li><i class="las la-angle-right"></i><a href="kategori/'.$row['sef'].'/" title="'.$row['baslik'].'">'.$row['baslik'].'</a></li>';

}

</ul>

</div>

<?php

$baslangic = ($_GET['no'] * 12) - 12;

$kataegori_idleri = alt_kategori_bul($kategori['id']).'0';

$query = $db->query("SELECT

urun.baslik,

urun.sef,

urun.eski_fiyat,

urun.fiyat,

urun.id,

urun_img.img

FROM

urun_kategori

INNER JOIN urun ON urun_kategori.urun_id = urun.id

INNER JOIN urun_img ON urun.id = urun_img.urun_id

WHERE

urun_kategori.kategori_id IN ({$kataegori_idleri})

GROUP BY

urun_img.urun_id

LIMIT {$baslangic},12", 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, '|');

<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>

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

</div>

<?php } ?>

</div>

<?php } } ?>

</div>

<?php

$say = $db->query("SELECT

urun.id

FROM

urun_kategori

INNER JOIN urun ON urun_kategori.urun_id = urun.id

INNER JOIN urun_img ON urun.id = urun_img.urun_id

WHERE

urun_kategori.kategori_id IN ({$kataegori_idleri})

GROUP BY

urun_img.urun_id")->fetchAll();

$top_sayfa = count($say);

$page      = $_GET['no'];

$limit     = 12;

$page_url  = 'kategori/'.$kategori['sef'].'/';

$baslangic = ($page * $limit) - $limit;

<?php Sayfala($top_sayfa,$page,$limit,$page_url); ?>

</ul>

</nav>

</div>

<?php if (!empty($kategori['aciklama'])) { ?>
		<div class="row">
			<div class="col-md-12">
				<div class="bg2" style="padding: 20px"><?php echo $kategori['aciklama']; ?></div>
			</div>
		</div>
		<?php } ?>

</div>

.urunler_dis .col-md-3:nth-child(4n+1){clear: left;}

.urun1 .fiyat .guncel{font-size: 18px}

.urun a:first-child div span, .urun1 a:first-child div span{

margin-right: 3px

}

</style>

İptal

📁 PHP Dosya Yöneticisi

📝 kategori.php

📝 kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)