<?
// Sayfa Ayarları Yapılıyor...
$sayfa='ara.php';
include 'ayar.php';
$k=$q;
$kk=''.$site_isim;
?>
<?php
//Arama Kayıt
if($q != ''){
$kelime = strip_tags(mysql_real_escape_string($_REQUEST['q']));
$sonuc = mysql_query("Select Count(kelime) From arananlar where kelime='$kelime'");
$sayi = mysql_result($sonuc,0);
if($sayi ==0){
if($_COOKIE['aradim'] != $_SERVER['REMOTE_ADDR']){
setcookie('aradim', $_SERVER['REMOTE_ADDR'], time()+360);
mysql_query("Insert Into arananlar (zaman, kelime) Values ('".time()."', '$kelime')");
}
}
//Arama Kayıt
}
?>
<html>
<head>
</head>
<body topmargin="3">
<a href="sitemap.php" title="Site Haritası"><font style="font-size:1px" color="FFFFFF"><?=$kk?></font></a>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><? include 'banner.php'; ?></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" valign="top"><? include 'sol.php'; ?></td>
<td width="80%" height="400" valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td width="80%" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" background="img/bg_ic.gif" class="bolum" style="background-repeat:repeat-x;"><a href="index.php"><b>Anasayfa'ya Git</b></a> > "<?=$q?>" Araması Sonuçları Aşağıda Listelenmiştir.</td>
</tr>
</table>
<tr>
<?
if (!$k1) { $k1=0; }
$k2=20;
$k3=$k1-$k2;
$k4=$k1+$k2;
if ($lisans=="") { $a1="id like '%'";} else { $a1="lisans='$lisans'"; }
if ($ad=="") { $a2="id like '%'";} else { $a2="ad like '$ad%'"; }
if ($q=="") { $a0="id like '%'";} else { $a0="ad like '%$q%'"; }
if ($mesaj=="") { $a2="id like '%'";} else { $a2="mesaj like '$mesaj%'"; }
if ($q=="") { $a0="id like '%'";} else { $a0="mesaj like '%$q%'"; }
$toplam1=mysql_query("select * from z_inndir WHERE (durum='a') and ($a0) and ($a1) and ($a2) ");
$toplamsayi1=mysql_num_rows($toplam1);
$sorgu1=mysql_query("select * from z_inndir WHERE (durum='a') and ($a0) and ($a1) and ($a2) order by hit desc limit $k1, $k2 ");
while ($satir = mysql_fetch_array($sorgu1)):
?>
<tr>
<td valign="top" bgcolor="ffffff" style="padding:4px;"><b>
<a href="<?=dosya($satir[ad]).'-'.$satir[id].'.htm'?>"><?=$satir[ad]?></a></b><br><?=substr(trim(strip_tags($satir[mesaj])),9,70)?>...</td>
</tr>
<tr>
<td colspan="4" height="8"></td>
</tr>
<? endwhile; ?>
<?php
if($toplamsayi1 ==0){
?><tr><td>
Uygun sonuç bulunamadı.<br>
İsterseniz <a href="search.php?q=<?php echo $q; ?>"><b>buraya</b></a> tıklayarak genel sonuçları listeleyebilirsiniz.
</td>
</tr>
<?php
}
?>
</table>
<? if ($toplamsayi1 > $k2) { ?>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="4">
<tr>
<td width="5%" nowrap="nowrap" bgcolor="#E3FFFF" style="border:1px solid #8CCDFF"><?
if ($k3<0) { echo '« Önceki Sayfa'; } else {
echo '<a href="'.$sayfa.'?k1='.$k3.'&q='.$q.'#orta">« Önceki Sayfa</a>';
}
?>
</td>
<td width="90%" align="center" bgcolor="#E3FFFF" style="border:1px solid #8CCDFF"><?
$kat1=$k2*8;
$kat2=$k2*9;
if ($k1>$kat1) {
$a1=$k1-$kat1; $a2=$k1+$kat1;
} else {
$a1=0; $a2=$kat2; }
if ($a2>$toplamsayi1) { $a2=$toplamsayi1; }
for ($a=$a1;$a<=$a2;$a=$a+$k2) {
$link1=@($a/$k2)+1;
$cik=($k1/$k2)+1;
if ($cik==$link1) {
echo ' <b>['.$link1.']</b> ';
} else {
echo ' [<a href="'.$sayfa.'?k1='.$a.'&q='.$q.'#orta">'.$link1.'</a>] '; }
} ?>
</td>
<td width="5%" nowrap="nowrap" bgcolor="#E3FFFF" style="border:1px solid #8CCDFF"><?
if ($k4>$toplamsayi1) {
echo 'Sonraki Sayfa »';
} else {
echo '<a href="'.$sayfa.'?k1='.$k4.'&q='.$q.'#orta">Sonraki Sayfa »</a>';
}
?>
</td>
</tr>
<tr>
<td colspan="3" align="center" nowrap="nowrap" bgcolor="#F4F998" style="border:1px solid #8CCDFF">Bu Bölümde Toplam <b>
<?=$toplamsayi1?>
</b> Program Bulunuyor. </td>
</tr>
</table>
<? } ?></td>
<td width="20%" valign="top">
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<? include 'alt.php'; ?></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<? mysql_close($yol)?>ara.php tam olarak bu. Bu sorunu nasıl çözebilirim?