3단 검색....
본문
그누보드5에서 3단검색을 만들려고하는데....검색이 안돼요....어디 잘못된건지 알려주시면 감사하겠습니다....
----------------------write.skin.php------------------------------------
<tr>
<th scope="row">선택</th>
<td>지역선택: <select class="ed" name="wr_9" required="required" itemname='지역' value="<?=$write[wr_9]?>">
<?if ($wr_9){echo "<option selected value='$wr_9'>$wr_9</option>";
} else {
echo "<option selected value=''>선택하세요</option>";
}
?>
<option value='서울'>서울</option>
<option value='경기'>경기</option>
<option value='강원'>강원</option>
<option value='충남'>충남</option>
<option value='충북'>충북</option>
<option value='경북'>경북</option>
<option value='경남'>경남</option>
<option value='전북'>전북</option>
<option value='전남'>전남</option>
<option value='제주도'>제주도</option>
<option value='기타'>기타</option>
</select>
분류선택: <select class="ed" name="wr_10" required="required" itemname='분류' value="<?=$write[wr_10]?>">
<?if ($wr_10){echo "<option selected value='$wr_10'>$wr_10</option>";
} else {
echo "<option selected value=''>선택하세요</option>";
}
?>
<option value='바다'>바다</option>
<option value='민물'>민물</option>
<option value='해루질'>해루질</option>
</select>
방법선택: <select class="ed" name="wr_8" required="required" itemname='방법' value="<?=$write[wr_8]?>">
<?if ($wr_8){echo "<option selected value='$wr_8'>$wr_8</option>";
} else {
echo "<option selected value=''>선택하세요</option>";
}
?>
<option value='낚시대'>낚시대</option>
<option value='맨손'>맨손</option>
</select>
</td>
</tr>
--------------------------------list.skin.php-----------------------------------
<!-- 게시판 검색 시작 { -->
<fieldset id="bo_sch">
<legend>게시물 검색</legend>
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="sca" value="<?php echo $sca ?>">
<input type="hidden" name="sop" value="and">
<label for="sfl" class="sound_only">검색대상</label>
<td>지역선택: <select class="ed" name="wr_9" required="required" itemname='지역' value="<?=$list[wr_9]?>">
<?if ($wr_9){echo "<option selected value='$wr_9'>$wr_9</option>";
} else {
echo "<option selected value=''>선택하세요</option>";
}
?>
<option value='서울'>서울</option>
<option value='경기'>경기</option>
<option value='강원'>강원</option>
<option value='충남'>충남</option>
<option value='충북'>충북</option>
<option value='경북'>경북</option>
<option value='경남'>경남</option>
<option value='전북'>전북</option>
<option value='전남'>전남</option>
<option value='제주도'>제주도</option>
<option value='기타'>기타</option>
</select>
분류선택: <select class="ed" name="wr_10" required="required" itemname='분류' value="<?=$list[wr_10]?>">
<?if ($wr_10){echo "<option selected value='$wr_10'>$wr_10</option>";
} else {
echo "<option selected value=''>선택하세요</option>";
}
?>
<option value='바다'>바다</option>
<option value='민물'>민물</option>
<option value='해루질'>해루질</option>
</select>
방법선택: <select class="ed" name="wr_8" required="required" itemname='방법' value="<?=$list[wr_8]?>">
<?if ($wr_8){echo "<option selected value='$wr_8'>$wr_8</option>";
} else {
echo "<option selected value=''>선택하세요</option>";
}
?>
<option value='낚시대'>낚시대</option>
<option value='맨손'>맨손</option>
</select>
<label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label>
<input type="text" name="stx" value="<?php echo stripslashes($stx) ?>" id="stx" class="frm_input " size="15" maxlength="15">
<input type="submit" value="검색" class="btn_submit">
</form>
</fieldset>
<!-- } 게시판 검색 끝 -->
이렇게 만들었는데 검색이 안돼요...ㅜㅜ
답변 4
--------------------------------list.skin.php-----------------------------------
게시물을 "여기에서 찾아라" 라고 하는 sfl 값이 없네요?
원본 검색 소스에서 sfl 값 잘 보세요.
<select name="sfl" id="sfl">
<option value="wr_subject"<?php echo get_selected($sfl, 'wr_subject', true); ?>>제목</option>
<option value="wr_content"<?php echo get_selected($sfl, 'wr_content'); ?>>내용</option>
<option value="wr_subject||wr_content"<?php echo get_selected($sfl, 'wr_subject||wr_content'); ?>>제목+내용</option>
<option value="mb_id,1"<?php echo get_selected($sfl, 'mb_id,1'); ?>>회원아이디</option>
<option value="mb_id,0"<?php echo get_selected($sfl, 'mb_id,0'); ?>>회원아이디(코)</option>
<option value="wr_name,1"<?php echo get_selected($sfl, 'wr_name,1'); ?>>글쓴이</option>
<option value="wr_name,0"<?php echo get_selected($sfl, 'wr_name,0'); ?>>글쓴이(코)</option>
</select>
어디에서 찾으라는 sfl 값이 정해져야 찾습니다..
하지만 작업하신건 여분필드 wr_8.wr_9,_wr_10 3개를 이용하셧으므로
sfl 값을 히든으로 잡아줘야 겠네요.
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="sca" value="<?php echo $sca ?>">
<input type="hidden" name="sop" value="and">
<input type="hidden" name="sfl" value="wr_subject"> <-- 추가 (빨간부분은 입력된 검색어가 제목에서 찾아라 하는 뜻입니다.
<label for="sfl" class="sound_only">검색대상</label>
!-->
<input type="hidden" name="sop" value="and"> 아래에
<input type="hidden" name="sfl" value="wr_8||wr_9||wr_10">
이부분을 추가해서 검색해보세요
두분이 알려주신데로 했는데도 검색이 안되요...ㅜㅜ
<input type="hidden" name="sop" value="and">
혹시 and 조건이라서 3가지 조건이 다 만족하는 경우에 검색이 될겁니다.
<input type="hidden" name="sop" value="or">
3가지 중 하나라도 만족하는 조건이라면 or로 설정해보세요~