Haftanın Ürünleri
query("
SELECT
haftanin_urunleri.urun_id,
urun.id,
urun.baslik,
urun.sef,
urun.eski_fiyat,
urun.fiyat,
urun_img.img
FROM
haftanin_urunleri
INNER JOIN urun ON haftanin_urunleri.urun_id = urun.id
INNER JOIN urun_img ON urun.id = urun_img.urun_id
GROUP BY urun_img.urun_id
ORDER BY haftanin_urunleri.sira ASC
", PDO::FETCH_ASSOC);
if($query->rowCount()){
foreach($query as $row){
?>
query("SELECT * FROM kampanya ORDER BY sira ASC LIMIT 3", PDO::FETCH_ASSOC);
if($query->rowCount()){
$i = 0;
foreach($query as $row){
$i++;
?>
);">
);">
" class="full-link">
);">
" class="full-link">
Kredi kartına 12 taksit imkanı
1-4 İş günü içerisinde güvenli teslimat
14 Gün içerisinde iade/değişim imkanı
query("SELECT
urun.id,
urun.baslik,
urun.sef,
urun.eski_fiyat,
urun.fiyat,
urun_img.img
FROM
vitrin_urun
INNER JOIN urun ON vitrin_urun.urun_id = urun.id
INNER JOIN urun_img ON urun.id = urun_img.urun_id
WHERE
vitrin_urun.vitrin_id = '{$row1['id']}'
GROUP BY
urun_img.urun_id
ORDER BY
vitrin_urun.sira ASC
", PDO::FETCH_ASSOC);
if($query->rowCount()){
foreach($query as $row){
?>
🎁
query("SELECT
urun.id,
urun.baslik,
urun.sef,
urun.eski_fiyat,
urun.fiyat,
urun_img.img
FROM
vitrin_urun
INNER JOIN urun ON vitrin_urun.urun_id = urun.id
INNER JOIN urun_img ON urun.id = urun_img.urun_id
WHERE
vitrin_urun.vitrin_id = '{$row1['id']}'
GROUP BY
urun_img.urun_id
ORDER BY
vitrin_urun.sira ASC
", PDO::FETCH_ASSOC);
if($query->rowCount()){
foreach($query as $row){
?>