Php hakkında yardım mysql

17-11-2017, 09:52:40

Wixir

We ❤️ Youtube

Merhabalar,

Tab menüde birden fazla farklı mysql tablosuna bağlantı yapıp verı cekmek istiyorum ancak bir türlü olmuyor.

Tab 1 menüde şu şekilde veriyi çekebiliyorum.

<section id="content1"> <div class="sol" style="width:945px"> <img src="paperdoll.php?id=$id"> <div class="sol"> <font color = white> <span class="temizle sol b_1" style="width:140px">Guild</span> <span class="sol b_2" style="width:150px">: $char_guild</span>

Ancak tab 2 menüye geldiğimde farklı bir tablodan veri cekmem gerekli olduğu için mysql select olayını gerçekleştiremedim bir türlü.
Veritabanları aynı ancak farklı bir tablodan veri cekmem lazım.

<section id="content2"> bölümüne farklı bir tablodan veriyi nasıl alabilirim?

Kodun tamamı

<?php
require("myrunuo.inc.php");
function skillimage($skillid, $skill)
{
  if ($skill / 10 >= 100)
    $temp = "g";
  else
    $temp = "";
  $skillimage = "images/skills/{$skillid}{$temp}.gif";
  return $skillimage;
}
function skillname($skillid, $skill)
{
  global $skillnames;
  if ($skill / 10 >= 100)
    $temp = "Grandmaster:<br>";
  else
    $temp = "";
  $skillname = $temp . $skillnames[$skillid];
  return $skillname;
}
check_get($id, "id");
$id = intval($id);
echo <<<EOF

EOF;
$link = sql_connect();
if ($id) {
  $result = sql_query($link, "SELECT char_name,char_karma,char_fame,char_bolge,char_oldurdugu,char_oldugu,char_guild,char_guildtitle,char_pvpkazanma,char_dkazanma,char_dkaybetme,char_kumbara,char_sure,char_puan,char_gold,char_kredi,char_uyeliktarihi,char_songiris,char_str,char_dex,char_int FROM myrunuo_characters WHERE char_id=$id");
  if (!(list($char_name,$char_karma,$char_fame,$char_bolge,$char_oldurdugu,$char_oldugu,$char_guild,$char_guildtitle,$char_pvpkazanma,$char_dkazanma,$char_dkaybetme,$char_kumbara,$char_sure,$char_puan,$char_gold,$char_kredi,$char_uyeliktarihi,$char_songiris,$char_str,$char_dex,$char_int) = mysql_fetch_row($result))) {
    echo "Belirtilen Isimde bir oyuncu bulunamadi\n";
    die();
  }
  mysql_free_result($result);
  echo <<<EOF
      
    </td>
    
<table border="0" cellpadding="0" cellspacing="0" style="width:100%; float:left;">
  <tr>
    <td colspan="3" align="left" valign="top" style="width:100% !important">
    </td>
    
    
<style>
.sol { float:left; }
.sag { float:right; }
.temizle { clear:both; }
.b_b3         { background: #361617; font-size:14px; }
.back_1_acc   { background:#442526; }
.back_1_acc a { color:#242120;font-weight:bold; font-size:11px;  }
.back_2_acc   { background:#7f5152; }
.back_2_acc a { color:#242120; font-weight:bold; font-size:11px; }
.phpbb td a   { font-weight:100; display:block; font-size:12px; float:left; width:100%; }
#tab1 { width:785px; border:0px solid #050506; border-top:0px; padding:10px; color:#fff}
#tab2 { width:785px; border:1px solid #050506; border-top:0px; padding:10px; background:#050506;color:#fff }

.fontkalin { font-weight:Bold; }
.b_1    { width:170px; line-height:200%; }
.b_2    { width:250px; line-height:200%;}
.b_2 a{ font-weight:500; color:#ff0000}
.genelwidth {width:100%;}
.center { text-align:center; }
.font11 { font-size:11px; }
.tahoma { font-family:tahoma; }
</style>
  <section id="content1">

   
      
<div class="sol" style="width:945px">
<img src="paperdoll.php?id=$id">
    <div class="sol">
<font color = white>
        <span class="temizle sol b_1" style="width:140px">Guild</span>
    <span class="sol b_2" style="width:150px">: $char_guild</span>    
        <span class="temizle sol b_1" style="width:140px">Karma</span>
        <span class="sol b_2" style="width:150px">: $char_karma</span>
        <span class="temizle sol b_1" style="width:140px">Fame</span>
        <span class="sol b_2" style="width:150px">: $char_fame</span>
        
        <span class="temizle sol b_1" style="width:140px">STR</span>
        <span class="sol b_2" style="width:150px">: $char_str</span>
        <span class="temizle sol b_1" style="width:140px">DEX</span>
        <span class="sol b_2" style="width:150px">: $char_dex</span>
<span class="temizle sol b_1" style="width:140px">INT</span>
        <span class="sol b_2" style="width:150px">: $char_int </span>
<span class="temizle sol b_1" style="width:140px">Bölge</span>
        <span class="sol b_2" style="width:150px">: $char_bolge</span>
        <span class="temizle sol b_1" style="width:140px">Öldürme Sayısı</span>
        <span class="sol b_2" style="width:150px">: $char_oldurdugu</span>
        <span class="temizle sol b_1" style="width:140px">Ölme Sayısı</span>
        <span class="sol b_2" style="width:150px">: $char_oldugu</span>
        <span class="temizle sol b_1" style="width:140px">Toplam Para</span>
        <span class="sol b_2" style="width:150px">: $char_gold gp</span>
        <span class="temizle sol b_1" style="width:140px">Online Süre</span>
        <span class="sol b_2" style="width:150px">: $char_sure Saat</span>
        
<span class="temizle sol b_1" style="width:140px">Kredi Puanı</span>
        <span class="sol b_2" style="width:150px">: $char_kredi</span>
<span class="temizle sol b_1" style="width:140px">Kazandığı Düello</span>
        <span class="sol b_2" style="width:150px">: $char_dkazanma</span>
<span class="temizle sol b_1" style="width:140px">Kaybettiği Düello</span>
        <span class="sol b_2" style="width:150px">: $char_dkaybetme</span>
</font>    
</p>
    
  </section>
  

  <section id="content2">
    <p>            
 
</p>
  </section>
    
  <section id="content3">
    <p>
    varan 3</p>
    
  </section>
    
  <section id="content4">
    <p>
   varan 4
</p>
    
  </section>
    
</main>
EOF;
  $result = sql_query($link, "SELECT skill_id,skill_value FROM myrunuo_characters_skills WHERE char_id=$id ORDER BY skill_value DESC LIMIT 3");
  $num = 0;
  while (list($skillid,$skill) = mysql_fetch_row($result)) {
    $skillid = intval($skillid);
    $skill = intval($skill);
    $name = skillname($skillid, $skill);
    // Fix for swapped skill IDs
    if ($skillid == 47)
      $skillid = 48;
    else if ($skillid == 48)
      $skillid = 47;
    $image = skillimage($skillid, $skill);
    echo <<<EOF
    <td align="center" valign="top">
      <a href="http://guide.uo.com/skill_{$skillid}.html"><img src="$image" border="0" width="125" height="80" alt="$name"></a><br>
      <font face="Arial" size="2">$name</font>
    </td>
EOF;
    $num++;
  }
  mysql_free_result($result);
  while ($num < 3) {
    echo "    <td>&nbsp;</td>\n";
    $num++;
  }
  echo "  </tr>\n";
 $result = sql_query($link, "SELECT myrunuo_guilds.guild_id,myrunuo_guilds.guild_name FROM myrunuo_characters INNER JOIN myrunuo_guilds ON myrunuo_characters.char_guild=myrunuo_guilds.guild_id WHERE myrunuo_characters.char_id=$id");
  if (list($gid,$guild) = mysql_fetch_row($result)) {
    $gid = intval($gid);
    echo <<<EOF
  <tr>
    <td align="center" colspan="3">
      <br><font face="Verdana, Arial" color="#000000" size="2"><b>Guild:</b> &nbsp; &nbsp;<a href="guild.php?id=$gid" style="color: Black">$guild</a></font>
    </td>
  </tr>
EOF;
  }
  mysql_free_result($result);
}
mysql_close($link);
echo <<<EOF
</table>
</body>
</html>