Mercurial > epgrec.yaz
comparison programTable.php @ 113:9b9e22be8407
added zenkaku query hack
author | Yoshiki Yazawa <yaz@honeyplanet.jp> |
---|---|
date | Sat, 13 Mar 2010 18:53:41 +0900 |
parents | 57676bb30f64 |
children | f5d58cf2842f |
comparison
equal
deleted
inserted
replaced
112:b3ba2658a228 | 113:9b9e22be8407 |
---|---|
44 if( isset($_POST['use_regexp']) && ($_POST['use_regexp']) ) { | 44 if( isset($_POST['use_regexp']) && ($_POST['use_regexp']) ) { |
45 $use_regexp = $_POST['use_regexp']; | 45 $use_regexp = $_POST['use_regexp']; |
46 $options .= " AND CONCAT(title,description) REGEXP '".mysql_real_escape_string($search)."'"; | 46 $options .= " AND CONCAT(title,description) REGEXP '".mysql_real_escape_string($search)."'"; |
47 } | 47 } |
48 else { | 48 else { |
49 $search = mb_convert_kana($search, "A", "UTF-8"); | |
49 $options .= " AND CONCAT(title,description) like '%".mysql_real_escape_string($search)."%'"; | 50 $options .= " AND CONCAT(title,description) like '%".mysql_real_escape_string($search)."%'"; |
50 } | 51 } |
51 } | 52 } |
52 } | 53 } |
53 if( isset($_POST['type'])){ | 54 if( isset($_POST['type'])){ |