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'])){ |
