Class
  • Tip&Tech
[ÇÔ¼ö] DB¿¬µ¿ ¹«ÇÑ ´ÙÁß ¼¿·ºÆ®
±Û¾´ÀÌ Knight¢â ³¯ Â¥ 03-01-24 11:45 Á¶ ȸ 20036
°£ÆíURL https://phpschool.com/link/tipntech/15806 º¹»ç

SyntaxHighlight·Î º¸±â

Link1 http://www.toplans.com/test/multiselect.php (842)
¾Æ·¡ °ÅÄ£¸¶·ç´Ô ²²¼­ ¿Ã¸®½Å ´ÙÁß¼¿·ºÆ®¿¡ ºñÇϸé ÇãÁ¢ÀÔ´Ï´Ù.
°ÅÄ£¸¶·ç´Ô²²¼­ ¸»¾¸ÇϽŴë·Î ³»¿ëÀÌ ¸¹Àº ArrayÇüÅÂÀÇ ¹«ÇÑ´ÙÁß¼¿·ºÆ® ÀÔ´Ï´Ù.
¿©±â¼­ Áß¿äÇÑ°ÍÀÌ ¹Ù·Î ¹«ÇÑ -_-; ÇÑÄ­.µÎÄ­..¼¼Ä­..Â¥¸® ¼¿·ºÆ®°¡ ¾Æ´Ñ ...
ºÙÀÌ·Á¸é °è¼Ó 10Ä­ 20Ä­µµ °¡´ÉÇÕ´Ï´Ù. ´Ü, ³»¿ëÀÌ ¸¹Áö ¾ÊÀ»°æ¿ì¸¸¿ä.....

<?
include " DB ¿¬°á Á¤º¸ ";
?>
<script>
<!--
var arrItems1 = new Array();
var arrItemsGrp1 = new Array();


<?php
$result=mysql_query("SELECT * FROM bigcate");
$i=1;
while($rows=mysql_fetch_array($result)){
$cont="$rows[bcate_name]";
printf("arrItems1[$i] = \"$cont\"; \n");
printf("arrItemsGrp1[$i] = $rows[bcate_id]; \n");
$i++;
}
?>

var arrItems2 = new Array();
var arrItemsGrp2 = new Array();

<?php
$result1=mysql_query("SELECT * FROM smallcate");
$i=1;
while($rows1=mysql_fetch_array($result1)){
$cont1="$rows1[scate_name]";
printf("arrItems2[$i] = \"$cont1\"; \n");
printf("arrItemsGrp2[$i] = $rows1[cid]; \n");
$i++;
}
?>

var arrItems3 = new Array();
var arrItemsGrp3 = new Array();

<?php
$result3=mysql_query("SELECT * FROM testcate");
$i=1;
while($rows3=mysql_fetch_array($result3)){
$cont3="$rows3[scate_name]";
printf("arrItems3[$i] = \"$cont3\"; \n");
printf("arrItemsGrp3[$i] = $rows3[cid]; \n");
$i++;
}
?>

function selectChange(control, controlToPopulate, ItemArray, GroupArray)
{
var myEle ;
var x ;
for (var q=controlToPopulate.options.length;q>=0;q--) controlToPopulate.options[q]=null;
if (control.name == "firstChoice") {
for (var q=myChoices.thirdChoice.options.length;q>=0;q--) myChoices.thirdChoice.options[q] = null;
}
myEle = document.createElement("option") ;
myEle.value = 0 ;
myEle.text = "[Ç׸ñÀ» ¼±Åà Çϼ¼¿ä]" ;
controlToPopulate.add(myEle) ;
for ( x = 0 ; x < ItemArray.length ; x++ )
{
if ( GroupArray[x] == control.value )
{
myEle = document.createElement("option") ;
myEle.value = x ;
myEle.text = ItemArray[x] ;
controlToPopulate.add(myEle) ;
}
}
}
//-->
</script>

<form name='form' method='post' action='pds_upost.php' enctype='multipart/form-data'>
<SELECT id=aid name=acate onchange="selectChange(this, form.bid, arrItems1, arrItemsGrp1);">
<option value=0 SELECTED>[Ç׸ñÀ» ¼±ÅÃÇϼ¼¿ä]</option>
<option value=1 SELECTED>[ÀÚ·á½Ç1]</option>
<option value=2 SELECTED>[ÀÚ·á½Ç2]</option>
</select>

</SELECT>
<SELECT id=bid name=bcate onchange="selectChange(this, form.sid, arrItems2, arrItemsGrp2);"></SELECT>

<SELECT id=sid name=scate onchange="selectChange(this, form.cid, arrItems3, arrItemsGrp3);"></SELECT>

<SELECT id=cid name=ccate></SELECT>
</form>

Àüü´ñ±Û¼ö 9

  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Jun 03-01-24 12:30

    | »èÁ¦¼Ò½ºº¸±â

  • ÁöÀûÇß´ø ´ë·Î ÇÑ Çʵ尡 ÃʱâÈ­ µÇ¸é ÇÏÀ§ Çʵ带 ¸ðµÎ ÃʱâÈ­ Çؾ߰ڳ׿ä. ÈǸ¢ÇÕ´Ï´Ù. ^^
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§nux 03-01-24 14:56

    | »èÁ¦¼Ò½ºº¸±â

  • ÀÌ·±¹æ¹ýÀÌ ÀÖ¾ú³×¿ä..
    À̰ɸô¶ó¼­ ÀÏÀÏÀÌ »Ñ·È½À´Ï´Ù. ÀÌ·¸°Ô
    form.code.length = \£§2\£§;
    form.code.options[0].text = \£§ºÐ·ù¸¦ ¼±ÅÃÇϼ¼¿ä\£§;
    form.code.options[0].value = \£§\£§;
    form.code.options[1].text = \£§OF21655\£§;
    form.code.options[1].value = \£§´ÏÆ®\£§;
    form.code.options[0].selected = true;

    ÀÌ·± ¹æ¹æÀ¸·Î ¿É¼ÇÀ» ÇϳªÇϳª »ý¼ºÇؼ­ Çß´Ù´Â »ç½Ç À̰͵µ ÁÁ¾ÒÁö¸¸
    2´Ü 3´ÜÀ¸·Î °¥¼ö·Ï ¹«Áö º¹ÀâÇØÁö´õ±º¿ä ¾Õ¿¡¼­ ¾î¶²°Ô ¼±Åà µÇ¾ú´ÂÁö ¾Ë±âÀ§Çؼ­...
    ÁÁÀº ¹æ¹ýÀÔ´Ï´Ù. Àß¾²°Ú½À´Ï´Ù.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹ÚÇö¼ö 03-01-24 15:30

    | »èÁ¦¼Ò½ºº¸±â

  • ¿À~
    ÁÁ±º¿ä..
    ³Ê¹« ÁÁÀº ÆÁµéÀÌ ¸¹ÀÌ ¿Ã¶ó¿Í ¸Ó¸®¸¦ ±¼¸®Áö ¾Ê±¸, ÀÌ°÷¸¸ µÚÁö°í ÀÖÀ¸´Ï..¤Ñ.¤Ñ;;
    ÆÁ¾Ø ÅÂÅ©¿¡ Áßµ¶µÇ¾ú´ç.. Ã¥ÀÓÁ®~~
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¿ÕÃʺ¸ 03-01-28 23:52

    | »èÁ¦¼Ò½ºº¸±â

  • firstChoice¶æÀÌ ¸Ó¾Ö¿©?
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÇÑ»ç¶û 03-01-29 09:54

    | »èÁ¦¼Ò½ºº¸±â

  • ³×. ±¦ÂúÀº ¹æ¹ýÀ̳׿ä.. ¿ø¸®´Â ´ë°­ ¾Ë°í ÀÖ¾ú´Âµ¥.. Àü ¿©ÀüÈ÷ submit¹æ¹ýÀ» ¾²°í ÀÖ½À´Ï´ç..¤Ñ.¤Ñ
    ±×·±µ¥.. ¿©±â¼± ±×·ì ¹è¿­À» µû·Î Àâ¾Ò³×¿ä.. ¿¹Àü¿¡ Á¦°¡ ¸¸µé¾úÀ»¶§´Â 2Â÷¿ø¹è¿­·Î ÇØ°áÇß¾ú´Âµ­.. À̹æ¹ýÀÌ Á» ´õ ³ºÀº°Å °°±º¿ä.. Àߺ¸°í °©´Ï´Ù.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§redua 03-07-14 09:12

    | »èÁ¦¼Ò½ºº¸±â

  • µðºñ ±¸Á¶Á» ¿Ã·ÁÁÖ¼¼¿© ºÎŹµå¸³´Ï´Ù. ¤Ð.¤Ð.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§À½³Ä¸® 03-07-16 03:25

    | »èÁ¦¼Ò½ºº¸±â

  • ¸ð¡. ¤Ñ¤Ñ;;;
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Áö³ª°¡´Ù 03-10-09 17:48

    | »èÁ¦¼Ò½ºº¸±â

  • ÀÚ½ºÄÚ¿¡ ÀÖ´Â ¼Ò½º ±×´ë·Î´Ù...
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Àǹ«´ëÀå 07-11-08 19:07

    ¼Ò½ºº¸±â

  • ¼Ò½º Àß¾µ°Ô¿ä ^^;
  • °Ô½Ã¹° 15°Ç RSS
¹øÈ£ºÐ·ùÁ¦¸ñ±Û¾´À̳¯Â¥Á¶È¸
15 ½ºÅ©¸³Æ® [PHP µ¿¿µ»ó°­ÁÂ] 51. db¿Í ¿¬µ¿µÈ ´ÙÁß ¼¿·ºÆ® Á¦ÀÛÇϱâ [15] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼­±â¢á 07-08-08 15502
14 ½ºÅ©¸³Æ® ´Ù´Ü¼¿·ºÆ®, 2´Ü¼¿·ºÆ®, ½Ç½Ã°£º¯µ¿¼¿·ºÆ®, ¼¿·ºÆ®¹öÆ°, ÁÖ¼Ò¼¿¡¦ [7] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§enmu 06-12-02 13387
13 ½ºÅ©¸³Æ® ÀÚ¹Ù½ºÅ©¸³Æ®·Î Å×À̺íÀÇ Çà À§¾Æ·¡ ¼ø¼­À̵¿(?) [4] ÷ºÎÆÄÀÏ Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§·¯ºê¸® 06-06-09 11455
12 ÇÔ¼ö [HTC] ¼¿·ºÆ® ¹Ú½º -> ·¹À̾î ÀÚµ¿ º¯È¯ ½ºÅ©¸³Æ® [38] ¸µÅ© Àαâ TarauS 05-02-16 20434
11 ÇÔ¼ö MSN ¹Ì´ÏȨÇÇ °Ô½ÃÆÇ °ü¸®±â´ÉÀ» µû¶óÇغýÀ´Ï´Ù [10] ¸µÅ© Àαâ À±Á¶Èñ 04-07-03 6643
10 ÇÔ¼ö ´ÙÁß¼¿·ºÆ®°£ Ç׸ñ´ÙÁßÀ̵¿ ¹× ¼ø¼­¼³Á¤ [12] ¸µÅ© Àαâ navyism 04-04-28 7884
9 ¾Ë°í¸®Áò ´ÙÁß¼¿·ºÆ®¹Ú½º°£ °ªÀ̵¿ ¹× °á°úó¸® [2] ¸µÅ© Àαâ navyism 04-03-26 10013
8 ½ºÅ©¸³Æ® °£´ÜÇÑ ´ÙÁß¼¿·ºÆ®(µ¿Àû¼¿·ºÆ®) ±¸Çö [11] Àαâ LinuxZZang 04-03-23 13382
7 ÇÔ¼ö ´ÙÁß¿¬µ¿¼¿·ºÆ®(3´Ü) Æû¼Ò½º (Ãâó : ¾ßÈÄ) [4] Àα⠼öÇýÀÚ 03-04-24 12764
6 ½ºÅ©¸³Æ® ÁÖ¼Ò°Ë»ö ÀÌÁ¦ »õâ ¶ç¿ìÁö ¾Ê¾Æµµ µÈ´Ù [17] ¸µÅ© Àαâ Knight¢â 03-03-05 9501
5 ÇÔ¼ö DB¿¬µ¿ ¹«ÇÑ ´ÙÁß ¼¿·ºÆ® [9] ¸µÅ© Àαâ Knight¢â 03-01-24 20035
4 ¾Ë°í¸®Áò [¼Ò½º]´ÙÁß¼¿·ºÆ® - ¾î¶² ȯ°æ¿¡¼­µµ µ¶¸³ÀûÀÌ´Ù. [1] ÀÎ±â ¹Ú»ó±¹ 02-02-27 6899
3 ¾Ë°í¸®Áò [¼Ò½º]ÇãÁ¢ÇÏÁö¸¸ µµ¿òÀÌ µÇ¾úÀ¸¸é ^^ ´ÙÁß¼¿·ºÆ® ~ [4] Àα⠿ÀÁ¸½º~ 01-11-16 8213
2 ¾Ë°í¸®Áò    ´ñ±Û[ÀÀ´ä][¼Ò½º]ÇãÁ¢ÇÏÁö¸¸ µµ¿òÀÌ µÇ¾úÀ¸¸é ^^ ´ÙÁß¼¿·ºÆ® ~ Àαâ bigdoo 01-11-17 3717
1 ¾Ë°í¸®Áò    ´ñ±Û[ÀÀ´ä][¼Ò½º]ÇãÁ¢ÇÏÁö¸¸ µµ¿òÀÌ µÇ¾úÀ¸¸é ^^ ´ÙÁß¼¿·ºÆ® ~ Àαâ À¯¼ö¿µ 01-11-27 3317