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