[prev in list] [next in list] [prev in thread] [next in thread] 

List:       linux-programlama
Subject:    [Linux-programlama] =?iso-8859-9?q?Cross_Select_Box_Kod_=F6rne?=
From:       erdal.yazicioglu () gmail ! com (Erdal YAZICIOGLU)
Date:       2004-12-29 11:36:22
Message-ID: 009901c4ed89$db9760d0$f200a8c0 () ERDALXP
[Download RAW message or body]

Merhabalar,

belki bazı arkadaşların işine yarabilir düşünce ile iki farklı tablodan iki select \
box seçimi yapmaya yarayan bir kod gönderiyorum. Birinci seçim sonrası ikinci select \
box otomatik olarak değişmekte...Kaynak:http://www.phpaddict.com/forum2/400.html



<?PHP
 $Host = "127.0.0.1";
 $User = "root";
 $Passwd = "";
 $DBName = "caucasia";
 $TableName = "dict_hospitals";

 $Link = mysql_connect($Host, $User, $Passwd) or die("Could not connect: " . \
mysql_error());

 $Query = "SELECT hospitalID,hospitalName ".
    "FROM $TableName";
 $Result = mysql_db_query( $DBName, $Query, $Link );
?>
<HTML>
<HEAD>
 <SCRIPT language="JavaScript">
 <!--
  function BodyLoad() {
   var select = document.FormName.Main_category;
   select.options[0] = new Option("Choose One");
   select.options[0].value = 0;
   <?PHP
    $ctr = 1;
    While( $Row = mysql_fetch_array($Result) ) {
     echo "select.options[$ctr] = new Option(\"$Row[hospitalName]\");\n";
     echo "select.options[$ctr].value = \"$Row[hospitalID]\";\n";
     $ctr++;
    }
   ?>
  }

  function Fill_Sub() {
   var main_select = document.FormName.Main_category;
   var sub_select = document.FormName.Sub_category;
   if( main_select.options[main_select.selectedIndex].value != 0 ) {
    sub_select.length = 0;
   }
   <?PHP
    $Query = "SELECT hospitalID,hospitalName ".
       "FROM $TableName";
    $Result = mysql_db_query( $DBName, $Query, $Link );

    while( $Row = mysql_fetch_array($Result) ) {
   ?>
   if( main_select.options[main_select.selectedIndex].text == "<?PHP echo \
$Row[hospitalName]; ?>" ) {  <?PHP
     $Query2 = "SELECT departmentID,departmentName ".
        "FROM dict_hospdepartments ".
        "WHERE hospitalID = '$Row[hospitalID]'";
     $Result2 = mysql_db_query( $DBName, $Query2, $Link );

     $ctr = 0;
     While( $Row2 = mysql_fetch_array($Result2) ) {
      echo "sub_select.options[$ctr] = new Option(\"$Row2[departmentName]\");\n";
      echo "sub_select.options[$ctr].value = \"$Row2[departmentID]\";\n";
      $ctr++;
     }
    ?>
   }

   <?PHP
    }

    mysql_close($Link);
   ?>
  }
 -->
 </SCRIPT>
</HEAD>
<BODY onload="BodyLoad();">
 <FORM name="FormName" method="POST" action="">
  <TABLE border="1">
   <TR>
    <TD>Main Category</TD>
    <TD>Sub Category</TD>
   </TR>
   <TR>
    <TD>
     <SELECT name="Main_category" onchange="Fill_Sub();"></SELECT>
    </TD>

    <TD>
     <SELECT name="Sub_category" size="4"></SELECT>
    </TD>
   </TR>
  </TABLE>
 </FORM>
</BODY>
</HTML>


Erdal YAZICIOĞLU

-------------- sonraki bölüm --------------
Bir HTML eklentisi temizlendi...
URL: http://liste.linux.org.tr/pipermail/linux-programlama/attachments/20041229/04d0adca/attachment.htm



[prev in list] [next in list] [prev in thread] [next in thread]

Configure | About | News | Add a list | Sponsored by KoreLogic