여분필드 확장 검색을 위한 예제 > 공책

<?php
if($wr_1) {
	$qstr.= "&amp;wr_1=$wr_1";
	$sql_search .= " and wr_1 ='$wr_1' ";
	$extend_search[] = " (INSTR(wr_1, '$wr_1')) ";
}

if($wr_2) {
	$qstr.= "&amp;wr_2=$wr_2";
	$sql_search .= " and wr_2 ='$wr_2' ";
	$extend_search[] = " (INSTR(wr_2, '$wr_2')) ";
}

if($wr_3) {
	$qstr.= "&amp;wr_3=$wr_3";
	$sql_search .= " and wr_3 ='$wr_3' ";
	$extend_search[] = " (INSTR(wr_3, '$wr_3')) ";
}

for($z=0;$z<count($extend_search);$z++) {
	if($z==0) {
		if ($sca || $stx || $stx === '0') {
			$extend .= " and ".$extend_search[$z];
		} else {
			$extend .= " and ".$extend_search[$z];
		}
	} else {
		$extend .= " and ".$extend_search[$z];
	}
}

//검색 카운트
$sql = " SELECT COUNT(DISTINCT `wr_parent`) AS `cnt` FROM {$write_table} WHERE {$sql_search} {$extend} "; 

//검색
if ($is_search_bbs) {
    $sql = " select distinct wr_parent from {$write_table} where {$sql_search} {$extend} {$sql_order} limit {$from_record}, $page_rows ";
} else {
    $sql = " select * from {$write_table} where wr_is_comment = 0  {$extend} ";
    if(!empty($notice_array))
        $sql .= " and wr_id not in (".implode(', ', $notice_array).") ";
    $sql .= " {$sql_order} limit {$from_record}, $page_rows ";
}
?>