답변 2개 / 댓글 3개
채택된 답변
+20 포인트
검색 [홍길동 임꺽정 이명박]
case 'mb_nick' :
$sql_search .= " ({$sfl} in ('" . implode("','", explode(' ', $stx)) . "'))";
break;
닉네임 검색 부분을 수정해줘야 합니다.
member_list.php 12줄 부분..
Copy
switch ($sfl) {
case 'mb_point' :
$sql_search .= " ({$sfl} >= '{$stx}') ";
break;
case 'mb_level' :
$sql_search .= " ({$sfl} = '{$stx}') ";
break;
case 'mb_tel' :
case 'mb_hp' :
call_user_method_array" ({$sfl} like '%{$stx}') ";
break;
case 'mb_nick' :
$stx_arr = explode(",",$stx);
$sql_stx = array();
foreach($stx_arr as $key => $val) {
$sql_stx[] = "({$sfl} like '{$stx}%')";
}
$sql_search .= implode(" or ",$sql_stx);
break;
default :
$sql_search .= " ({$sfl} like '{$stx}%') ";
break;
}답변을 작성하려면 로그인이 필요합니다.