어제 질문드렸는데..
급해서 다시 질문합니다. 죄송..
셀렉트박스에서
대분류 - 중분류 - 소분류를 선택하면 submit이 돼 버리요.
셀렉트박스를 선택할때마다 쿼리를날려 결과값이 출력되다보니 시간이 걸리는
문제점이 발생합니다.
셀렉트 박스에서 조건 선택후 submit 버튼을 클릭할때만
결과가 출력되게 하려면 어떻게 하나요?
소스는 다음과 같습니다.
<script language="javascript">
<!--
function detailOpen(uid) {
newWin("/adm/member/detail_info.php?uid="+uid,"MemberInfo","50","50","center","center","auto");
}
function lectureList(uid) {
newWin("/adm/member/lecture_list.php?uid="+uid,"MemberInfo","50","50","center","center","auto");
}
function cate1Select() {
document.searchForm.cate2.options[0].selected = true;
document.searchForm.cate3.options[0].selected = true;
document.searchForm.submit();
}
function cate2Select() {
document.searchForm.cate3.options[0].selected = true;
document.searchForm.submit();
}
function cate3Select() {
document.searchForm.submit();
}
//-->
</script>
<table border="0" cellpadding="5" cellspacing="1" width="100%" bgcolor="#CCCCCC">
<form name="searchForm" method="post">
<input type="hidden" name="excel" value="">
<tr>
<td bgcolor="#FAFAFA">
<select name="cate1" onChange="cate1Select();">
<option value="">대분류</option>
<?
$sql = "SELECT cate1, cate1_name FROM ($cate_table) category GROUP BY cate1 ORDER BY cate1 ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
if($row[0] == $cate1)
echo "<option value='$row[0]' selected>$row[1]</option>";
else
echo "<option value='$row[0]'>$row[1]</option>";
}
?>
</select>
<select name="cate2" onChange="cate2Select();">
<option value="">중분류</option>
<?
$sql = "SELECT cate2, cate2_name FROM ($cate_table) category WHERE cate1 = $cate1 GROUP BY cate2 ORDER BY cate2 ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
if($row[0] == $cate2)
echo "<option value='$row[0]' selected>$row[1]</option>";
else
echo "<option value='$row[0]'>$row[1]</option>";
}
?>
</select>
<select name="cate3" onChange="cate3Select();">
<option value="">소분류</option>
<?
$sql = "SELECT cate3, cate3_name FROM ($cate_table) category WHERE cate1 = '$cate1' AND cate2='$cate2' GROUP BY cate3 ORDER BY cate3 ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
if($row[0] == $cate3)
echo "<option value='$row[0]' selected>$row[1]</option>";
else
echo "<option value='$row[0]'>$row[1]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td bgcolor="#FAFAFA">
<select name="yy" style="width:50;">
<option value="" selected>년</option>
<?
for($i=$yy_start;$i<=$yy_last;$i++) {
if($i == $yy)
echo " <option value='$i' selected>{$i}</option>";
else
echo " <option value='$i'>{$i}</option>";
}
?>
</select>
<select name="mm" style="width:50;">
<option value="" selected>월</option>
<?
for($i=1;$i<=12;$i++) {
$i = sprintf("%02d",$i);
if($i == $mm)
echo " <option value='$i' selected>{$i}</option>";
else
echo " <option value='$i'>{$i}</option>";
}
?>
</select>
<select name="dd" style="width:50;">
<option value="">일</option>
<?
for($i = 1; $i <= 31; $i++) {
$i = sprintf("%02d",$i);
if($i == $dd)
echo "<option value='$i' selected>$i</option>";
else
echo "<option value='$i'>$i</option>";
}
?>
</select>
<select name="job">
<option value="">직업</option>
<?
foreach($jobs as $item => $val) {
if($item == $job)
echo "<option value='$item' selected>$val</option>";
else
echo "<option value='$item'>$val</option>";
}
?>
</select>
<select name="area">
<option value="">지역</option>
<?
$sql = "SELECT area FROM members GROUP BY area ORDER BY area DESC";
$result = mysql_query($sql);
$n = 0;
while($row = mysql_fetch_array($result)) {
if(!$row['area']) $row['area'] = "기타";
$arr_area[$row['area']] = $row['area'];
$n++;
}
foreach($arr_area as $item => $value) {
if("$item" == "$area")
echo "<option value='$item' selected>$value</option>";
else
echo "<option value='$item'>$value</option>";
}
?>
</select>
<select name="age">
<option value="">연령</option>
<?
foreach($age_list as $item => $val) {
if("$item" == "$age")
echo "<option value='$item' selected>$val</option>\n";
else
echo "<option value='$item'>$val</option>\n";
}
?>
</select>
</td>
</tr>
<tr>
<td bgcolor="#FAFAFA">
<select name="key">
<option value="m_id" <?=$key_sel['m_id']?>>아이디</option>
<option value="m_name" <?=$key_sel['m_name']?>>이름</option>
</select>
<input type="text" name="keyword" size="15" value="<?=$keyword?>">
<input type="submit" value=" 검색 " class="htc">
<input type="button" value=" 전체 " onclick="javascript:location.href('<?=$PHP_SELF?>?pm=<?=$pm?>')" class="htc">
<input type="button" value="엑셀저장" class="htc" onclick="window.location.href('excel_list_cate.php?yy=<?=$yy?>&cate1=<?=$cate1?>&cate2=<?=$cate2?>&cate3=<?=$cate3?>&yy=<?=$yy?>&mm=<?=$mm?>&dd=<?=$dd?>&job=<?=$job?>&area=<?=$area?>&age=<?=$age?>&key=<?=$key?>&keyword=<?=$keyword?>');">
</td>
</tr>
</form>
|
