게시판 검색 결과 ajax로 더보기 채택완료

</p><p>var _tempUrl = decodeURIComponent(window.location.search.substring(1)); //url에서 처음부터 '?'까지 삭제</p><p>        var _tempArray = _tempUrl.split('&'); // '&'을 기준으로 분리하기</p><p>        var _sca = _tempArray[1].split('=');   //sca자르기</p><p>        var _sop = _tempArray[2].split('=');    //sop자르기</p><p>        var _sfl = _tempArray[3].split('=');    //sfl자르기</p><p>        var _stx = _tempArray[4].split('=');    //stx자르기</p><p>     if(document.getElementById('scr_content'+btn) == null){</p><p>        $.ajax({</p><p>            url : "경로",</p><p>            type : "get",</p><p>            dataType : "json",</p><p>            data :{</p><p>                no: btn,</p><p>                board : _board[1],</p><p>                sca : _sca[1],</p><p>                sop : _sop[1],</p><p>                sfl : _sfl[1],</p><p>                stx : _stx[1]</p><p>            },</p><p>

</p><p>include_once('../../../../common.php');</p><p>$link = mysqli_connect("", "", "", "");</p><p>
</p><p>$board = $_GET['board'];</p><p>$sca = $_GET['sca'];</p><p>$sop = $_GET['sop'];</p><p>$sfl = $_GET['sfl'];</p><p>$stx = $_GET['stx'];</p><p>
</p><p>$total_sql = "select count(*) as total from {$g5['write_locationboard_table']} where wr_is_comment = 0";</p><p>
</p><p>$total_row = mysqli_query($link, $total_sql);</p><p>$total_result = mysqli_fetch_array($total_row);</p><p>
</p><p>$first_rows = $_GET['no'];<span style="white-space:pre">	</span>//시작점</p><p>
</p><p>if($_GET['no'] == null){</p><p><span style="white-space:pre">	</span>$first_rows = 0;</p><p>}</p><p>$end_rows = $first_rows + 10;<span style="white-space:pre">	</span>//마지막점</p><p>
</p><p>$rows = $total_result[0];<span style="white-space:pre">	</span>//전체 글 수</p><p>
</p><p>
</p><p>
</p><p>// $get_sort = $_GET['sort'];</p><p>// if($get_sort == "good"){</p><p>// <span style="white-space:pre">	</span>$sort = wr_good;</p><p>// }else if($get_sort == null || $get_sort == "new"){</p><p>// <span style="white-space:pre">	</span>$sort = wr_datetime;</p><p>// }else if($get_sort == "hit"){   //조회 순</p><p>// <span style="white-space:pre">	</span>$sort = wr_hit;</p><p>// }else if($get_sort == "cmt"){   //댓글 순</p><p>// <span style="white-space:pre">	</span>$sort = wr_comment;</p><p>// }else{</p><p>// <span style="white-space:pre">	</span>$sort = wr_datetime;</p><p>// }</p><p>
</p><p>$sql_search = get_sql_search($sca, $sfl, $stx, $sop);</p><p>
</p><p>if($sca || $stx){</p><p><span style="white-space:pre">	</span>$sql = "select distinct wr_parent from {$g5['write_locationboard_table']} where {$sql_search} and wr_is_comment = 0  limit {$first_rows}, {$end_rows}"; //order by {$sort}</p><p><span style="white-space:pre">	</span>$result = sql_query($sql);</p><p>
</p><p><span style="white-space:pre">	</span>for($k=$first_rows; $k<$end_rows; $k++){</p><p><span style="white-space:pre">		</span>$row = sql_fetch_array($result);</p><p><span style="white-space:pre">		</span>$row_sql = "select a.*,b.bo_subject,b.bo_table, CASE WHEN c.wr_id IS NOT NULL THEN c.bf_file ELSE NULL END AS bf_file</p><p><span style="white-space:pre">		</span>FROM {$g5['write_locationboard_table']} a</p><p><span style="white-space:pre">		</span>LEFT JOIN {$g5['board_table']} b ON a.wr_10 = b.bo_table</p><p><span style="white-space:pre">		</span>LEFT JOIN {$g5['board_file_table']} c ON a.wr_id = c.wr_id AND a.wr_file >= 1 AND c.bf_no=0</p><p><span style="white-space:pre">		</span>WHERE a.wr_is_comment = 0 AND a.wr_id = '{$row['wr_parent']}'  limit {$first_rows},{$end_rows}"; //order by {$sort} desc</p><p><span style="white-space:pre">		</span>$result_last = sql_fetch_array($row_sql);</p><p><span style="white-space:pre">	</span>}</p><p>
</p><p><span style="white-space:pre">	</span>echo json_encode($reslut_last);</p><p>}</p><p>// }else{</p><p>// <span style="white-space:pre">	</span>$sql_sort = "select a.*, c.bo_subject, CASE WHEN b.wr_id IS NOT NULL </p><p>// <span style="white-space:pre">	</span>THEN b.bf_file ELSE NULL END as bf_file</p><p>// <span style="white-space:pre">	</span>FROM {$g5['write_locationboard_table']} a </p><p>// <span style="white-space:pre">	</span>LEFT JOIN {$g5['board_file_table']} b </p><p>// <span style="white-space:pre">	</span>ON a.wr_id = b.wr_id AND a.wr_file >= 1 AND b.bf_no=0</p><p>// <span style="white-space:pre">	</span>LEFT JOIN {$g5['board_table']} c</p><p>// <span style="white-space:pre">	</span>ON a.wr_10 = c.bo_table</p><p>// <span style="white-space:pre">	</span>ORDER BY {$sort} DESC LIMIT {$first_rows},{$end_rows}";</p><p>// <span style="white-space:pre">	</span>$result_sort = mysqli_query($link, $sql_sort);</p><p>// <span style="white-space:pre">	</span>for($k=$first_rows; $k < $end_rows; $k++){</p><p>// <span style="white-space:pre">		</span>$result_last[$k] = mysqli_fetch_array($result_sort);</p><p>// <span style="white-space:pre">	</span>}</p><p>// <span style="white-space:pre">	</span>echo json_encode($result_last);<span style="white-space:pre">	</span></p><p>// }</p><p>
</p><p>?></p><div>
</div><p>