comparison Keyword.class.php @ 152:784e3c82926e

mod: yazucchi??????????

149:5b192e94f49d

		if( $keyword != "" ) {
			if( $use_regexp ) {
				$options .= " AND CONCAT(title,description) REGEXP '".mysql_real_escape_string($keyword)."'";
			}
			else {
				// 全角半角
				// 場当たり的に対応
				$f_zennum = preg_match('/[0-9]/u', $keyword );
				$f_zenal  = preg_match('/[a-zA-Z]/u', $keyword );
				
				$options .= " AND ( CONCAT(title,' ',description) like '%".mysql_real_escape_string($keyword)."%'";
				
				if( $f_zennum ) {
					$options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVN',"UTF-8" ))."%'";
				}
				if( $f_zenal ) {
					$options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVR', "UTF-8" ))."%'";
				}
				if( $f_zenal && $f_zennum ) {
					$options .= " OR CONCAT(title,' ',description) like '%".mysql_real_escape_string(mb_convert_kana( $keyword, 'KVRN', "UTF-8" ))."%'";
				}
				$options .= ") ";
			}
		}
		
		if( $type != "*" ) {
			$options .= " AND type = '".$type."'";

152:784e3c82926e

		if( $keyword != "" ) {
			if( $use_regexp ) {
				$options .= " AND CONCAT(title,description) REGEXP '".mysql_real_escape_string($keyword)."'";
			}
			else {
				$options .= " AND CONCAT(title,description) like _utf8'%".mysql_real_escape_string($keyword)."%' collate utf8_unicode_ci";
			}
		}
		
		if( $type != "*" ) {
			$options .= " AND type = '".$type."'";