여분필드 리스트페이지에서 검색 질문 드립니다.
본문
안녕하세요 질문좀 드리겠습니다.
지금 wr_8 셀렉트박스 내용 클릭시 해당 게시물만 나오게끔 되어있는 상태 입니다.
그런데 이거를
wr_1 wr_2 select 총 3개를 선택 후 검색 하게 하고 싶은데
방법좀 알려주시면 감사하겠습니다.
<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_8">
<select name="stx" onchange="this.form.submit()">
<option value="">시도</option>
<option value="EU">EU</option>
<option value="Resseller">Resseller</option>
</select>
</form>
답변 3
<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_8">
<select name="stx" onchange="this.form.submit()">
<option value="">시도</option>
<option value="EU" <?php echo ($_GET['stx'] == 'EU') ? 'selected' : ''; ?>>EU</option>
<option value="Reseller" <?php echo ($_GET['stx'] == 'Reseller') ? 'selected' : ''; ?>>Reseller</option>
</select>
<select name="wr_1" onchange="this.form.submit()">
<option value="">wr_1 선택</option>
<option value="Value1" <?php echo ($_GET['wr_1'] == 'Value1') ? 'selected' : ''; ?>>Value1</option>
<option value="Value2" <?php echo ($_GET['wr_1'] == 'Value2') ? 'selected' : ''; ?>>Value2</option>
</select>
<select name="wr_2" onchange="this.form.submit()">
<option value="">wr_2 선택</option>
<option value="Option1" <?php echo ($_GET['wr_2'] == 'Option1') ? 'selected' : ''; ?>>Option1</option>
<option value="Option2" <?php echo ($_GET['wr_2'] == 'Option2') ? 'selected' : ''; ?>>Option2</option>
</select>
<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_8">
<input type="hidden" name="sfl" value="wr_9">
<select name="stx" onchange="this.form.submit()">
<option value="">시도</option>
<option value="EU" <?php echo ($_GET['wr_8'] == 'EU') ? 'selected' : ''; ?>>EU</option>
<option value="Reseller" <?php echo ($_GET['wr_8'] == 'Reseller') ? 'selected' : ''; ?>>Reseller</option>
</select>
<select name="wr_9" onchange="this.form.submit()">
<option value="">wr_1 선택</option>
<option value="활성화고객" <?php echo ($_GET['wr_9'] == '활성화고객') ? 'selected' : ''; ?>>활성화고객</option>
<option value="유지고객" <?php echo ($_GET['wr_9'] == '유지고객') ? 'selected' : ''; ?>>유지고객</option>
</select>
답변주셔서 감사합니다.
이렇게 적용해봤는데 아무 변화가 없는데 제가 어떤 부분을 놓치고 있는지 궁금합니다.
혹시 검색버튼을 만들고 한번에 클릭 후 검색으로 는 어떻게 해야하는지도 알려주시면 감사하겠습니다.
<!-- 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_8">
<select name="stx">
<option value="">시도</option>
<option value="EU" <?php echo ($_GET['stx'] == 'EU') ? 'selected' : ''; ?>>EU</option>
<option value="Reseller" <?php echo ($_GET['stx'] == 'Reseller') ? 'selected' : ''; ?>>Reseller</option>
</select>
<select name="wr_9">
<option value="">wr_9 선택</option>
<option value="활성화고객" <?php echo ($_GET['wr_9'] == '활성화고객') ? 'selected' : ''; ?>>활성화고객</option>
<option value="유지고객" <?php echo ($_GET['wr_9'] == '유지고객') ? 'selected' : ''; ?>>유지고객</option>
</select>
wr_8은 검색이 잘되는데 9는 검색이 안되는데 이유좀 알수있을까요?
<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_8">
<select name="stx">
<option value="">시도</option>
<option value="EU" <?php echo ($_GET['stx'] == 'EU') ? 'selected' : ''; ?>>EU</option>
<option value="Reseller" <?php echo ($_GET['stx'] == 'Reseller') ? 'selected' : ''; ?>>Reseller</option>
</select>
<select name="wr_9">
<option value="">wr_9 선택</option>
<option value="활성화고객" <?php echo ($_GET['wr_9'] == '활성화고객') ? 'selected' : ''; ?>>활성화고객</option>
<option value="유지고객" <?php echo ($_GET['wr_9'] == '유지고객') ? 'selected' : ''; ?>>유지고객</option>
</select>
<button type="submit" value="검색" class="sch_btn"><i class="fa fa-search" aria-hidden="true"></i><span class="sound_only">검색</span></button>
</form>
연락주세요 도와드릴께요 왜안되는지 오류 체크해봐야 겠네요
＊폼 수정: wr_1, wr_2, wr_8 각각의 값을 선택할 수 있도록 3개의 select 박스를 추가.
＊서버로 전달 방식: get 방식으로 선택된 값들을 전달해야 하며, 각각의 필드 이름, 값을 구분
＊백엔드 처리: 전달된 값들을 기준으로 AND 조건으로 조합하여 검색 쿼리를 작성.
