• 04-01-2008, 12:38:02
    #1
    S.a arkadaslar sorunum konu ismini title a yazdıramamak herşeyi denedim olmadı :s title yazdırabilsem keywords a flnda yazdırcam ama olmadı

    sizde bi bakarsanız sewinirim

    <HTML>
    <?
    $index=$_GET['id']-150;
                                                    
                                          
                    $result = mysql_query("SELECT *  FROM urun_bilgi  where urun_ID=$index");
                    $row = mysql_fetch_array($result); 
                    
                
    $noxious = $row[urun_adi];
    
    
    
    
    ?>
    <HEAD>
        <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1254">
        <META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-9">
        <meta name="description" content="<?=$noxious?>">
    <META name="keywords" content="<?=$noxious?>">
    
        <META http-equiv="content-language" content="TR">
        <link href="./ana.css" type="text/css" rel="stylesheet" />    
        <TITLE><?php $noxious  ?></TITLE>
    </HEAD>
    
           
    
    <BODY BGCOLOR="white" topmargin="0" leftmargin="0">
    
    
      <div align="center">
    
    
                  
                <?php
    include("seo.inc.php");
    include("admin/dataconn.php");      
                    include("./sabit/logoanddrop.php");
                ?>
            
    
        
        <table border="0" cellpadding="0" cellspacing="0" width="1000">
          <tr>
          <td width="1000"  valign="TOP" bgcolor="#F2F2F2" colspan="4" height="13">
          
                <font face="Tahoma" style="font-size: 4pt">&nbsp;</font></td>
        </tr>
          <tr>
          <p class="style31" align="left">
          <td width="150"  valign="TOP" bgcolor="#F2F2F2">
    <?php
                      $index=$_GET['id']-150;
                    include("admin/dataconn.php");                                      
                                          
                    $result = mysql_query("SELECT *  FROM urun_bilgi  where urun_ID=$index");
                    $row = mysql_fetch_array($result);       
            
    
    
                     include("sabit/urun_sol_menu.php");
            
            
            
              echo"  &nbsp;</td>
                         
                         
              <td width='630' valign='TOP'>
    
            
                <table border='0' width='630' id='table8' cellspacing='0' cellpadding='0'>
                        <tr>
                            <td width='630' valign='top' align='left' height='10' class=sayfabaslik>
                
                            <img border='0' src='resim/navright_home.gif' width='18' height='10' align='left' hspace='0'>:: Ürün Özellikleri</td>    
                        </tr>
    
            </table>
                      
    
    
                <p>";
            
            
                    include("./sabit/urun_header.php");
                   
                    echo"<div align='center'>
                    <table border='0' width='600' id='table5'>
                                
                    
                            <tr>
                        <td>
                            <font face='Tahoma' style='font-size: 10pt' color='#003399'><b>Ürün Açıklaması:</b></font></td>
                            </tr>
                    
                            <td>";
                        $aciklama=$row['aciklama'];    
                        $aciklama= str_replace("xy_z","'",$aciklama);     
    
                        echo"<font face='Tahoma' style='font-size: 10pt'>$aciklama</font></td>
                            </tr>
                    
                            <tr>
                        <td height='20'>
                            &nbsp;</td>
                            </tr>
                    
                            <tr>
                        <td>
                            <p>
                            <font face='Tahoma' style='font-size: 10pt' color='#003399'>
                            <b>
                        <label for='ozellik'>Ürün Özellikleri:</label></b></font></td>
                            </tr>
                    
                            <tr>
                        <td>";
                        $ozellik=$row['ozellik'];
                        $ozellik= str_replace("xy_z","'",$ozellik);     
    
                        echo"<font face='Tahoma' style='font-size: 10pt'>$ozellik</font></td>
                            </tr>
                    
                            <tr>
                        <td height='20'>
                        &nbsp;</td>
                            </tr>
                    
                            <tr>
                        <td>
                        <p>
                        <label for='sistemgereksinim'>
                        <font face='Tahoma' style='font-size: 10pt' color='#003399'>
                        <b>Sistem Gereksinimleri: </b></font></label>    </td>
                            </tr>
                    
                            <tr>
                        <td>
                        <font face='Tahoma' style='font-size: 10pt'>";
                        $sistemgerek=$row['sistemgerek'];
                        $sistemgerek= str_replace("xy_z","'",$sistemgerek);     
    
                        echo $sistemgerek."</font></td>
                            </tr>
                    
                            <tr>
                        <td>
                        <p align='right'>
                        <font color='#CC0000'>
                        <font face='Tahoma' color='#CC0000'>
                        <span style='text-decoration: none'>
                        <a href='#TOP'><font color='#000000' style='font-size: 10pt'>
                        <span style='text-decoration: none; font-weight:700'>Başa Dön</span></font></a></span></font><font face='Tahoma' size='2' color='#CC0000'></a></font></font><font face='Tahoma' size='2' color='#CC0000'><a href='#TOP'><span style='text-decoration: none'>
                        </span>
                        </a></font><a href='#TOP'>
                        <img border='0' src='resim/arrow_up.gif' width='20' height='20'></a></td>
                            </tr>
                    
                        <tr>
                            <td bgcolor='#f4e6e6'><font color='#CC0000'><b><span style='font-size: 10pt'>
                            <img border='0' src='resim/kvkutu1.gif' width='9' height='9'></span><font face='Tahoma' style='font-size: 10pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                            Aynı kategorideki Diğer Ürünler:</font></b></font></td>
                        </tr>
                        <tr>        <td>";
                            $kategori=$row['kategori'];
                            $result = mysql_query("SELECT urun_adi,urun_ID  FROM urun_bilgi  where kategori='$kategori' order by urun_adi");
            
    
                            
                            echo"<center>
                            
                            <table border='0' width='600' id='table7' bgcolor='#F2F2F2'>";
                            
                                            while($row = mysql_fetch_array($result)){
                                                    $index = 150+ $row['urun_ID'];
                                                    
                                                    echo" 
                                                    <tr>
                                                        <td width='100%'>
                                                            &nbsp;&nbsp;
                                                            <img border='0' src='./resim/arrow_r.gif' width='7' height='7'>
                                                            <a href='urun_detay.php?id=$index' class=urunlistesi>".$row['urun_adi']."</a>
                                                        </td>
                                                    </tr>";
                                            }
                            echo "</table>
                            
                            </center>
                            </td></tr>
                        
            
            
            </table>
                      
    
                
    
                
                
    
                
              
    
                </div>
                      
    
                
    
                
                
    
                
              
    
                </td>
    
            
                <td width='20' valign='TOP' align='center' background='resim/dotv.gif'>&nbsp;</td>
    
            
                <td width='200' valign='TOP' align='center'>";
            
            
                include("sabit/urun_sag_menu.php"); 
                
            ?>
    
                
                
                </td>
    
            
        </tr>
          <tr>
          <td width="1000"  valign="TOP" height="10" colspan="4">
          
                <img border="0" src="resim/navbottom_home.gif" width="150" height="7"></td>
        </tr>
        <tr>
        <td width="1000"  valign="TOP" height="10" colspan="4">
            <img border="0" src="resim/1pix.gif" width="1" height="7"></td>
        </tr>
    
                            <?php
    include("./sabit/altkisim.php");
    ?>                        </table>
    
    
        </div>
    
    
    </BODY>
    
    </HTML>
  • 04-01-2008, 12:47:59
    #2
    sanırım sql sorgununda sorun var

    biraz karmaşık yazmışsın kodları sanırım o yüzden kimse cevap vermek istememiş ama şu alttakini bi dene.

    <HTML>
    <?
    $index=$_GET['id']-150;
                                                    
                                          
                    $result = mysql_query("SELECT *  FROM `urun_bilgi`  where `urun_ID`='".$index."'");
                    $row(mysql_fetch_array($result)){
    					$noxious = $row[urun_adi];				
    				}; 
    ?>
    <HEAD>
        <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1254">
        <META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-9">
        <meta name="description" content="<?=$noxious?>">
    <META name="keywords" content="<?=$noxious?>">
    
        <META http-equiv="content-language" content="TR">
        <link href="./ana.css" type="text/css" rel="stylesheet" />    
        <TITLE><?php $noxious  ?></TITLE>
    </HEAD>
    
           
    
    <BODY BGCOLOR="white" topmargin="0" leftmargin="0">
    
    
      <div align="center">
    
    
                  
                <?php
    include("seo.inc.php");
    include("admin/dataconn.php");      
                    include("./sabit/logoanddrop.php");
                ?>
            
    
        
        <table border="0" cellpadding="0" cellspacing="0" width="1000">
          <tr>
          <td width="1000"  valign="TOP" bgcolor="#F2F2F2" colspan="4" height="13">
          
                <font face="Tahoma" style="font-size: 4pt">&nbsp;</font></td>
        </tr>
          <tr>
          <p class="style31" align="left">
          <td width="150"  valign="TOP" bgcolor="#F2F2F2">
    <?php
                      $index=$_GET['id']-150;
                    include("admin/dataconn.php");                                      
                                          
                    $result = mysql_query("SELECT *  FROM urun_bilgi  where urun_ID=$index");
                    $row = mysql_fetch_array($result);       
            
    
    
                     include("sabit/urun_sol_menu.php");
            
            
            
              echo"  &nbsp;</td>
                         
                         
              <td width='630' valign='TOP'>
    
            
                <table border='0' width='630' id='table8' cellspacing='0' cellpadding='0'>
                        <tr>
                            <td width='630' valign='top' align='left' height='10' class=sayfabaslik>
                
                            <img border='0' src='resim/navright_home.gif' width='18' height='10' align='left' hspace='0'>:: Ürün Özellikleri</td>    
                        </tr>
    
            </table>
                      
    
    
                <p>";
            
            
                    include("./sabit/urun_header.php");
                   
                    echo"<div align='center'>
                    <table border='0' width='600' id='table5'>
                                
                    
                            <tr>
                        <td>
                            <font face='Tahoma' style='font-size: 10pt' color='#003399'><b>Ürün Açıklaması:</b></font></td>
                            </tr>
                    
                            <td>";
                        $aciklama=$row['aciklama'];    
                        $aciklama= str_replace("xy_z","'",$aciklama);     
    
                        echo"<font face='Tahoma' style='font-size: 10pt'>$aciklama</font></td>
                            </tr>
                    
                            <tr>
                        <td height='20'>
                            &nbsp;</td>
                            </tr>
                    
                            <tr>
                        <td>
                            <p>
                            <font face='Tahoma' style='font-size: 10pt' color='#003399'>
                            <b>
                        <label for='ozellik'>Ürün Özellikleri:</label></b></font></td>
                            </tr>
                    
                            <tr>
                        <td>";
                        $ozellik=$row['ozellik'];
                        $ozellik= str_replace("xy_z","'",$ozellik);     
    
                        echo"<font face='Tahoma' style='font-size: 10pt'>$ozellik</font></td>
                            </tr>
                    
                            <tr>
                        <td height='20'>
                        &nbsp;</td>
                            </tr>
                    
                            <tr>
                        <td>
                        <p>
                        <label for='sistemgereksinim'>
                        <font face='Tahoma' style='font-size: 10pt' color='#003399'>
                        <b>Sistem Gereksinimleri: </b></font></label>    </td>
                            </tr>
                    
                            <tr>
                        <td>
                        <font face='Tahoma' style='font-size: 10pt'>";
                        $sistemgerek=$row['sistemgerek'];
                        $sistemgerek= str_replace("xy_z","'",$sistemgerek);     
    
                        echo $sistemgerek."</font></td>
                            </tr>
                    
                            <tr>
                        <td>
                        <p align='right'>
                        <font color='#CC0000'>
                        <font face='Tahoma' color='#CC0000'>
                        <span style='text-decoration: none'>
                        <a href='#TOP'><font color='#000000' style='font-size: 10pt'>
                        <span style='text-decoration: none; font-weight:700'>Başa Dön</span></font></a></span></font><font face='Tahoma' size='2' color='#CC0000'></a></font></font><font face='Tahoma' size='2' color='#CC0000'><a href='#TOP'><span style='text-decoration: none'>
                        </span>
                        </a></font><a href='#TOP'>
                        <img border='0' src='resim/arrow_up.gif' width='20' height='20'></a></td>
                            </tr>
                    
                        <tr>
                            <td bgcolor='#f4e6e6'><font color='#CC0000'><b><span style='font-size: 10pt'>
                            <img border='0' src='resim/kvkutu1.gif' width='9' height='9'></span><font face='Tahoma' style='font-size: 10pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                            Aynı kategorideki Diğer Ürünler:</font></b></font></td>
                        </tr>
                        <tr>        <td>";
                            $kategori=$row['kategori'];
                            $result = mysql_query("SELECT urun_adi,urun_ID  FROM urun_bilgi  where kategori='$kategori' order by urun_adi");
            
    
                            
                            echo"<center>
                            
                            <table border='0' width='600' id='table7' bgcolor='#F2F2F2'>";
                            
                                            while($row = mysql_fetch_array($result)){
                                                    $index = 150+ $row['urun_ID'];
                                                    
                                                    echo" 
                                                    <tr>
                                                        <td width='100%'>
                                                            &nbsp;&nbsp;
                                                            <img border='0' src='./resim/arrow_r.gif' width='7' height='7'>
                                                            <a href='urun_detay.php?id=$index' class=urunlistesi>".$row['urun_adi']."</a>
                                                        </td>
                                                    </tr>";
                                            }
                            echo "</table>
                            
                            </center>
                            </td></tr>
                        
            
            
            </table>
                      
    
                
    
                
                
    
                
              
    
                </div>
                      
    
                
    
                
                
    
                
              
    
                </td>
    
            
                <td width='20' valign='TOP' align='center' background='resim/dotv.gif'>&nbsp;</td>
    
            
                <td width='200' valign='TOP' align='center'>";
            
            
                include("sabit/urun_sag_menu.php"); 
                
            ?>
    
                
                
                </td>
    
            
        </tr>
          <tr>
          <td width="1000"  valign="TOP" height="10" colspan="4">
          
                <img border="0" src="resim/navbottom_home.gif" width="150" height="7"></td>
        </tr>
        <tr>
        <td width="1000"  valign="TOP" height="10" colspan="4">
            <img border="0" src="resim/1pix.gif" width="1" height="7"></td>
        </tr>
    
                            <?php
    include("./sabit/altkisim.php");
    ?>                        </table>
    
    
        </div>
    
    
    </BODY>
    
    </HTML>
  • 04-01-2008, 12:52:52
    #3
    malisef yukardaki kodları deneyince :s sayfa boş çıktı hiç bir hata vermedi
  • 04-01-2008, 12:59:55
    #4
    özür dilerim tekrar düzenledim. bi daha deneyebilirsin.
  • 04-01-2008, 13:06:58
    #5
    <?
    $index=$_GET['id']-150;
    $result=mysql_query("SELECT *  FROM urun_bilgi  where urun_ID='".$index."'") or die(mysql_error());
    while($row=mysql_fetch_array($result)) {
    $noxious=$row['urun_adi'];
    }
    ?>
    Sayfanın en üstündeki kodu bu şekilde değiştirip dener misin ?
  • 04-01-2008, 13:39:39
    #6
    Access denied for user 'nobody'@'localhost' (using password: NO) hatası verdi :s
  • 04-01-2008, 13:58:44
    #7
    Sayfanın en üstünde bir veritabanı bağlantısı yapmadıysan haliyle hata verecektir .. Aşağıdaki bilgileri kendine göre değiştirip, sayfanın en üstüne koy.

    <?php
    $host="localhost";
    $kullanici="root";
    $sifre="sifre";
    $veritabani="veritabani";
    $db=mysql_connect($host,$kullanici,$sifre);
    mysql_select_db($veritabami,$db);
    mysql_query("SET NAMES 'latin5'");
    ?>
  • 04-01-2008, 14:14:50
    #8
    ama include (config.php) olayını yapmıştım :S ne gerek varki?:S
  • 04-01-2008, 15:25:40
    #9
    Aykut adlı üyeden alıntı: mesajı görüntüle
    Sayfanın en üstünde bir veritabanı bağlantısı yapmadıysan..
    demişim zaten. Yaptıysan config.php'ndeki bilgilerin doğruluğunu kontrol et.