Mercurial > epgrec.yaz
comparison Keyword.class.php @ 135:9c5e597ef6c6
mod: ログ機能を追加
| author | epgrec@park.mda.or.jp <yoneda@recorder.localnet.mda.or.jp> |
|---|---|
| date | Sat, 20 Mar 2010 23:59:01 +0900 |
| parents | 290a05fd7331 |
| children | a18df712fc7e 2cb414518ccd |
comparison
equal
deleted
inserted
replaced
| 134:58791b90221b | 135:9c5e597ef6c6 |
|---|---|
| 42 $f_zenal = preg_match('/[a-zA-Z]/u', $keyword ); | 42 $f_zenal = preg_match('/[a-zA-Z]/u', $keyword ); |
| 43 | 43 |
| 44 $options .= " AND ( CONCAT(title,' ',description) like '%".mysql_real_escape_string($keyword)."%'"; | 44 $options .= " AND ( CONCAT(title,' ',description) like '%".mysql_real_escape_string($keyword)."%'"; |
| 45 | 45 |
| 46 if( $f_zennum ) { | 46 if( $f_zennum ) { |
| 47 $options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVN' ))."%'"; | 47 $options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVN',"UTF-8" ))."%'"; |
| 48 } | 48 } |
| 49 if( $f_zenal ) { | 49 if( $f_zenal ) { |
| 50 $options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVR' ))."%'"; | 50 $options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVR', "UTF-8" ))."%'"; |
| 51 } | 51 } |
| 52 if( $f_zenal && $f_zennum ) { | 52 if( $f_zenal && $f_zennum ) { |
| 53 $options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVRN' ))."%'"; | 53 $options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVRN', "UTF-8" ))."%'"; |
| 54 } | 54 } |
| 55 $options .= ") "; | 55 $options .= ") "; |
| 56 } | 56 } |
| 57 } | 57 } |
| 58 | 58 |