날짜 검색 질문드립니다.

bbs/list.php 에 추가


if($s_Date && $e_Date) {
$sql_datet .= " and left(wr_datetime, 10) between '{$s_Date}' and '{$e_Date}' ";
}

 

 

 

list.skin.php에 추가

<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script src="//code.jquery.com/ui/1.8.18/jquery-ui.min.js"></script>
<script>
  $.datepicker.setDefaults({
    dateFormat: 'yy-mm',
    prevText: '이전 달',
    nextText: '다음 달',
    monthNames: ['1월', '2월', '3월', '4월', '5월', '6월', '7월', '8월', '9월', '10월', '11월', '12월'],
    monthNamesShort: ['1월', '2월', '3월', '4월', '5월', '6월', '7월', '8월', '9월', '10월', '11월', '12월'],
    dayNames: ['일', '월', '화', '수', '목', '금', '토'],
    dayNamesShort: ['일', '월', '화', '수', '목', '금', '토'],
    dayNamesMin: ['일', '월', '화', '수', '목', '금', '토'],
    showMonthAfterYear: true,
    yearSuffix: '년'
  });

     $(function() {
        $("#s_Date, #e_Date").datepicker({
            dateFormat: 'yy-mm-dd'
        });
    });


</script>
 
      <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_datetime"<?php echo get_selected($sfl, 'wr_datetime'); ?>>
            <input type="text" name="s_Date" id="s_Date" autocomplete="off">~<input type="text" name="e_Date" id="e_Date" autocomplete="off"> 
            <button type="submit" value="검색" class="sch_btn"><i class="fa fa-search" aria-hidden="true"></i><span class="sound_only">검색</span></button>
            </form>