JS, HTML & CSS

동적 셀렉트박스

관리자 | 2013.01.21 14:23 | 조회 10683

원본.php

<script>
function sub(){
f = document.lform;
var x = f.sel1.value;
$.ajax({
type: "POST",
url: "qry_team.php",
data: "teamidx="+x,
success: function(msg){
$("#sp1").html(msg);
}
});
}
</script>

<select name="sel1" onchange="sub();">
<option value="">소속선택</option>
<?
$qr1 = "select * from ${basictb}_member_team order by orders asc";
$q_rlt = mysql_query($qr1);
while ($qteam = mysql_fetch_array($q_rlt) ) {
?>
<option value="<?=$qteam[index_no]?>"><?=$qteam[tname]?></option>
<?
}
?>
</select>

<span id="sp1">
<select name='t_idx'>
<option value=''>선택하세요</option>
</select>
</span>

---------------------------------------------------------

qry_team.php

<?
$dir = "../..";
include "$dir/inc/connect.php";
include "$dir/inc/config.php";
$teamidx = $_POST[teamidx];
mysql_query("set names utf8;");

?>
<select name='t_idx'>
<option value=''>선택하세요</option>
<?
$q = "Select ${basictb}_member.index_no,name from ${basictb}_member,${basictb}_member_grades where grade_isadmin='Y' and ${basictb}_member.memgrade=${basictb}_member_grades.grade_id and grade_isadmin='Y' and memteam='$teamidx'";
$r = mysql_query($q);
while($row = mysql_fetch_array($r))
{ echo "<option value='$row[index_no]'>$row[name]</option>"; }
?>
</select>

twitter facebook me2day 요즘
22개(2/2페이지)
JS, HTML & CSS
번호 제목 글쓴이 조회 날짜
>> [JQUERY] 동적 셀렉트박스 관리자 10684 2013.01.21 14:23
1 [JAVASCRIPT] 자바스크립트의 모든것 관리자 4628 2013.01.21 14:23
많이 본 글
댓글 많은 글