Vous avez dit : Factorisation
Je pense qu’il devait être payé a la ligne de code.
OR (
UPPER('".remove_everything_but_letter_plus($agent_firstname)."') LIKE '%.%'
OR UPPER('".remove_everything_but_letter_plus($agent_firstname)."') LIKE '% %'
OR UPPER('".remove_everything_but_letter_plus($agent_firstname)."') LIKE '%-%'
OR UPPER('".remove_everything_but_letter_plus($agent_firstname)."') LIKE '%''%'
OR UPPER('".remove_everything_but_letter_plus($agent_lastname)."') LIKE '%.%'
OR UPPER('".remove_everything_but_letter_plus($agent_lastname)."') LIKE '% %'
OR UPPER('".remove_everything_but_letter_plus($agent_lastname)."') LIKE '%-%'
OR UPPER('".remove_everything_but_letter_plus($agent_lastname)."') LIKE '%''%' )
Code de la function remove_everything_but_letter_plus :
function remove_everything_but_letter_plus($string)
{
$string = preg_replace('/[^A-Za-z \'\.\-]/', '', $string);
$string = sql_escape($string);
return $string;
}