Kolay gelsin,
www.laleli.com sitemde yer alan bir sorunu düzenlemeye çalışıyorum.
https://laleli.com/anakategori.php?c=79 bu linke ait ana kategori yok fakat başka kategoriye konumlanıyor.
https://laleli.com/anakategori.php?c=79 linke tıklanınca bu ana kategori yoksa anasayfaya yönlendirmek istiyorum çözemedim.
<?php
if( ! is_numeric($_REQUEST['c']))
header("Location: index.php");
include("oylamasistemi.php");
?>
<?php /*
foreach ($menuKategoriID as $key => $value) {
echo "Key: $key; Value: $value<br />n";
}*/
//echo $menuKategoriID["$_REQUEST[c]"] ;
?>
<script type="text/javascript">
<!--
d.closeAll();
d.openTo(<?php echo $menuKategoriID["$_REQUEST[c]"];?>, true);
//-->
</script>
<SCRIPT>
function sayimi()
{
var N=event.keyCode;
if ((((N==9) || (N==8)) || ((N==46) || (N==111))) || (((N>95&&N<106) || (N>47&&N<58)) || ((N>95&&N<106) || (N>32&&N<40))))
{
event.returnValue=true;
}
else
event.returnValue=false;
}
</SCRIPT>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?php
$son_kategori_kod=$ac;
$kategori_ara = mysql_query("
SELECT
CATEGORY_KOD,
SHORT_DESC,
PARENT_KOD
FROM
category
WHERE CATEGORY_KOD='$son_kategori_kod'
");
$sorgu_sonuc = mysql_fetch_array($kategori_ara);
$kategori_adi[]=$sorgu_sonuc[SHORT_DESC];
$kategori_kodu[]= $sorgu_sonuc[CATEGORY_KOD];
$son_kategori_kod = $sorgu_sonuc[CATEGORY_KOD];
$kategori_ara = mysql_query("
SELECT
CATEGORY_KOD,
SHORT_DESC,
PARENT_KOD
FROM
category
WHERE PARENT_KOD='$ac'
");
$satir_sayi = mysql_num_rows($kategori_ara);
for ($i=0;$i<$satir_sayi;$i++) {
$satir = mysql_fetch_array($kategori_ara);
$kategori_kodlari[$i] =$satir[CATEGORY_KOD];
}
?>
<tr>
<td width="14"><img src="images/orta/urun/u1.gif" width="14" height="14" /></td>
<td background="images/orta/urun/u2.gif"> </td>
<td width="14"><img src="images/orta/urun/u3.gif" width="14" height="14" /></td>
</tr>
<tr>
<td background="images/orta/urun/s1.gif"> </td>
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" align="center" valign="top"><table width="100%" cellpadding="5">
<tr>
<td height="30" colspan="3" bgcolor="#D9EAC8"><?php
if (is_null($Sort)) $Sort="default";
end($kategori_adi);
while($val = current($kategori_adi)) {
if ($val==$kategori_adi[0]) {
echo "<a href="anakategori.php?c=$c&ac=$ac" class="kategorb">$val</a>"; } else {
echo "$val";
}
// prev($kategori_adi);
if (prev($kategori_adi)) echo "->";
}
?>
<span class="kategorb">, En Çok Satý*** Ürünler:</span> </td>
</tr>
<tr>
<td width="21%" align="left" bgcolor="#E9F2DF"><?php
//$marka_liste = mysql_query("select KOD,PICT_NAME,DESCRP from marka order by DESCRP ASC");
$comma_separated = implode(",", $kategori_kodlari);
$sql_sorgusu = "select KOD,PICT_NAME,DESCRP from marka WHERE AKTIF='1' AND KOD IN (select urun.MARKA_KOD from urun WHERE urun.CATEGORY_KOD IN ($comma_separated) group by urun.MARKA_KOD) order by DESCRP ASC";
$marka_liste = mysql_query($sql_sorgusu);
?>
<select name="select2" id="select" onchange="SetMarkaKat(this.options[this.options.selectedIndex].value);" class="kategor">
<?php
echo "<option value="default"" ;if ($MarkaKat=="default") echo "selected";echo ">Marka sýnýrlamasý</option>";
while($satir = mysql_fetch_array($marka_liste)){
echo "<option value="$satir[KOD]""; if ($MarkaKat==$satir[KOD]) echo "selected";echo ">$satir[DESCRP]</option>";
//echo "<a href="markaurunleri.php?markakod=$isim"> $ISIM </a> ";
}
?>
</select>
</td>
<td width="79%" align="left" bgcolor="#E9F2DF"><select name="select2" id="select2" onchange="SetSort(this.options[this.options.selectedIndex].value);" class="kategor">
<option value="default" <?php if ($Sort=="default") echo "selected";?>>Sýralama kriteri seçiniz</option>
<option value="1" <?php if ($Sort==1) echo "selected";?>>Ucuzdan pahalýya göre</option>
<option value="2" <?php if ($Sort==2) echo "selected";?>>Pahalýdan ucuza göre</option>
<option value="3" <?php if ($Sort==3) echo "selected";?>>Puana göre</option>
<option value="4" <?php if ($Sort==4) echo "selected";?>>Çok satýlana göre</option>
</select>
</td>
<td align="left" bgcolor="#E9F2DF">
<?php
//$marka_liste = mysql_query("select KOD,PICT_NAME,DESCRP from marka order by DESCRP ASC");
$orta_icin_kat_liste = mysql_query("select * from category WHERE PARENT_KOD=$c order by SHORT_DESC ASC");
?>
<select name="KategoriKat" id="kategorikatbox" onChange="window.location.href='kategori.php?c=<?php echo $c;?>&ac='+this.value;" class="kategor">
<?php
echo "<option value="default"" ;if ($MarkaKat=="default") echo "selected";echo ">Kategoriler</option>";
while($satir = mysql_fetch_array($orta_icin_kat_liste)){
echo "<option value="$satir[CATEGORY_KOD]""; if ($ac==$satir[CATEGORY_KOD]) echo "selected";echo ">$satir[SHORT_DESC]</option>";
//echo "<a href="markaurunleri.php?markakod=$isim"> $ISIM </a> ";
}
?>
</select></td>
</tr>
</table> <p> </p></td>
</tr>
<tr>
<td align="center"><table width="140" border="0" align="center" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF">
<?php
$ii=0;
if( isset($_REQUEST["sayfa"]) && $_REQUEST["sayfa"] != "" )
{
$sayfa = $_REQUEST["sayfa"];
}
else
{
$sayfa = 1;
}
$sayfaKayit = 20;
$basla = ($sayfa-1)*$sayfaKayit;
?>
<?php
switch ($Sort) {
case "1":
$siralama_sorgusu ="ORDER BY urun.PRICE ASC";
break;
case "2":
$siralama_sorgusu ="ORDER BY urun.PRICE DESC";
break;
case "3":
$siralama_sorgusu ="ORDER BY urun.PRICE DESC";
break;
case "4":
$siralama_sorgusu ="ORDER BY urun.SATIS_MIKTAR DESC";
break;
default:
//$siralama_sorgusu ="ORDER BY urun.SORT_ORDER ASC";
$siralama_sorgusu ="ORDER BY urun.SATIS_MIKTAR DESC";
}
if ($MarkaKat!= "default") {
$markaSiniri = " AND MARKA_KOD=$MarkaKat";
} else {
unset($markaSiniri);
}
$araman = mysql_query("
SELECT
URUN_KOD,
SHORT_DESC,
SHORT_DESC2,
PICT_NAME,
indirimgrubu,
PRICE,
PRICE_PARA_BRM,
SYMBOL,
KAMPANYALI,
INDIRIMDE,
STOK_YOK,
STOK_MIKTAR,
YENIURUN
FROM
urun
LEFT JOIN para_birim ON (urun.PRICE_PARA_BRM = para_birim.KOD)
WHERE ((urun.CATEGORY_KOD IN ( $comma_separated ))
OR (ek_kategori_1 IN ($comma_separated)) OR (ek_kategori_2 IN ($comma_separated)) OR (ek_kategori_3 IN ($comma_separated))
) AND AKTIF='1' $markaSiniri $siralama_sorgusu LIMIT $basla,$sayfaKayit
");
/*SELECT `CATEGORY_KOD`
FROM `category`
WHERE PARENT_KOD =$c*/
while($sorgun = mysql_fetch_array($araman)){
?>
<?php if (($ii % 4 )== 0) {?>
<tr bgcolor="#FFFFFF">
<?}?>
<td align="center" valign="top">
<?php // form buraya ?>
<script>
function formkontrol(theForm){
if (theForm.adet.value == null || theForm.adet.value == "" ) {
alert("Sipariþ miktarý girmelisiniz");
return false;
}
}
</script>
<form action="sepet.php" method="post" name="sepet<?=$sorgun[URUN_KOD]?>" id="sepet" onsubmit="return formkontrol(this);">
<input type="hidden" name="islem" value="ekle" />
<input type="hidden" name="urunid" value="<?=$sorgun[URUN_KOD]?>" />
<input type="hidden" name="sipid" value="" />
<table style="MARGIN-BOTTOM: 8px" border="0" cellspacing="0" cellpadding="0" width="150" align="center">
<tbody>
<tr>
<td height="6" width="6"><img alt="" src="images/lale_71.gif" width="6" height="6" /></td>
<td background="images/lale_72.gif"></td>
<td width="6"><img alt="" src="images/lale_74.gif" width="6" height="6" /></td>
</tr>
<tr>
<td background="images/lale_76.gif"> </td>
<td><table border="0" cellspacing="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td height="140" valign="center" colspan="2" align="center"><a title="<?php echo "$sorgun[SHORT_DESC]"; ?>" href="urun.php?ID=<?php echo "$sorgun[URUN_KOD]"; ?>" target="_self"> <img src="products_images/thumb/<?php echo "$sorgun[PICT_NAME]"; ?>" border="0" /></a>
<?php echo rating_bar("$sorgun[URUN_KOD]",'5','static'); ?>
</td>
</tr>
<tr>
<td height="45" colspan="2" align="center"><span class="UrunSablonBizdeKelimesi"> <a title="<?php echo "$sorgun[SHORT_DESC]"; ?>" href="urun.php?ID=<?=$sorgun[URUN_KOD];?>" >
<?php
//$tanim = ucwords(strtolower($satir[SHORT_DESC]));
$limit = 32;
$tanim = $sorgun[SHORT_DESC];
if (strlen($tanim) > $limit)
$tanim = substr($tanim, 0, strrpos(substr($tanim, 0, $limit), ' ')) . '...';
echo $tanim;
?>
</a> </span> </td>
</tr>
<tr>
<td width="50%" height="26" align="center"><?php
if ($sorgun[INDIRIMDE] == 1) {
?>
<img src="images/kampanya.gif" alt="Kampanyalý Ürün" width="55" height="14" title="Kampanyalý Ürün" />
<?php
}
?> </td>
<td width="50%" align="center"><?php
if ($sorgun[YENIURUN] == 1) {
?>
<img src="images/yeni.gif" width="30" height="14" title="Yeni Ürün"/>
<?php
}
?> </td>
</tr>
<tr>
<td colspan="2" align="center">
<span style="font-weight:bold;color:#7442b1;">
<?php
$indirimgrubu=$sorgun["indirimgrubu"];
$indirimoranlari = mysql_fetch_array(mysql_query("select havale_indirimi,tekcekim_indirimi from indirimoranlari where id='$indirimgrubu' AND aktif='1'"));
$havale_fiyati=$indirimoranlari["havale_indirimi"];
$tekcekim_fiyati=$indirimoranlari["tekcekim_indirimi"];
$havale_fiyati2= $sorgun[PRICE]*((100-$havale_fiyati)/100);
$tekcekim_fiyati2= $sorgun[PRICE]*((100-$tekcekim_fiyati)/100);
if($sorgun[PRICE_PARA_BRM]==4){
//$havalefiyati=ytl_tl_fiyat_yaz(doviz_cevir($havale_fiyati2,$sorgun[PRICE_PARA_BRM]),"yan");
$havalefiyati=ytl_format($havale_fiyati2);
echo ytl_format($havale_fiyati2);
//ytl_tl_fiyat_yaz($sorgun[PRICE],"alt");
}
else{
//echo "fiyat_formati($sorgun[PRICE])";
echo ytl_format($sorgun[PRICE]);
?>
<?=$sorgun[SYMBOL];}?>
</span><span style="font-weight:normal;color:#7442b1;">(KDV Dahil)</span></div>
</td>
</tr>
</tbody>
</table></td>
<td background="images/lale_78.gif"> </td>
</tr>
<tr>
<td height="6"><img alt="" src="images/lale_89.gif" width="6" height="6" /> </td>
<td background="index1_dosyalar/lale_91.gif"></td>
<td><img alt="" src="images/lale_92.gif" width="6" height="6" /> </td>
</tr>
<tr>
<td background="images/lale_151.gif"> </td>
<td bgcolor="#f5f5f5"><table border="0" cellspacing="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td align="center" valign="bottom">
<?php
if ($sorgun[STOK_MIKTAR]>0 && $sorgun[STOK_YOK]==0) {
//echo "alooo 1";
?>
<span class="Urunfiyati">Adet</span>
<input name="adet" type="text" size="3" maxlength="1" class="InputStyle1orta" value="1" onkeydown="sayimi();"/>
<input name="image" type="image" src="images/sepete.gif" width="28" height="28" border="0" title="Ürünü Sepete At" />
<?php
} else {
//echo "alooo 2";
?>
<span>
<img name="image2" src="images/stokta_yok_urun.gif" border="0" title="Ürün çok yakýnda stoða girecektir..." />
</span>
<?php
}
?>
</td> </tr>
</tbody>
</table></td>
<td background="images/lale_150.gif"> </td>
</tr>
<tr>
<td height="8" width="6"><img alt="" src="images/lale_106.gif" width="6" height="8" /></td>
<td background="images/lale_107.gif"></td>
<td height="8" width="6"><img alt="" src="images/lale_109.gif" width="6" height="8" /></td>
</tr>
</tbody>
</table>
</form>
<?php $ii++; ?>
<?php if (($ii % 4)<>0 && $ii < $sayfaKayit) { echo "</td><td> </td>";} ?>
<?php if (($ii % 4)==0) {?></td>
</tr>
<?php } ?>
<?}
$arama_sonucToplam = mysql_query("
SELECT
COUNT(*)
FROM
urun
LEFT JOIN para_birim ON (urun.PRICE_PARA_BRM = para_birim.KOD)
WHERE (
(urun.CATEGORY_KOD IN ( $comma_separated ))
OR (ek_kategori_1 IN ($comma_separated)) OR (ek_kategori_2 IN ($comma_separated)) OR (ek_kategori_3 IN ($comma_separated))
) AND AKTIF='1' $markaSiniri $siralama_sorgusu
");
list($toplam) = @mysql_fetch_array($arama_sonucToplam);
$pagingHtml = paging($toplam,$sayfa,"anakategori.php?c=$c&ac=$ac&MarkaKat=$MarkaKat&Sort=$Sort",$sayfaKayit);
echo '<div align="center">'.$pagingHtml.'</div>';
?>
<tr>
<td colspan="7" align="center" bgcolor="#FFFFFF"><?php echo $pagingHtml; ?> </td>
</tr>
</table></td>
</tr>
</table></td>
<td background="images/orta/urun/s2.gif"> </td>
</tr>
<tr>
<td><img src="images/orta/urun/a1.gif" width="14" height="14" /></td>
<td background="images/orta/urun/a2.gif"></td>
<td><img src="images/orta/urun/a3.gif" width="14" height="14" /></td>
</tr>
</table></td>
</tr>
</table>