250,14 → 250,13 |
foreach($p['masque.tag']['AND'] as $tag) { |
if(trim($tag) == ',') continue; |
|
$subwhere[] = sprintf('LOWER(CONCAT(%s)) REGEXP %s', |
$subwhere[] = sprintf('CONCAT(%s) LIKE %s', |
DelTk::sqlAddIfNullPourConcat(array('vdi.mots_cles_texte', 'vdi.i_mots_cles_texte')), |
$db->proteger(strtolower($tag))); |
$db->proteger("%" . strtolower($tag) . "%")); |
} |
$req['where'][] = '(' . implode(' AND ', $subwhere) . ')'; |
} |
else { |
$req['where'][] = sprintf('LOWER(CONCAT(%s)) REGEXP %s', |
} else { |
$req['where'][] = sprintf('CONCAT(%s) LIKE %s', |
DelTk::sqlAddIfNullPourConcat(array('vdi.mots_cles_texte', 'vdi.i_mots_cles_texte')), |
$db->proteger(strtolower(implode('|', $p['masque.tag']['OR'])))); |
} |