• 20-01-2009, 17:54:42
    #1
    selam arkadaskar benim sorunum etiket olan kelime titlede nasıl gösteririm title hep sabit etiket olan kelimeyi titlede göstermek istiyorum.

    function displaytags() {  
      //rasgele etiket çeker  
    $result = mysql_query("SELECT title, fileid, timesplayed FROM files WHERE status = '1'  ORDER BY rand() DESC LIMIT 0,10");  
     //Son eklenenleri Çeker başında / işareti kaldırınız ve yukarıdakine ilk satıra 2 tane / ekleyiniz.  
     //$result = mysql_query("SELECT title, fileid, timesplayed FROM files WHERE status = '1'  ORDER BY DESC LIMIT 0,10");  
        if (mysql_num_rows($result)) {  
        while($row = mysql_fetch_array($result)) {  
    
    
    $karakter=array ("!","^","'","%","&","[","]","(",")","?","=","*",",",".","~","%","#","@","ç","Ç","ş","Ş","ğ","Ğ","ü","Ü","İ","ı","ö","Ö","ı","Å?","ü","ç","ö","Ä?","ÅŸ","Ç","İ","ÄŸ","Å?","Ö","Ü","ı","Å?","ç","ö","Ä?","ÅŸ","Ç","İ","ÄŸ","Å?","Ö","Ü","ü","ÄŸ","@",";","~","=");  
    $karakter2=array("","","","","","","","","","","","","","","","","","","c","C","s","S","g","G","u","U","i","i","o","O","i","s","u","c","o","g","s","C","i","g","S","O","U","i","s","c","o","g","s","C","i","g","S","o","U","u","g","","","","-");  
    $tagtitle = str_replace($karakter,$karakter2,$row['title']); 
    $keyword ="$tagtitle";  
    $kelimeler = explode(' ', $keyword);  
    foreach ($kelimeler as $anahtar=>$deger)  
    {  
     ?>  
     <a href="<?=$siteurl?>/etiket/<?=$deger?>.html"><?=$deger?></a>  
        <?php  
        }  
        }  
        } else {  
            echo "Dosya Yok";  
        }  
    }

    search dosyasındaki title koduda bu

    $sitename2 = $sitename." - Search";

    etiket sistemi yardımıcı olursanız sevinirim.
  • 20-01-2009, 18:01:32
    #2
    search.php nin içerigini wermen gerekiyor..
  • 20-01-2009, 18:04:11
    #3
    LaCReMeL adlı üyeden alıntı: mesajı görüntüle
    search.php nin içerigini wermen gerekiyor..

    <?php
     
    session_start();
    
    include ("includes/config.php");
    
    $page = $_GET[page];
    if (empty($page) || !is_numeric($page)) {
    	$page = "1";
    }
    $searchTerm = $_GET[t];
    if (empty($searchTerm)) {
      $searchTerm = $_POST[t];
    }
        
    // Display games
    function searchgames($page,$searchTerm) {
    	global $siteurl, $filesperpage, $sefriendly;
    	$result = mysql_query("SELECT * FROM files WHERE title LIKE '%$searchTerm%' && status ='1' || description LIKE '%$searchTerm%' && status ='1'");
    	if (mysql_num_rows($result) == '0') {
    		echo "No games found";
    	} else {
    		
    		// Get number of pages
    		$numrows = mysql_num_rows($result);
    		$offset = ($page - 1) * $filesperpage;
    		$pagescount = ceil($numrows/$filesperpage);
    		
    		for ($pagen = 1; $pagen <= $pagescount; $pagen++) {
    			if ($pagen == $page) {
    				$nav .= " <b>$pagen</b>";
                } else {
                    if ($pagen >= $page - 5 && $pagen <= $page + 5) {
    				    $nav .= " <a href=\"".$siteurl."/search.php?t=".$searchTerm."&page=".$pagen."\">$pagen</a>";
    				}
    	        } 
            }
            if ($page > 1) {
    	        $pagen  = $page - 1;
    	        $prev  = "<a href=\"".$siteurl."/search.php?t=".$searchTerm."&page=1\"><<</a> <a href=\"".$siteurl."/search.php?t=".$searchTerm."&page=".$pagen."\"><</a>";
    	    } else {
    		    $prev  = "";
    		}
    		if ($page < $pagescount) {
    			$pagen = $page + 1;
    			$next = " <a href=\"".$siteurl."/search.php?t=".$searchTerm."&page=".$pagen."\">></a> <a href=\"".$siteurl."/search.php?t=".$searchTerm."&page=".$pagescount."\">>></a>";
    		} else {
    			$next = "";
    		}
        // Display page numbers
        if ($pagescount > '1') {
    	    echo "<tr><td colspan='3' class='pagenumbers'>".$prev.$nav.$next."</td></tr>";
        }
    	
    	$result2 = mysql_query("SELECT fileid, title, description, icon, iconlocation, timesplayed FROM files WHERE title LIKE '%$searchTerm%' && status ='1' || description LIKE '%$searchTerm%' && status ='1' ORDER BY title LIMIT $offset, $filesperpage");
    	
    		$fileinrow="1";
        while($row = mysql_fetch_array($result2)) {
    	    $fileid = $row['fileid'];
            $filetitle = $row['title'];
            $filedescription = $row['description'];
            $fileicon = $row['icon'];
            $iconlocation = $row['iconlocation'];
            $timesplayed = number_format($row['timesplayed']);
            
            if ($iconlocation == '1') {
    	        $imageurl = $siteurl."/files/image/".$fileicon;
            } else {
    	        $imageurl = $fileicon;
            }
            
            if (strlen($filedescription) > '40') {
    	        $filedescription = substr("$filedescription",0,37)."...";
            }
            
            if ($fileinrow == '1') {
    	     echo "<tr>";   
            }
        ?>
        <td width="33%">
          <table class="browsegamesbox">
            <tr>
              <td width="71" valign="top">
              <a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self"><img src="<?php echo $imageurl; ?>" width="70" height="59" title="<?php echo $filetitle; ?>" border="0"></a>
              </td>
              <td valign="top">
              <a href="<?php echo fileurl($fileid,$filetitle); ?>" target="_self" class="gamelink"><?php echo $filetitle; ?></a><br />
              <?php echo $filedescription; ?><br />
              <span class="played">(Oynandi: <?php echo $timesplayed; ?> kere)</span>
              </td>
            </tr>
          </table>
        </td>
        <?php
            if ($fileinrow == '3') {
    	     echo "</tr>";
    	     $fileinrow = "0";
            }
            $fileinrow++;
        }
        if ($fileinrow == '2') {
    	    echo "<td width=\"33%\"></td><td width=\"33%\"></td></tr>";
        } elseif ($fileinrow == '3') {
    	    echo "<td width=\"33%\"></td></tr>";
        }
        // Display page numbers
        if ($pagescount > '1') {
    	    echo "<tr><td colspan='3' class='pagenumbers'>".$prev.$nav.$next."</td></tr>";
        }
        }
    }
    $sitename2 = $sitename." - Search";
    
    // Load template files
    include ("templates/".$template."/header.html");
    include ("templates/".$template."/search.html");
    include ("templates/".$template."/footer.html");
    ?>
    buyur hocam.
  • 20-01-2009, 18:09:01
    #4
    $sitename2 = $searchTerm;
    Başlık arama terimi olur.
    sağına soluna ekleme yapabilirsin
    örnek
    $sitename2 = $searchTerm." oyunları";
    veya
    $sitename2 = $searchTerm." arama sonucları";
    vs..
  • 20-01-2009, 18:17:26
    #5
    tşkler hocam oldu +r
  • 22-01-2009, 00:48:45
    #6
    Misafir
    Gguardian bu etiket sistemini nasil kullanabiliriz? ayrica onarcade surumun kac?