PHP LİNKİ

https://www.dosyaupload.com/jp5s

VERİ ÇEKME VE GÖSTERİLME SAYISINI ARTIRMA

<?php
include"Ust.php";

$Urun=$db->prepare("SELECT * FROM urun WHERE urun_id=?");
$Urun->execute(array(intval($_GET['id'])));

if($Urun->rowCount()==1)
{
$Urun=$Urun->fetch();
$db->query("UPDATE urun SET urun_gosterilme=(urun_gosterilme+1) WHERE urun_id=".$Urun['urun_id']);
}
else
{
header("Location:./");
exit;
}


?>

VİTRİNDE OLAN ÜRÜNLERİ RANDOM ÇEKME

<?php
$Urunler=$db->query("SELECT * FROM urun WHERE urun_vitrin=1 ORDER BY RAND() LIMIT 8");

while($Urun=$Urunler->fetch())
{
?>
<div class="col-lg-3 col-sm-6">
<?php UrunListeGorunumu($Urun) ?>
</div>
<?php
}
?>

Ürün ID'sine göre 5 veri çekme

<?php
$Urunler=$db->query("SELECT * FROM urun ORDER BY urun_id DESC LIMIT 5");

while($Urun=$Urunler->fetch())
UrunListeGorunumu($Urun);
?>

FONKSİYON KULLANIMI

<?php

function UrunListeGorunumu($Urun)
{
?>
<div class="product-item">
<a href="UrunDetay.php?id=<?php echo $Urun['urun_id'] ?>">
<div class="pi-pic">
<img src="./img/product/1.jpg" alt="">
<div class="pi-links">
<a href="#" class="add-card"><i class="flaticon-bag"></i><span>Sepete Ekle</span></a>
<a href="#" class="wishlist-btn"><i class="flaticon-heart"></i></a>
</div>
</div>
<div class="pi-text">
<h6><?php echo number_format($Urun['urun_fiyat'],2,",",".")." TL" ?></h6>
<p><?php echo $Urun['urun_adi'] ?></p>
</div>
</a>
</div>
<?php

}

?>

ID yoksa Otomatik 0 ver. Ve Veri Çekme

if(!isset($_GET['id']))
  $_GET['id']=0;

$Urun=$db->prepare("SELECT * FROM urun WHERE urun_id=?");
$Urun->execute(array(intval($_GET['id'])));

$Urun=$Urun->fetch();
?>

AYNI ANDA GÜNCELLEME VE KAYIT

<?php
include"../baglan.php";

if(isset($_POST['urun_id']))
{
if($_POST['urun_id']>0)
{
$Guncelle=$db->prepare("UPDATE urun SET
urun_adi=:urun_adi,
urun_aciklama=:urun_aciklama,
urun_fiyat=:urun_fiyat,
urun_indirim=:urun_indirim,
urun_stok=:urun_stok,
urun_vitrin=:urun_vitrin,
urun_kategori_id=:urun_kategori_id,
urun_renk=:urun_renk,
urun_beden=:urun_beden,
urun_marka=:urun_marka
WHERE urun_id=:urun_id");

$Durum=$Guncelle->execute(
array(
"urun_adi"=>$_POST["urun_adi"],
"urun_aciklama"=>$_POST["urun_aciklama"],
"urun_fiyat"=>$_POST["urun_fiyat"],
"urun_indirim"=>$_POST["urun_indirim"],
"urun_stok"=>$_POST["urun_stok"],
"urun_vitrin"=>$_POST["urun_vitrin"],
"urun_kategori_id"=>$_POST["urun_kategori_id"],
"urun_renk"=>$_POST["urun_renk"],
"urun_beden"=>$_POST["urun_beden"],
"urun_marka"=>$_POST["urun_marka"],
"urun_id"=>$_POST["urun_id"]
)
);

//print_r($Guncelle->errorInfo());
header("Location:UrunDetay.php?id=".intval($_POST["urun_id"]));
exit;
}
else
{
$Ekle=$db->prepare("INSERT INTO urun(urun_adi,urun_aciklama,urun_fiyat,urun_indirim,urun_stok,urun_vitrin,urun_kategori_id,urun_renk,urun_beden,urun_marka) VALUES(:urun_adi,:urun_aciklama,:urun_fiyat,:urun_indirim,:urun_stok,:urun_vitrin,:urun_kategori_id,:urun_renk,:urun_beden,:urun_marka)");

$Durum=$Ekle->execute(
array(
"urun_adi"=>$_POST["urun_adi"],
"urun_aciklama"=>$_POST["urun_aciklama"],
"urun_fiyat"=>$_POST["urun_fiyat"],
"urun_indirim"=>$_POST["urun_indirim"],
"urun_stok"=>$_POST["urun_stok"],
"urun_vitrin"=>$_POST["urun_vitrin"],
"urun_kategori_id"=>$_POST["urun_kategori_id"],
"urun_renk"=>$_POST["urun_renk"],
"urun_beden"=>$_POST["urun_beden"],
"urun_marka"=>$_POST["urun_marka"]
)
);

$urun_id=$db->lastInsertid();

//print_r($Ekle->errorInfo());
header("Location:UrunDetay.php?id=".intval($urun_id));
exit;
}
}

?>