• 26-09-2008, 15:42:41
    #1
    arkadaşlar ben download sitemde adı ile sorgulama yapılıyor ben adı yanına id eklemek istiyorum önce .htaccess dosyasına
    RewriteRule Program/(.*)-(.*).html$ detay.php?adi_s=$1&id=$2 [L,NC]
    ekledim .htaccess aşağıdadır hata yapmış olabilirim
    Options +FollowSymlinks
    RewriteEngine On
    RewriteRule Program/(.*)-(.*).html$ detay.php?adi_s=$1&id=$2 [L,NC]
    RewriteRule ^$                  index.php                                    [L]
    RewriteRule ^/index.php$        index.php                                    [L]
    RewriteRule ^/$                 index.php                                    [L]
    RewriteRule ^index.html$        index.php                                       [L]
    RewriteRule ^Haberler.html$        haberler.php                                       [L]
    RewriteRule ^Iletisim.html$        iletisim.php                                       [L]
    RewriteRule kategori/(.*)/(.*)-([0-9]+).html$                	kat.php?tur=altkat&kat=$2&page=$3             [L]
    RewriteRule kategori/(.*)/(.*).html$                	kat.php?tur=altkat&kat=$2&page=1             [L]
    RewriteRule kategori/(.*)-([0-9]+).html$                	kat.php?tur=kat&kat=$1&page=$2             [L]
    RewriteRule kategori/(.*).html$                	kat.php?tur=kat&kat=$1&page=1             [L]
    RewriteRule En_Yeniler-([0-9]+).html$                	en.php?tur=En_Yeni&turx=tarih&page=$1&link=En_Yeniler             [L]
    RewriteRule En_Iyiler-([0-9]+).html$                	en.php?tur=En_İyi&turx=hit&page=$1&link=En_Iyiler             [L]
    RewriteRule En_Yeniler.html$                	en.php?tur=En_Yeni&turx=tarih&page=1&link=En_Yeniler             [L]
    RewriteRule En_Iyiler.html$                	en.php?tur=En_İyi&turx=hit&page=1&link=En_Iyiler             [L]
    RewriteRule sonaranan-([0-9]+).html$                	sonaranan.php?tur=sonaranan&turx=hit&page=$1&link=sonaranan             [L]
    RewriteRule sonaranan.html$                	sonaranan.php?tur=sonaranan&turx=tarih&page=1&link=sonaranan             [L]
    RewriteRule sonaranan.html$                	sonaranan.php?tur=sonaranan&turx=hit&page=1&link=sonaranan             [L]
    RewriteRule encokaranan-([0-9]+).html$                	encokaranan.php?tur=encokaranan&turx=hit&page=$1&link=encokaranan        [L]
    RewriteRule encokaranan.html$      	encokaranan.php?tur=encokaranan&turx=tarih&page=1&link=encokaranan             [L]
    RewriteRule encokaranan.html$                	encokaranan.php?tur=encokaranan&turx=hit&page=1&link=encokaranan         [L]
    RewriteRule guncellenen-([0-9]+).html$                	guncellenen.php?tur=guncellenen&turx=hit&page=$1&link=guncellenen        [L]
    RewriteRule guncellenen.html$      	guncellenen.php?tur=guncellenen&turx=tarih&page=1&link=guncellenen           [L]
    RewriteRule guncellenen.html$                	guncellenen.php?tur=guncellenen&turx=hit&page=1&link=guncellenen         [L]
    RewriteRule Turkce_Arsiv-([0-9]+).html$                	dilarsiv.php?tur=Türkçe&page=$1&link=Turkce_Arsiv             [L]
    RewriteRule Yabanci_Arsiv-([0-9]+).html$                	dilarsiv.php?tur=İngilizce&page=$1&link=Yabanci_Arsiv             [L]
    RewriteRule Turkce_Arsiv.html$                	dilarsiv.php?tur=Türkçe&page=1&link=Turkce_Arsiv             [L]
    RewriteRule Yabanci_Arsiv.html$                	dilarsiv.php?tur=İngilizce&page=1&link=Yabanci_Arsiv             [L]
    RewriteRule Haber/(.*).html$                	haberdetay.php?id=$1             [L]
    RewriteRule Program/(.*).html$                	detay.php?id=$1             [L]
    RewriteRule download/(.*).html$                	indir.php?id=$1             [L]
    RewriteRule kirik-link/(.*).html$                	kiriklink.php?id=$1             [L]
    Daha sonra detay php sorgulaması aşağıda gibidir
    <?
    $id = $_GET['id'];
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '$id'"));
    $s=mysql_fetch_array(mysql_query("Select * from kategori where id = '$r[kategori]'"));
    ?>
    birde aşağıdaki sorgulama var
    <?$id = $_GET['id'];
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '$id'"));
    ben sadece
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '$id'"));
    satırını
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s='".$_GET['adi_s']."' and id='".$_GET['id']."'");
    olarak değiştim ama hata verdi ne yapmam gerekiyor başka nereleri değişmeliyim
  • 26-09-2008, 17:30:31
    #2
    <?
    $id = $_GET['id'];
    $adi_s = $_GET['adi_s'];
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '%$adi_s%' AND id= '%$id%'"));

    ?>


    Şeklinde yapınız. Form sayfasındanda kategori name'i adi_s yapmayı unutmayınız.
  • 28-09-2008, 01:08:30
    #3
    Form sayfasındanda kategori name'i adi_s yapmayı unutmayınız.
    demişsiniz form sayfası nerededir?
  • 28-09-2008, 01:16:03
    #4
    Kimlik doğrulama veya yönetimden onay bekliyor.
    <?
    $id = $_GET['id'];
    $adi_s = $_GET['adi_s'];
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '$adi_s' AND id= '$id'"));
    ?>
    yapmanız yeterli...
  • 28-09-2008, 09:48:19
    #5
    üstadım aynen yaptım fakat id yine eklemedi size detay.php ozelden göndersem bakarmısınız
  • 28-09-2008, 15:43:01
    #6
    RewriteRule Program/(.*)-(.*).html$ detay.php?adi_s=$1&id=$2 [L,NC]
    htaccess'de ki bu ölümü aşağıda vereceğim şekilde değiştirin...

    RewriteRule Program/(.*)-([0-9]+).html$ detay.php?adi_s=$1&id=$2 [L,NC]
  • 29-09-2008, 10:15:25
    #7
    üstadım olmadı acaba detay.php de bir kaç kez sorgulama yapılmış hepsini
    <?
    $id = $_GET['id'];
    $adi_s = $_GET['adi_s'];
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '$adi_s' AND id= '$id'"));
    ?>

    bu şekilde değiştireyim mi?
  • 29-09-2008, 17:02:59
    #8
    detay.php dener misiniz ?

    <? include ("dbs.php"); ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
    <html>
    
    <head>
       <?
    $id = $_GET['id'];
    $adi_s = $_GET['adi_s'];
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '$adi_s' AND id = '$id'"));
    ?> 
    
    <title><? echo $r[isim];?> <? echo $r[tags]; ?> <? echo $r[surum];?> <? echo $r[etiket]; ?> <? echo $s[adi]; ?> - <? echo $site_adi; ?> .::. <? echo $slogan; ?></title>
    
    <link title="Visual" href="<? echo $site; ?>/global_1.css" type="text/css" rel="stylesheet" />
    <link href="<? echo $site; ?>/iehacks.css" type="text/css" rel="stylesheet" />
    <script src="<? echo $site; ?>/images/global.js" type="text/javascript"></script>
    <script src="<? echo $site; ?>/images/quicktags.js" type="text/javascript"></script>
    </head>
    
    <body>
    
    <? include ("header.php"); ?>
    <? include ("left.php"); ?>
    <?
    $id = $_GET['id'];
    $adi_s = $_GET['adi_s'];
    $r=mysql_fetch_array(mysql_query("Select * from program where adi_s = '$adi_s' AND id = '$id'"));
    $pid = $r[id];
    
        $r1=mysql_fetch_array(mysql_query("Select * from kategori where id='$r[kategori]'"));
        $r2=mysql_fetch_array(mysql_query("Select * from altkat where id='$r[altkat]'"));
    
    ?><div id="col_mid">
        <div class="box" style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px">
            <div class="box_title_blue" style="FONT-WEIGHT: normal">
                <h1><strong><? echo $r[isim];?> <? echo $r[surum];?></strong></h1>
            </div>
            <div class="box_baseline">
                <div style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 3px">
    
    
    
                    <table border="0" width="100%">
            <tr>
                <td><img src="<? echo $site; ?>/images/a_menulink_bg.gif" />
                    <strong class="blue">
                    <a href="<? echo $site; ?>/kategori/<? echo $r1[adi_s];?>.html"><? echo $r1[adi];?></a> 
                    »
                    <a href="<? echo $site; ?>/kategori/<? echo $r1[adi_s];?>/<? echo $r2[adi_s];?>.html">
                    <? echo $r2[adi];?></a> »</strong> <? echo $r[isim];?><strong></strong></div>
                <table cellspacing="1" cellpadding="5" width="100%" border="0">
                    <tr>
                        <td class="gradient_a_left" align="right" width="150">İndirme 
                        Sayısı :</td>
                        <td class="gradient_a_right"><? echo $r[hit];?></td>
                    </tr>
    
                                    
                                                    <tr>
                        <td class="gradient_a_left" align="right" width="150">Sürüm 
                        :</td>
                        <td class="gradient_a_right"><? echo $r[surum];?></td>
                    </tr>
    
    
                                     
                                     <tr>
                        <td class="gradient_a_left" align="right" width="150">Kullanım İzni 
                        :</td>
                        <td class="gradient_a_right"><? echo $r[izin];?></td>
                    </tr>
    
    
                                    <tr>
                                            <td class="gradient_a_left" align="right" width="150">İşletim Sistemi 
                        :</td>
                        <td class="gradient_a_right"><? echo $r[isletimsistemi];?></td>
                    </tr>
    
                    <tr>
                        <td class="gradient_a_left" align="right" width="150">Boyut 
                        :</td>
                        <td class="gradient_a_right"><? echo $r[boyut];?></td>
                    </tr>
                    
                                    <tr>
                        <td class="gradient_a_left" align="right" width="150">Üretici 
                        Firma :</td>
                        <td class="gradient_a_right">
                        <a href="<? echo $r[firmaadres];?>" target="blank"><? echo $r[firma];?></a></td>
                    </tr>
                    <tr>
                        <td class="gradient_a_left" align="right" width="150">Dil :</td>
                        <td class="gradient_a_right"><? echo $r[dil];?></td>
                    </tr>
                    
                    <tr>
                        <td class="gradient_a_left" align="right" width="150">Eklenme 
                        Tarihi :</td>
                        <td class="gradient_a_right"><? echo $r[tarih];?></td>
                    </tr>
                    <tr>
                        <td class="gradient_a_left" align="right" width="150">Ortalama 
                        Oy :</td>
                        <td class="gradient_a_right"><? echo ortalama($r[voteint],$r[vote]);?>
                    </td>
                    </tr>
                    <tr>
                        <td class="gradient_a_left" align="right" width="150">
                        Oy Ver :</td>
                        <td class="gradient_a_right">
    <?if(!$_COOKIE[$r[adi_s]]) {
    ?><script language="Javascript">
        function Oyla() {
                document.OyForm.submit(); 
            } 
       </script>
     <table width="%100" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse">
       <form name="OyForm" action="/puan.php?ID=<? echo $r[adi_s];?>" method="post">
        <tr>
          <td><span><input type="radio" value="1"  name="Puan" onClick="javascript:Oyla();"></span></td>
          <td><span><input type="radio" value="2"  name="Puan" onClick="javascript:Oyla();"></span></td>
          <td><span><input type="radio" value="3"  name="Puan" onClick="javascript:Oyla();"></span></td>
          <td><span><input type="radio" value="4"  name="Puan" onClick="javascript:Oyla();"></span></td>
          <td><span><input type="radio" value="5"  name="Puan" onClick="javascript:Oyla();"></span></td>
        </tr>
        <tr>
          <td class="yazi" align="center"><b>1</b></td>
          <td class="yazi" align="center"><b>2</b></td>
          <td class="yazi" align="center"><b>3</b></td>
          <td class="yazi" align="center"><b>4</b></td>
          <td class="yazi" align="center"><b>5</b></td>
        </tr>
        </form>
      </table><?}else{
    echo "Bu içeriğe oy verdiniz.";
    }?>
                    </td>
                    </tr>
                </table>
                
                <center>
    </p>
    
                <span style="vertical-align: super"><strong>
    <font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font>
    <a href="<? echo $site; ?>/download/<? echo $r[adi_s];?>.html">
    <font size="2" color="#000000">İndir</font></a></strong></span><font size="2"> </font>
    <center>
    </p>
    </center>
                <div style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px">
                    <img style="VERTICAL-ALIGN: middle" alt="" src="<? echo $site; ?>/images/icon_keyboard.gif" 
    
    />
                    <strong class="blue">Üretici Açıklaması :</strong><table border="0" width="78%" id="table1">
                        <tr>
                            <td>&nbsp;</td>
                            <td width="214">
    </td>
                        </tr>
                    </table>
    
    
    
                    <p>
    <? echo $r[aciklama];?></td>
    
    
    <br />
    
            </tr>
            </table>
                        
                    <p><br />
    <? echo $r[tags];?></td>
    <p><br />
    
            </tr>
            </table>
        
    
    <td>İlgili Kelimeler </td><br />
    
      <?
    
    $aciklama=$r['etiket'];
    $kes = explode(', ',$aciklama); 
    $say=count($kes); 
    $i=0; 
    for($i=0;$i<count($kes);$i++)
    echo '<a href="../arama.php?query='.$kes[$i].'">'.$kes[$i].'<br> ';
     ?>
    
            </tr>
            </table>
                </div>
    
                <div class="box_title_blue" style="FONT-WEIGHT: normal">
                <h1><strong>Yorumlar</strong></h1>
            </div>
            
            <div class="tut" id=yorumlar>
    <?
    $q=mysql_query("Select * from yorumlar where durum=1 and pid = '$r[id]'");
        $nr2=mysql_num_rows($q);
        if($nr2 == 0) {
        echo 'Yorum yapılmamış.';
        }else{
    
        while ($r=mysql_fetch_array($q)) {
    ?>
    
        <div class="tut_info"><h3><? echo $r[yorum];?></h3><p>Yazan: <span class="orange"><a href="mailto:<? echo $r[email];?>"><? echo $r[yazan];?></A></span> | Tarih: <span class="orange"><? echo $r[tarih];?></span></P></div>
    <?
    }
    }?>
        </div>
    <form action="<? echo $site; ?>/yorumkaydet.php"  method="post">
    <input type=hidden name=pid value="<? echo $pid;?>">
    <strong>Adınız :</strong><br />
    <input name="yazan" type="text" class="normalbox" maxlength="255" style="width:400px;" value="" /><br />
    <strong>E-Mail Adresiniz :</strong><br>
    <input name="email" type="text" class="normalbox" maxlength="255" style="width:400px;" value="" /><br />
    <strong>Yorumunuz :</strong><br>
    <textarea name="yorum" class="normalbox" style="width:400px;" ></textarea><br />
    <input type="submit" name="submit" value="Gönder" accesskey="s" />
    <input type="hidden" name="adi" value="<? echo $_GET['id'];?>">
    </form>
            </div>
        </div>
    </div>
    <div id="col_right">
    <? include ("inc_sagreklam1.php"); ?>
            
        <div class="box" style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px">
            <div class="box_title_green">
                <p>
    <font color="#FF0000" size="4" face="Alba">Yeni Eklenen Programlar</font></p></div>
            <div class="box_baseline">
                <?
    $q=mysql_query("Select * from program  order by tarih desc limit 0,10");
    while ($r=mysql_fetch_array($q)) {
    $r1=mysql_fetch_array(mysql_query("Select * from kategori where id='$r[kategori]'"));
    $r2=mysql_fetch_array(mysql_query("Select * from altkat where id='$r[altkat]'"));
    ?>
    
                <div class="yeniler">
                    <h4>
                    <a class="blue" title="<? echo $r[isim];?>" href="<? echo $site; ?>/Program/<? echo $r[adi_s];?>.html">
                    <? echo $r[isim];?></a></h4>
                    <p><? echo substr($r[aciklama],0,50);?>... </p>
                    <p>
                    <a class="green" href="<? echo $site; ?>/kategori/<? echo $r1[adi_s];?>.html">
                    <? echo $r1[adi];?></a> /
                    <a class="green" href="<? echo $site; ?>/kategori/<? echo $r1[adi_s];?>/<? echo $r2[adi_s];?>.html">
                    <? echo $r2[adi];?></a> </p>
                </div>
    
    <?}
    ?>&nbsp; </div>
        </div>
    </div></div>
        <? include ("footer.php"); ?>
    
    </body>
    
    </html>
  • 30-09-2008, 20:31:01
    #9
    üstadım herşey içinsağolun olmadı bu seferde içeriği tamamen sildi yan idi eklemediği gibi içerikte yazan herşeyide göstermiyor