• 05-12-2008, 19:27:21
    #1
    Arkadşalar şimdi oyun düzenleme yeri var şurdan bakın

    Untitled Document

    burası şimdi oyunu seçip düzenle diyorum ama adres satırında id yi yollamıyor öyle yapıyorum kayıyor böyle yapıyorum gödnermiyor çıldıracam kodlar aşağıda bi bakın lütfen

    <?php
    require("/var/www/vhosts/chatlok.com/httpdocs/oyun/inc/sql.php");
    
    
    
    $sorgu=mysql_query("select * from oyun_bilgi");
    
    $satir=mysql_num_rows($sorgu);
    
    if ($satir > 0)
    {
    
    
    		
    
    
    
    
    ?>
    
    
    
    
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Untitled Document</title>
    <link href="style.css" rel="stylesheet" type="text/css" />
    <!--[if lt IE 7.]>
    <script defer type="text/javascript" src="pngfix.js"></script>
    <![endif]-->
    <style type="text/css">
    <!--
    .style1 {
    	color: #666666;
    	font-size: 12px;
    }
    #apDiv1 {
    	position:absolute;
    	left:33px;
    	top:295px;
    	width:584px;
    	height:281px;
    	z-index:1;
    }
    #apDiv2 {
    	position:absolute;
    	left:225px;
    	top:266px;
    	width:328px;
    	height:301px;
    	z-index:1;
    }
    -->
    </style>
    <script type="text/javascript">
    <!--
    function MM_jumpMenu(targ,selObj,restore){ //v3.0
      eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
      if (restore) selObj.selectedIndex=0;
    }
    //-->
    </script>
    </head>
    <body>
    
    
    <!--ana tasiyici bas-->
    <div id="apDiv2">
    
    
      <form action="editgame1.php?id=<?php echo $id; ?>" method="post" name="form2" id="form2">
        <p>
          <label></label>
        </p>
        <table width="145" height="101" border="1" cellpadding="0" cellspacing="0">
          <tr>
            <td width="141" height="67" class="arama_label">Oyun Adı:        
              <label>
    		  		 
    		  
              <select name="oyunduz" >
    <?php
    		 while ($data=mysql_fetch_assoc($sorgu))
    { 
    ?>
              <option value=<?php echo $data[baslik];  ?>><?php echo $data[baslik]; }?></option>
    		 
              </select>
            </label></td>
          </tr>
        </table>
        <p>
          <label></label>
          <label></label>
          <label>
          <input type="submit" name="button" id="button" value="D&uuml;zenle" />
          </label>
        </p>
        <p>
          <label></label>
        </p>
      </form>
    </div>
    <?php } ?>
    <div class="ana_cont">
    <div class="ic_cont" style="height:700px;">
    <div style="background-image:url(images/ust.png); width:910px; height:36px;"></div>
    <!--header-->
    <div style="height:122px;">
    <div class="header_sol"><img src="images/logo.png" width="303" height="122" /></div>
    <div class="header_sag" align="right"><img src="images/kisi_icon.png" width="22" height="21" /><img src="images/main_icon.png" width="22" height="21" /><img src="images/love_icon.png" width="22" height="21" /><img src="images/mail_icon.png" width="22" height="21" />  </div>
    <div style="padding-top:5px; width:468px; float:right; margin-right:25px;"><img src="images/lipton.png" width="468" height="60" /></div>
    </div>
    <!--header-->
    <!--menu-->
    <div class="menu_cont">
    <a href="#"><img src="images/menu/zeka.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/macera.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/aksiyon.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/nisan.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/spor.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/dovus.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/kagit.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/yaris.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/barbie.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/cocuk.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/beceri.png" width="78" height="35" border="0" /></a></div>
    <!--menu-->
    <!--Giris-->
    <div class="user_cont">
    <div style="padding-top:5px; height:35px; padding-left:5px; width:500px; float:left">
      <form id="form1" name="form1" method="post" action="">
      <input name="textfield" type="text" class="myinputstyle"/>  
      <input name="textfield" type="password" class="myinputstyle" />
      <input type="button" class="mybuttonstyle" value="Giriş" />
      <span class="style1"><a href="#">&Uuml;ye Ol </a>|<a href="#"> Şifremi Unuttum</a></span> 
      </form>
    	</div>
    	<div style="width:300px; float:right; padding-top:5px; height:35px; padding-right:5px;"> <form id="form1" name="form1" method="post" action=""> 
      <font class="arama_label">Oyun Arama</font><input name="textfield" type="password" class="myinputstyle" />
      <input type="button" class="mybuttonstyle" value="Ara" />
      </form></div>
      </div>
    <!--Giris-->
    <div class="icerik_sol">
      <div class="oyun_title">
      <div style="float:left; padding-top:3px; padding-left:5px;"><a href="gameinsert.php"> Oyun Ekle</a>-<a href="gameedit.php"> Oyun D&uuml;zenle</a> -<a href="gamedelete.php">Oyun Sil</a></div>
      <div style="float:right; padding-top:3px; padding-right:15px;">DATE</div>
      </div>
    
      <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    
    
    
    
            <div class="footer">
    		 
    		  <div style="float:left; padding-left:5px; padding-top:10px;"><img src="images/footer_logo.png" width="113" height="33" /></div><div style="float:right; padding-top:7px; width:400px;"><span style="font-size:13px;">"© 2008 tatlioyun.net |  Her hakki saklidir.</span><br />
    		  <span class="oyun_yazi"><a href="#">Hakkimizda</a> | <a href="#">Kullanim sartlari</a> | <a href="#">Gizlilik sözlesmesi</a> | <a href="#">Yardim</a> | <a href="#">Iletisim</a> |<a href="#"> Duyurular </a></span></div>
    		</div>
    </div>
    
    <div class="icerik_sag" align="center">
    <br />
      <img src="images/google.png" width="234" height="60" />
      <br /><br />
      <br />
      <br />
      <br />
      <br />
      <img src="images/istatistik.png" width="254" height="29" /><br />
      <span class="oyun_yazi">500 Oyun toplamda 32.547 kez oynandi,
    suanda 56 uye ve 455 misafir kullanici oyunda.
    Toplam 5569 uyemiz var.</span></div>
    
    </div>
    </div>
    <!--ana tasiyici bit-->
    <div style="background-image:url(images/ana_alt.png); width:910px; margin-left:15px; height:40px;"></div>
    </body>
    </html>
  • 05-12-2008, 20:21:09
    #2
    hadi arkadşlar ya yokmu bilen
  • 05-12-2008, 20:38:01
    #3
    editgame1.php'de verileri get olarak alırsın id'i aldıktan sonra öyle sorgu yaparsın.
    <?php 
    require("/var/www/vhosts/chatlok.com/httpdocs/oyun/inc/sql.php"); 
    
    
    
    $sorgu=mysql_query("select * from oyun_bilgi"); 
    
    $satir=mysql_num_rows($sorgu); 
    
    if ($satir > 0) 
    { 
    
    
             
    
    
    
    
    ?> 
    
    
    
    
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
    <html xmlns="http://www.w3.org/1999/xhtml"> 
    <head> 
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> 
    <title>Untitled Document</title> 
    <link href="style.css" rel="stylesheet" type="text/css" /> 
    <!--[if lt IE 7.]> 
    <script defer type="text/javascript" src="pngfix.js"></script> 
    <![endif]--> 
    <style type="text/css"> 
    <!-- 
    .style1 { 
        color: #666666; 
        font-size: 12px; 
    } 
    #apDiv1 { 
        position:absolute; 
        left:33px; 
        top:295px; 
        width:584px; 
        height:281px; 
        z-index:1; 
    } 
    #apDiv2 { 
        position:absolute; 
        left:225px; 
        top:266px; 
        width:328px; 
        height:301px; 
        z-index:1; 
    } 
    --> 
    </style> 
    <script type="text/javascript"> 
    <!-- 
    function MM_jumpMenu(targ,selObj,restore){ //v3.0 
      eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); 
      if (restore) selObj.selectedIndex=0; 
    } 
    //--> 
    </script> 
    </head> 
    <body> 
    
    
    <!--ana tasiyici bas--> 
    <div id="apDiv2"> 
    
    
      <form action="editgame1.php" method="get" name="form2" id="form2"> 
        <p> 
          <label></label> 
        </p> 
        <table width="145" height="101" border="1" cellpadding="0" cellspacing="0"> 
          <tr> 
            <td width="141" height="67" class="arama_label">Oyun Adı:         
              <label> 
                        
               
              <select name=id" > 
    <?php 
             while ($data=mysql_fetch_assoc($sorgu)) 
    {  
    ?> 
              <option value=<?php echo $data[id];  ?>><?php echo $data[baslik]; }?></option> 
              
              </select> 
            </label></td> 
          </tr> 
        </table> 
        <p> 
          <label></label> 
          <label></label> 
          <label> 
          <input type="submit" name="button" id="button" value="D&uuml;zenle" /> 
          </label> 
        </p> 
        <p> 
          <label></label> 
        </p> 
      </form> 
    </div> 
    <?php } ?> 
    <div class="ana_cont"> 
    <div class="ic_cont" style="height:700px;"> 
    <div style="background-image:url(images/ust.png); width:910px; height:36px;"></div> 
    <!--header--> 
    <div style="height:122px;"> 
    <div class="header_sol"><img src="images/logo.png" width="303" height="122" /></div> 
    <div class="header_sag" align="right"><img src="images/kisi_icon.png" width="22" height="21" /><img src="images/main_icon.png" width="22" height="21" /><img src="images/love_icon.png" width="22" height="21" /><img src="images/mail_icon.png" width="22" height="21" />  </div> 
    <div style="padding-top:5px; width:468px; float:right; margin-right:25px;"><img src="images/lipton.png" width="468" height="60" /></div> 
    </div> 
    <!--header--> 
    <!--menu--> 
    <div class="menu_cont"> 
    <a href="#"><img src="images/menu/zeka.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/macera.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/aksiyon.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/nisan.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/spor.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/dovus.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/kagit.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/yaris.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/barbie.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/cocuk.png" width="78" height="35" border="0" /></a><a href="#"><img src="images/menu/beceri.png" width="78" height="35" border="0" /></a></div> 
    <!--menu--> 
    <!--Giris--> 
    <div class="user_cont"> 
    <div style="padding-top:5px; height:35px; padding-left:5px; width:500px; float:left"> 
      <form id="form1" name="form1" method="post" action=""> 
      <input name="textfield" type="text" class="myinputstyle"/>   
      <input name="textfield" type="password" class="myinputstyle" /> 
      <input type="button" class="mybuttonstyle" value="Giriş" /> 
      <span class="style1"><a href="#">&Uuml;ye Ol </a>|<a href="#"> Şifremi Unuttum</a></span>  
      </form> 
        </div> 
        <div style="width:300px; float:right; padding-top:5px; height:35px; padding-right:5px;"> <form id="form1" name="form1" method="post" action="">  
      <font class="arama_label">Oyun Arama</font><input name="textfield" type="password" class="myinputstyle" /> 
      <input type="button" class="mybuttonstyle" value="Ara" /> 
      </form></div> 
      </div> 
    <!--Giris--> 
    <div class="icerik_sol"> 
      <div class="oyun_title"> 
      <div style="float:left; padding-top:3px; padding-left:5px;"><a href="gameinsert.php"> Oyun Ekle</a>-<a href="gameedit.php"> Oyun D&uuml;zenle</a> -<a href="gamedelete.php">Oyun Sil</a></div> 
      <div style="float:right; padding-top:3px; padding-right:15px;">DATE</div> 
      </div> 
    
      <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    <br /> 
    
    
    
    
            <div class="footer"> 
              
              <div style="float:left; padding-left:5px; padding-top:10px;"><img src="images/footer_logo.png" width="113" height="33" /></div><div style="float:right; padding-top:7px; width:400px;"><span style="font-size:13px;">"© 2008 tatlioyun.net |  Her hakki saklidir.</span><br /> 
              <span class="oyun_yazi"><a href="#">Hakkimizda</a> | <a href="#">Kullanim sartlari</a> | <a href="#">Gizlilik sözlesmesi</a> | <a href="#">Yardim</a> | <a href="#">Iletisim</a> |<a href="#"> Duyurular </a></span></div> 
            </div> 
    </div> 
    
    <div class="icerik_sag" align="center"> 
    <br /> 
      <img src="images/google.png" width="234" height="60" /> 
      <br /><br /> 
      <br /> 
      <br /> 
      <br /> 
      <br /> 
      <img src="images/istatistik.png" width="254" height="29" /><br /> 
      <span class="oyun_yazi">500 Oyun toplamda 32.547 kez oynandi, 
    suanda 56 uye ve 455 misafir kullanici oyunda. 
    Toplam 5569 uyemiz var.</span></div> 
    
    </div> 
    </div> 
    <!--ana tasiyici bit--> 
    <div style="background-image:url(images/ana_alt.png); width:910px; margin-left:15px; height:40px;"></div> 
    </body> 
    </html>
  • 05-12-2008, 20:54:36
    #4
    senin dediğin gibi yaptım sonradan aklıma geldi o olduda db yi uptade etmiyor hata veriyor ne olluyor bu ?

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPTADE oyun_bilgi SET baslik='Tlgy_toklar',aciklama='',tus='sdad',katego' at line 1
  • 05-12-2008, 21:13:59
    #5
    tolgay007 adlı üyeden alıntı: mesajı görüntüle
    senin dediğin gibi yaptım sonradan aklıma geldi o olduda db yi uptade etmiyor hata veriyor ne olluyor bu ?
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPTADE oyun_bilgi SET baslik='Tlgy_toklar',aciklama='',tus='sdad',katego' at line 1
    Kodları at bakalım.
  • 05-12-2008, 22:24:58
    #6
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPTADE oyun_bilgi SET id='18' baslik='Tolgay_Toklar',aciklama='',tus='asas',kate' at line 1
    bu sql sorgusunun hatalı olduğunu gösterio
    altta örnek bir update sorgusu var

    UPDATE oyun_bilgi SET baslik='Tolga', aciklama='asas', tus = 'asas', resmi='bu resim', swf='su swf', kategori='zeka' WHERE id=18
    gibi olması gerekiyor
  • 06-12-2008, 20:30:58
    #7
    Benimkinin ne hatası var ?

    $sorgu=mysql_query("UPDATE oyun_bilgi SET baslik='$baslik',aciklama='$acikalama',tus='$tus' WHERE id='$id'") OR die(mysql_error());
    bende tablolar şöyle sıralanıyor sırasıyla yukarıdan aşağya

    1)id
    2)baslik
    3)aciklama
    4)tus
    5)resim
    6)swf
    7)kategori
    8)oynandi

    Verdiği hata ise bu

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'baslik='Tlgy_toklardfs',aciklama='',tus='sdad' WHERE id='19'' at line 1
    Sırasıyla olması gerekmez demi ?
  • 06-12-2008, 21:00:35
    #8
    $sorgu=mysql_query("UPDATE oyun_bilgi SET baslik='$baslik',aciklama='$acikalama',tus='$tus' WHERE id='$id'") OR die(mysql_error());
    bu sql sorgusu düzgün gözüküyor, doğrusu bir hata göremedim
    ama yine de bir de alttaki gibi deneseniz
    $sorgu=mysql_query("UPDATE oyun_bilgi SET baslik='$baslik', aciklama='$aciklama', tus='$tus' WHERE id=$id") OR die(mysql_error());
  • 06-12-2008, 21:10:35
    #9
    şimdi tamam halletim yazıcaktım baktımki cevap vermişsiniz hatamı farketmişsiniz acikalama yapmışım $aciklama idi değişken adı düzelttim oldu