2 Konuda yardımınıza ihtiyacım var

Forumum · #1 (**permalink**) 07-08-2007, 15:07:01

Merhaba linklist tarzında bir sitem var linkler önce siteismi.com/siteeklerkenyazılanbaşlık-sitenosu.html şeklinde bir url ye yönleniyor.
Örnek resim

Kelimleri nasıl siteismi.com/yeni-video-klipler-2813.html veya siteismi.com/yeni.video.klipler-2813.html şeklinde yapabilirim.

Birde türkçe karakter sorununu nasıl düzeltebilirim sitede bazı konuları okuyup confing.php ye ekledim fakat düzeltemedim.

volkanbagcali · #2 (**permalink**) 11-08-2007, 00:32:52

htaccess ve url kod kısımlarını yazarsan yardımcı olayım

~~Lisans~~ · #3 (**permalink**) 11-08-2007, 15:05:50

PHP Kodu:

  function Cevir($url){
$Tr = array("Ğ","Ü","Ş","İ","Ö","Ç","ğ","ü","ş","ı","ç"," ","+",".");
$En = array("G","U","S","I","O","C","g","u","s","i","c",".","","");
$url =  @str_replace($Tr,$En,$url);
return $url;
}
# Kullanımı
echo "<a href=\"Cevir('deneme link+türkçe-karakter-çıkmaz.-3222')\">Test</a>";

htaccess olarak'ta

Code:

RewriteEngine On
RewriteRule ^(.*)-(.*).html$ /sayfan.php?id=$2[L]

Forumum · #4 (**permalink**) 11-08-2007, 20:19:14

Lisans kodları yazmışsın fakat bir türlü yapamadım

.htaccess

PHP Kodu:

  Options +FollowSymLinks

RewriteEngine on

RewriteRule index.html$ index.php

RewriteRule alis_.html$ alis_.php

RewriteRule arama_.html$ arama_.php

RewriteRule ask_.html$ ask_.php

RewriteRule astroloji_.html$ astroloji_.php

RewriteRule bankalar_.html$ bankalar_.php

RewriteRule bilgisayar_.html$ bilgisayar_.php

RewriteRule bilim_.html$ bilim_.php

RewriteRule arama_.html$ arama_.php

RewriteRule blog_.html$ blog_.php

RewriteRule chat_.html$ chat_.php

RewriteRule dergiler_.html$ dergiler_.php

RewriteRule din_.html$ din_.php

RewriteRule edebiyat_.html$ edebiyat_.php

RewriteRule egitim_.html$ egitim_.php

RewriteRule eglence_.html$ eglence_.php

RewriteRule ekart_.html$ ekart_.php

RewriteRule ekonomi_.html$ ekonomi_.php

RewriteRule forum_.html$ forum_.php

RewriteRule futbol_.html$ futbol_.php

RewriteRule gazeteler_.html$ gazeteler_.php

RewriteRule genel_.html$ genel_.php

RewriteRule gerekli_.html$ gerekli_.php

RewriteRule gsm_.html$ gsm_.php

RewriteRule haber_.html$ haber_.php

RewriteRule hosting_.html$ hosting_.php

RewriteRule hukuk_.html$ hukuk_.php

RewriteRule kariyer_.html$ kariyer_.php

RewriteRule kisisel_.html$ kisisel_.php

RewriteRule kultur_.html$ kultur_.php

RewriteRule mp3_.html$ mp3_.php

RewriteRule muzik_.html$ muzik_.php

RewriteRule oto_.html$ oto_.php

RewriteRule otomobil_.html$ otomobil_.php

RewriteRule oyun_.html$ oyun_.php

RewriteRule programlar_.html$ programlar_.php

RewriteRule reklam_.html$ reklam_.php

RewriteRule saglik_.html$ saglik_.php

RewriteRule sinema_.html$ sinema_.php

RewriteRule arama_.html$ arama_.php

RewriteRule siyasi_.html$ siyasi_.php

RewriteRule spor_.html$ spor_.php

RewriteRule toplist_.html$ toplist_.php

RewriteRule tur_.html$ tur_.php

RewriteRule turizm_.html$ turizm_.php

RewriteRule tv_.html$ tv_.php

RewriteRule uni_.html$ uni_.php

RewriteRule uydu_.html$ uydu_.php

RewriteRule webmaster_.html$ webmaster_.php

RewriteRule yemek_.html$ yemek_.php

RewriteRule ^(.*)-(.*).html$ i.php?id=$2[L]

Linklerin yönlendiği sayfa

PHP Kodu:

 
<include ("config.php");?>

<?php

include("config.php");

$id = htmlspecialchars(intval(strip_tags($_GET['id'])));

$sonuc = mysql_query("Select ad,url,kategori,aciklama,kelimeler,bgelen,bgiden From siteler where sno=$id");

$satir = mysql_fetch_array($sonuc);

$ad = $satir['ad'];

$url = $satir['url'];

$kat = $satir['kategori'];

$ac = substr($satir['aciklama'],0,200);

$kelimeler = substr($satir['kelimeler'],0,200);

$imgurl = "http://msnsearch.srv.girafa.com/srv/i?s=MSNSEARCH&r=".$satir['url'];

$gelen = $satir['bgelen'];

$giden = $satir['bgiden'];

?>

<title><? echo "$kelimeler"; ?>  </title>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">

<STYLE type=text/css>A:link {

COLOR: #0000FF

}

A:visited {

COLOR: ##0000FF

}

A:hover {

COLOR: #ff9933

}

A {

TEXT-DECORATION: none

}

<!--

.form        { font-family: Verdana; font-size: 10px; color: #207D20;

border: 1px dashed #207D20;  }

body         { font-family: Verdana; font-size: 11px }

td           { font-family: Verdana; font-size: 11px }

-->

</style>

</head>

<body topmargin="0" leftmargin="0">

<div align="center">

<table width="764" border="0" cellspacing="1" cellpadding="1" height="36">

<tr>

<td height="33" width="760">

<table id="Table_01" width="707" height="90" border="0" cellpadding="0" cellspacing="0">

    <tr>

        <td colspan="6">

            <img src="images/Untitled-1_01.jpg" width="760" height="57" alt=""></td>

    </tr>

    <tr>

        <td>

            <img src="images/Untitled-1_02.jpg" width="286" height="33" alt=""></td>

        <td>

            <a href="index.php"

                onmouseover="window.status='Anasayfa';  return true;"

                onmouseout="window.status='';  return true;">

                <img src="images/anasayfa.jpg" width="104" height="33" border="0" alt=""></a></td>

        <td>

            <a href="site_ekle.php"

                onmouseover="window.status='Site Ekle';  return true;"

                onmouseout="window.status='';  return true;">

                <img src="images/siteekle.jpg" width="92" height="33" border="0" alt=""></a></td>

        <td>

            <a href="html.php"

                onmouseover="window.status='Html Kodu Al';  return true;"

                onmouseout="window.status='';  return true;">

                <img src="images/html.jpg" width="116" height="33" border="0" alt=""></a></td>

        <td>

            <a href="reklam.php"

                onmouseover="window.status='Reklam';  return true;"

                onmouseout="window.status='';  return true;">

                <img src="images/reklam.jpg" width="84" height="33" border="0" alt=""></a></td>

        <td>

            <a href="iletisim.php"

                onmouseover="window.status='İletişim';  return true;"

                onmouseout="window.status='';  return true;">

                <img src="images/iletisim.jpg" width="78" height="33" border="0" alt=""></a></td>

    </tr>

</table>

<TABLE borderColor=#ffffff cellPadding=4 width=759 border=1 height="1">

<TBODY>

<TR>

<TD borderColor=#FFFFFF bgColor=#FF0000 height="16" width="743">

<p align="center"><FONT

color=#FFFFFF><b>&nbsp;<font face="Verdana, Arial, Helvetica, sans-serif" size="2"> </ </font></b></FONT></TD>

</TR>

<TR>

<TD height="1" borderColor=#FF0000 bgColor=#f5f5f5 width="743">

<TABLE width=100% border=0>

<TBODY>

<TD borderColor=#FFFFFF bgColor=#FF0000 height="16" width="743">

<p align="center"><FONT

color=#FFFFFF><b>&nbsp;<font face="Verdana, Arial, Helvetica, sans-serif" size="2"></font></b></FONT></TD>

</TR>

<TR>

<TD height="1" borderColor=#FF0000 bgColor=#f5f5f5 width="743">

<TABLE width=100% border=0>

<TBODY>

    <center>

    <p>&nbsp;</p>

    </center>

    </script>

<tr>

<td style="font-size: 9pt;" align="center">&nbsp;</td>

</tr>

<tr>

<td>

<!-- İçerik Başla -->

<table id="icerik" style="border: 1px solid rgb(255, 255, 204);" bgcolor="#F5F5F5" border="0" cellpadding="1" cellspacing="5" width="100%">

<tbody><tr>

  <td style="border: 1px solid rgb(204, 204, 204); background-color: rgb(245, 245, 245);"><table border="0" cellpadding="0" cellspacing="0" width="100%">

    <tbody><tr>

      <td valign="top" width="336">

      </td>

      <td width="8">&nbsp;</td>

      <td><table border="0" cellpadding="0" cellspacing="0" width="100%">

        <tbody>

        <tr>

          <td colspan="3"><a target="_blank" title="<? echo "$ad" ?>" href="<? echo "$url" ?>"><span class="i_baslik"><? echo "$ad" ?></span></a></td>

          <td rowspan="11" align="center" width="36%"><div class="i_screenshot"><img src="http://msnsearch.srv.girafa.com/srv/i?s=MSNSEARCH&amp;r=<? echo "$url" ?>" alt="<? echo "$url" ?>" height="97" width="130"></div></td>

        </tr>

        <tr>

          <td colspan="3" height="8"></td>

        </tr>

        <tr>

          <td colspan="3"><span class="i_www"><? echo "$url" ?></span></td>

        </tr>

        <tr>

          <td height="8"></td>

          <td height="8"></td>

          <td height="8"></td>

        </tr>

        <tr>

          <td width="25%">Giden Ziyaretçi </td>

          <td width="3%">:</td>

          <td width="36%"><strong><? echo "$giden";?></strong></td>

        </tr>

        <tr>

          <td height="8"></td>

          <td height="8"></td>

          <td height="8"></td>

        </tr>

        <tr>

          <td>Gelen Ziyaretçi </td>

          <td>:</td>

          <td><strong><? echo "$gelen";?></strong></td>

        </tr>

        <tr>

          <td height="8"></td>

          <td height="8"></td>

          <td height="8"></td>

        </tr>

        <tr>

          <td>Kategori</td>

          <td>:</td>

          <td><? echo "$kat";?></td>

        </tr>

        <tr>

          <td height="8"></td>

          <td height="8"></td>

          <td height="8"></td>

        </tr>

        <tr>

          <td height="8"></td>

          <td height="8"></td>

          <td height="8"></td>

          <td height="8"></td>

        </tr>

        <tr>

          <td>&nbsp;</td>

          <td>&nbsp;</td>

          <td colspan="2">&nbsp;</td>

        </tr>

        <tr>

          <td colspan="4"><table id="reklam" align="center" border="0" cellpadding="0" cellspacing="0" width="100%">

              <tbody><tr>

                <td><hr color="#006699" size="1">

                <? echo "$ac";?>

                </td>

              </tr>

              <tr>

              Açıklama

              </tr>

          </tbody></table></td>

        </tr>

        <tr>

          <td>&nbsp;</td>

          <td>&nbsp;</td>

          <td colspan="2">&nbsp;</td>

        </tr>

      </tbody></table></td>

<table bgcolor="#F5F5F5" border="0" cellpadding="0" cellspacing="0" height="25" width="100%">      

                    <tbody><tr>

                <td><hr color="#006699" size="1">

                <? echo "$kelimeler";?>

                </td>

              </tr>

              <tr>

              Anahtar Kelimeler

              </tr>

          </tbody></table></td>

        </tr>

        <tr>

          <td>&nbsp;</td>

          <td>&nbsp;</td>

          <td colspan="2">&nbsp;</td>

        </tr>

      </tbody></table></td>

    </tr>

  </tbody></table>

    <table bgcolor="#F5F5F5" border="0" cellpadding="0" cellspacing="0" height="25" width="100%">

    <tbody><tr>

      <td align="center"></td>

    </tr>

</html>

ad kısımı url olarak yönleniyor.

~~Lisans~~ · #5 (**permalink**) 11-08-2007, 20:52:51

PHP Kodu:

  function Cevir($url){
$Tr = array("Ğ","Ü","Ş","İ","Ö","Ç","ğ","ü","ş","ı","ç"," ","+");
$En = array("G","U","S","I","O","C","g","u","s","i","c",".","");
$url =  @str_replace($Tr,$En,$url);
return $url;
}
$url = Cevir($satir['url']);

$satir['url'] kısmı şöyle olmalı,
örnek: _http://www.siteismi.com/Lisans.R10.Net-1000.html

~~Lisans~~ · #6 (**permalink**) 12-08-2007, 18:25:26

PHP Kodu:

 
 <include ("config.php");?> 
<?php 
include("config.php"); 
$id = htmlspecialchars(intval(strip_tags($_GET['id']))); 
$sonuc = mysql_query("Select ad,url,kategori,aciklama,kelimeler,bgelen,bgiden From siteler where sno=$id"); 
$satir = mysql_fetch_array($sonuc); 
$ad = $satir['ad']; 
function Cevir($url){
$Tr = array("Ğ","Ü","Ş","İ","Ö","Ç","ğ","ü","ş","ı","ç"," ","+");
$En = array("G","U","S","I","O","C","g","u","s","i","c",".","");
$url =  @str_replace($Tr,$En,$url);
return $url;
}
$url = Cevir($satir['url']); 
$kat = $satir['kategori']; 
$ac = substr($satir['aciklama'],0,200); 
$kelimeler = substr($satir['kelimeler'],0,200); 
$imgurl = "http://msnsearch.srv.girafa.com/srv/i?s=MSNSEARCH&r=".$satir['url']; 
$gelen = $satir['bgelen']; 
$giden = $satir['bgiden']; 
?> 
<title><? echo "$kelimeler"; ?>  </title> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254"> 
<STYLE type=text/css>A:link { 
COLOR: #0000FF 
} 
A:visited { 
COLOR: ##0000FF 
} 
A:hover { 
COLOR: #ff9933 
} 
A { 
TEXT-DECORATION: none 
} 
<!-- 
.form        { font-family: Verdana; font-size: 10px; color: #207D20; 
border: 1px dashed #207D20;  } 
body         { font-family: Verdana; font-size: 11px } 
td           { font-family: Verdana; font-size: 11px } 
--> 
</style> 
</head> 
<body topmargin="0" leftmargin="0"> 
<div align="center"> 
<table width="764" border="0" cellspacing="1" cellpadding="1" height="36"> 
<tr> 
<td height="33" width="760"> 
<table id="Table_01" width="707" height="90" border="0" cellpadding="0" cellspacing="0"> 
    <tr> 
        <td colspan="6"> 
            <img src="images/Untitled-1_01.jpg" width="760" height="57" alt=""></td> 
    </tr> 
    <tr> 
        <td> 
            <img src="images/Untitled-1_02.jpg" width="286" height="33" alt=""></td> 
        <td> 
            <a href="index.php" 
                onmouseover="window.status='Anasayfa';  return true;" 
                onmouseout="window.status='';  return true;"> 
                <img src="images/anasayfa.jpg" width="104" height="33" border="0" alt=""></a></td> 
        <td> 
            <a href="site_ekle.php" 
                onmouseover="window.status='Site Ekle';  return true;" 
                onmouseout="window.status='';  return true;"> 
                <img src="images/siteekle.jpg" width="92" height="33" border="0" alt=""></a></td> 
        <td> 
            <a href="html.php" 
                onmouseover="window.status='Html Kodu Al';  return true;" 
                onmouseout="window.status='';  return true;"> 
                <img src="images/html.jpg" width="116" height="33" border="0" alt=""></a></td> 
        <td> 
            <a href="reklam.php" 
                onmouseover="window.status='Reklam';  return true;" 
                onmouseout="window.status='';  return true;"> 
                <img src="images/reklam.jpg" width="84" height="33" border="0" alt=""></a></td> 
        <td> 
            <a href="iletisim.php" 
                onmouseover="window.status='İletişim';  return true;" 
                onmouseout="window.status='';  return true;"> 
                <img src="images/iletisim.jpg" width="78" height="33" border="0" alt=""></a></td> 
    </tr> 
</table> 
<TABLE borderColor=#ffffff cellPadding=4 width=759 border=1 height="1"> 
<TBODY> 
<TR> 
<TD borderColor=#FFFFFF bgColor=#FF0000 height="16" width="743"> 
<p align="center"><FONT 
color=#FFFFFF><b>&nbsp;<font face="Verdana, Arial, Helvetica, sans-serif" size="2"> </ </font></b></FONT></TD> 
</TR> 
<TR> 
<TD height="1" borderColor=#FF0000 bgColor=#f5f5f5 width="743"> 
<TABLE width=100% border=0> 
<TBODY> 
<TD borderColor=#FFFFFF bgColor=#FF0000 height="16" width="743"> 
<p align="center"><FONT 
color=#FFFFFF><b>&nbsp;<font face="Verdana, Arial, Helvetica, sans-serif" size="2"></font></b></FONT></TD> 
</TR> 
<TR> 
<TD height="1" borderColor=#FF0000 bgColor=#f5f5f5 width="743"> 
<TABLE width=100% border=0> 
<TBODY> 
    <center> 
    <p>&nbsp;</p> 
    </center> 
    </script> 
<tr> 
<td style="font-size: 9pt;" align="center">&nbsp;</td> 
</tr> 
<tr> 
<td> 
<!-- İçerik Başla --> 
<table id="icerik" style="border: 1px solid rgb(255, 255, 204);" bgcolor="#F5F5F5" border="0" cellpadding="1" cellspacing="5" width="100%"> 
<tbody><tr> 
  <td style="border: 1px solid rgb(204, 204, 204); background-color: rgb(245, 245, 245);"><table border="0" cellpadding="0" cellspacing="0" width="100%"> 
    <tbody><tr> 
      <td valign="top" width="336"> 
      </td> 
      <td width="8">&nbsp;</td> 
      <td><table border="0" cellpadding="0" cellspacing="0" width="100%"> 
        <tbody> 
        <tr> 
          <td colspan="3"><a target="_blank" title="<? echo "$ad" ?>" href="<? echo "$url" ?>"><span class="i_baslik"><? echo "$ad" ?></span></a></td> 
          <td rowspan="11" align="center" width="36%"><div class="i_screenshot"><img src="http://msnsearch.srv.girafa.com/srv/i?s=MSNSEARCH&amp;r=<? echo "$url" ?>" alt="<? echo "$url" ?>" height="97" width="130"></div></td> 
        </tr> 
        <tr> 
          <td colspan="3" height="8"></td> 
        </tr> 
        <tr> 
          <td colspan="3"><span class="i_www"><? echo "$url" ?></span></td> 
        </tr> 
        <tr> 
          <td height="8"></td> 
          <td height="8"></td> 
          <td height="8"></td> 
        </tr> 
        <tr> 
          <td width="25%">Giden Ziyaretçi </td> 
          <td width="3%">:</td> 
          <td width="36%"><strong><? echo "$giden";?></strong></td> 
        </tr> 
        <tr> 
          <td height="8"></td> 
          <td height="8"></td> 
          <td height="8"></td> 
        </tr> 
        <tr> 
          <td>Gelen Ziyaretçi </td> 
          <td>:</td> 
          <td><strong><? echo "$gelen";?></strong></td> 
        </tr> 
        <tr> 
          <td height="8"></td> 
          <td height="8"></td> 
          <td height="8"></td> 
        </tr> 
        <tr> 
          <td>Kategori</td> 
          <td>:</td> 
          <td><? echo "$kat";?></td> 
        </tr> 
        <tr> 
          <td height="8"></td> 
          <td height="8"></td> 
          <td height="8"></td> 
        </tr> 
        <tr> 
          <td height="8"></td> 
          <td height="8"></td> 
          <td height="8"></td> 
          <td height="8"></td> 
        </tr> 
        <tr> 
          <td>&nbsp;</td> 
          <td>&nbsp;</td> 
          <td colspan="2">&nbsp;</td> 
        </tr> 
        <tr> 
          <td colspan="4"><table id="reklam" align="center" border="0" cellpadding="0" cellspacing="0" width="100%"> 
              <tbody><tr> 
                <td><hr color="#006699" size="1"> 
                <? echo "$ac";?> 
                </td> 
              </tr> 
              <tr> 
              Açıklama 
              </tr> 
          </tbody></table></td> 
        </tr> 
        <tr> 
          <td>&nbsp;</td> 
          <td>&nbsp;</td> 
          <td colspan="2">&nbsp;</td> 
        </tr> 
      </tbody></table></td> 
<table bgcolor="#F5F5F5" border="0" cellpadding="0" cellspacing="0" height="25" width="100%">       
                    <tbody><tr> 
                <td><hr color="#006699" size="1"> 
                <? echo "$kelimeler";?> 
                </td> 
              </tr> 
              <tr> 
              Anahtar Kelimeler 
              </tr> 
          </tbody></table></td> 
        </tr> 
        <tr> 
          <td>&nbsp;</td> 
          <td>&nbsp;</td> 
          <td colspan="2">&nbsp;</td> 
        </tr> 
      </tbody></table></td> 
    </tr> 
  </tbody></table> 
    <table bgcolor="#F5F5F5" border="0" cellpadding="0" cellspacing="0" height="25" width="100%"> 
    <tbody><tr> 
      <td align="center"></td> 
    </tr> 
</html>

Forumum · #7 (**permalink**) 12-08-2007, 18:42:09

Lisans sonsuz teşekkürler. Söylediklerini aynen yaptım fakat bir türlü olmuyor.

~~Lisans~~ · #8 (**permalink**) 13-08-2007, 03:54:03

Senin ana sayfandaki linkler nerden geliyor yada index.php kodlarını iliştirirsen ayarlarız birşeyler

Forumum · #9 (**permalink**) 13-08-2007, 12:10:54

Alıntı:

Lisans´isimli üyeden Alıntı

Senin ana sayfandaki linkler nerden geliyor yada index.php kodlarını iliştirirsen ayarlarız birşeyler

Söylediğin gibi hata bende

linklerin olduğu değilde yönelendiği sayfanın kodlarını vermiştim.
Örnek sayfa:

PHP Kodu:

  <?

$kategori="Aşk - Sevgi";

$re = mysql_query("SELECT * FROM kategoriler Where kategori='$kategori'");

$res = mysql_fetch_array($re);

$s=$res[adet];

if (!$k)

{

$k=0;

}

$resultb = mysql_query("SELECT * FROM siteler where kategori='$kategori' and onay='True'  ORDER BY bgelen DESC limit $k,$s");

?>

<table width="130" border="0">

<tr>

<td>

<?

$i=1;

while ($resultat = mysql_fetch_array($resultb)) {

$hikaye_adi=substr("$resultat[ad]",0,20);

$sayac=substr("$resultat[bgelen]",0,20);

echo "<TR>\n";

echo "<TD width=800><a target=_blank href=\"".$resultat[ad]."-".$resultat[sno].".html\">$hikaye_adi</a></br></i></TD>\n";

echo "</TR>\n";

$i++;

$s++;

}

$query = "SELECT count(*) as count FROM siteler where kategori='$kategori' and onay='True' ";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

$numrows = $row['count'];

if($numrows > ($res[adet]))                                                 {

?></td>

</tr>

<tr>

<td><? echo "<b><A href=\"ask_.html"."\" alt=\"Pop Window\">\n";

echo "Devami &gt;&gt;</a></b>"; ?></td>

</tr><? } ?>

</table>

</body>

</html>

Bunda da bir çok kez denedim fakat bir türlü yapamadım

~~Lisans~~ · #10 (**permalink**) 13-08-2007, 18:04:11

PHP Kodu:

  <? 
function Cevir($url){
$Tr = array("Ğ","Ü","Ş","İ","Ö","Ç","ğ","ü","ş","ı","ç"," ","+");
$En = a