Merhaba,
Onarcade'de kelimeleri kaydetmek var olmayan bir kelime arandığında da rastgele birkaç video gostermek istiyorum.Yaptığım işlemler şunlar;
search.php - Videolar nedense gorunmuyor.
<table width="100%" height="467" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<!--DWLayoutTable-->
<tr>
<td height="26"></td>
<td colspan="2" valign="top" height="26"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFCC00" style="border-collapse: collapse" bordercolor="#111111">
<!--DWLayoutTable-->
<tr>
<td width="9" height="26"> </td>
<td width="535" valign="middle"><span class="ustyazi">Rasgele Filmler </span></td>
<td width="38" align="center" valign="middle"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="7"></td>
<td colspan="2" valign="top" height="7"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="582" height="7"></td>
</tr>
</table></td>
</tr>
<?php
session_start();
include ("includes/config.php");
$result = mysql_query("SELECT fileid, title, description, icon, iconlocation, timesplayed FROM files WHERE category = '$filecategory' && status ='1' && fileid != '$fileId' ORDER BY RAND() LIMIT 8");
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<tr>
<td height="287"></td>
<td colspan="2" valign="top" height="287"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="139" height="139" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
<td width="9"> </td>
<td width="139" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><?php
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
<td width="9"> </td>
<td width="139" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><?php
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
<td width="8"> </td>
<td width="139" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><?php
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="9" colspan="7" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="582" height="9"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="139" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><a href="xxxxxxxxxxx">
<?php
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
<td></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><a href="xxxxxxxxxxx">
<?php
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
<td></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><a href="xxxxxxxxxxx">
<?php
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
<td></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="kutu2">
<!--DWLayoutTable-->
<tr>
<td width="137" height="96" align="center" valign="bottom"><?php
$row = mysql_fetch_array($result);
$rfileId = $row['fileid'];
$rfileTitle = $row['title'];
$rfileDescription = $row['description'];
$ricon = $row['icon'];
$riconLocation = $row['iconlocation'];
$rtimesPlayed = number_format($row['timesplayed']);
?>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" title="<?php echo $rfileTitle; ?>"><img src="<?php echo $ricon; ?>" width="120" height="90" border="0"></a></td>
</tr>
<tr>
<td height="41" align="center" valign="middle"><a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo substr("$rfileTitle",0,19)."..."; ?></a><br>
<a href="<?php echo fileurl($rfileId,$rfileTitle); ?>" class="yazi1" title="<?php echo $rfileTitle; ?>"><?php echo $rtimesPlayed; ?> kez izlendi </a> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<?php
if($_POST){
$kelime = mysql_real_escape_string($_REQUEST['kelime']);
$sonuc = mysql_query("Select Count(kelime) From arananlar where kelime='$kelime'");
$sayi = mysql_result($sonuc,0);
if($sayi ==0){
mysql_query("Insert Into arananlar (zaman, kelime) Values ('".time()."', '$kelime')");
$zamanasimi = time()-24*60*60;
mysql_query("Delete From arananlar where zaman < ".$zamanasimi);
}
}
?>Menu.html burada kelimeler orneğin kucuk bir fontla "kelime kelime1" şeklinde yanyana yazdırılmasını istiyorum.
<?php
$sonuc = mysql_query("Select kelime From arananlar order by zaman DESC limit 100");
$a=1;
while($satir = mysql_fetch_array($sonuc)){
$kelime = $satir['kelime'];
echo $a."- <a title=\"".$kelime."\" href=\"search.php?kelime=".$kelime."\">".$kelime."</a><br>";
$a++;
}
?>