범위검색을 할려고 하는데.....검색이 안되네요...도와주세요..ㅠㅠ
본문
해당 필드 선택하고 숫자 범위 설정하고 검색을 하면....결과가 나오지를 않네요....ㅠ
<!-- 게시판 페이지 정보 및 버튼 시작 { -->
<div class="bo_fx">
<div id="bo_list_total">
<span>Total <?php echo number_format($total_count) ?>건</span>
<?php echo $page ?> 페이지
<form name="fsearch" method="get" style="">
<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||wr_content||wr_1||wr_2||wr_3||wr_4||wr_5||wr_6||wr_7||wr_8||wr_9||wr_10||wr_11||wr_12||wr_13||wr_14||wr_15||wr_16||wr_17||wr_18||wr_19||wr_20||wr_21">
<div style="margin:5px 0;">
<input type="text" id="fr_date" name="fr_date" value="<?php echo $fr_date; ?>" class="frm_input" size="10" maxlength="10" placeholder="시작" > ~
<input type="text" id="to_date" name="to_date" value="<?php echo $to_date; ?>" class="frm_input" size="10" maxlength="10" placeholder="까지" >
<!--
<input type="text" name="stx" value="<?php echo stripslashes($stx) ?>" id="stx" class="frm_input" size="15" maxlength="20" placeholder="필드검색" >
-->
</div>
<div style="margin:5px 0;">
<select name="sfl" id="sfl">
<option value="wr_9||wr_12||wr_13||wr_14||wr_15||wr_16"<?php echo get_selected($sfl, 'wr_9||wr_12||wr_13||wr_14||wr_15||wr_16'); ?>>전체검색</option>
<option value="wr_9"<?php echo get_selected($sfl, 'wr_9'); ?>>평당가격</option>
<option value="wr_12"<?php echo get_selected($sfl, 'wr_12'); ?>>프리미엄</option>
<option value="wr_13"<?php echo get_selected($sfl, 'wr_13'); ?>>매매가격</option>
<option value="wr_14"<?php echo get_selected($sfl, 'wr_14'); ?>>보증금</option>
<option value="wr_15"<?php echo get_selected($sfl, 'wr_15'); ?>>월세</option>
<option value="wr_16"<?php echo get_selected($sfl, 'wr_16'); ?>>임료</option>
</select>
<input type="submit" value="검색" class="btn_submit" style="padding:6px 7px 5px 7px;">
</div>
</form>
</div>
</div>
<!-- } 게시판 페이지 정보 및 버튼 끝 -->
<form name="fboardlist" id="fboardlist" action="./board_list_update.php" onsubmit="return fboardlist_submit(this);" method="post">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="sfl" value="<?php echo $sfl ?>">
<input type="hidden" name="stx" value="<?php echo $stx ?>">
<input type="hidden" name="spt" value="<?php echo $spt ?>">
<input type="hidden" name="sca" value="<?php echo $sca ?>">
<input type="hidden" name="page" value="<?php echo $page ?>">
<input type="hidden" name="sw" value="">
<input type="hidden" name="jogun" value="<?php echo $_GET[jogun]?>">
<input type="hidden" name="fr_date" value="<?php echo $_GET[fr_date]?>">
<input type="hidden" name="to_date" value="<?php echo $_GET[to_date]?>">
<div class="tbl_head01 tbl_wrap">
<table>
<caption><?php echo $board['bo_subject'] ?> 목록 [필드 명칭을 클릭하시면 오름차순,내림차순으로 정렬 됩니다]</caption>
<thead>
<tr>
<?php if ($is_checkbox) { ?>
<th scope="col" style="padding:0 7px;">
<label for="chkall" class="sound_only">현재 페이지 게시물 전체</label>
<input type="checkbox" id="chkall" onclick="if (this.checked) all_checked(true); else all_checked(false);">
</th>
<?php } ?>
<th scope="col" style="padding:0 5px;"><center>No</center></th>
<th scope="col"><?php echo subject_sort_link('wr_datetime', $qstr2, 1) ?><center>Date</center></th>
<th scope="col" style="padding:0 5px;"><?php echo subject_sort_link('wr_subject', $qstr2, 1) ?><center>물건</center></th>
<th scope="col" style="padding:0 5px;"><?php echo subject_sort_link('wr_1', $qstr2, 1) ?><center>임대</center></th>
<th scope="col" style="padding:0 5px;"><?php echo subject_sort_link('wr_2', $qstr2, 1) ?><center>매매</center></th>
<!--
<th scope="col" style="padding:0 10px;"><?php echo subject_sort_link('wr_3', $qstr2, 1) ?><center>위치</center></th>
-->
<th scope="col" style="padding:0 80px;"><?php echo subject_sort_link('wr_4', $qstr2, 1) ?><center>건물명</center></th>
<th scope="col" style="padding:0 5px;"><?php echo subject_sort_link('wr_5', $qstr2, 1) ?><center>해당층</center></th>
<th scope="col" style="padding:0 25px;"><?php echo subject_sort_link('wr_6', $qstr2, 1) ?><center>호수</center></th>
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_7', $qstr2, 1) ?><center>전용면적</center></th>
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_8', $qstr2, 1) ?><center>분양면적</center></th>
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_9', $qstr2, 1) ?><center>평당가격</center></th>
<!--
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_10', $qstr2, 1) ?><center>분양가격</center></th>
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_11', $qstr2, 1) ?><center>총분양가</center></th>
-->
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_12', $qstr2, 1) ?><center>프리미엄</center></th>
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_13', $qstr2, 1) ?><center>매매가격</center></th>
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_14', $qstr2, 1) ?><center>보증금</center></th>
<th scope="col" style="padding:0 20px;"><?php echo subject_sort_link('wr_15', $qstr2, 1) ?><center>월세</center></th>
<th scope="col" style="padding:0 5px;"><?php echo subject_sort_link('wr_16', $qstr2, 1) ?><center>임료</center></th>
<th scope="col" style="padding:0 5px;"><?php echo subject_sort_link('wr_17', $qstr2, 1) ?><center>수익율</center></th>
<th scope="col" style="padding:0 50px;"><?php echo subject_sort_link('wr_18', $qstr2, 1) ?><center>소유자</center></th>
<th scope="col" style="padding:0 1px;"><?php echo subject_sort_link('wr_19', $qstr2, 1) ?><center>연락처</center></th>
<th scope="col"><center>수정</center></th>
</tr>
</thead>
<tbody>
답변 1
sfl 도 2개중 한개는 제거하고
fr_date 과 to_date 에 숫자를 넣어서 검색을 하려면
검색 코어의 변경을 해야만 가능하지 않을까 생각됩니다.
https://sir.kr/request 작업의뢰