Web/PHP

DB연동 무한 다중 셀렉트

aucd29 2013. 9. 26. 21:40
<?
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>