Did you say: factorisation?

Code gems · April 24, 2015

I think he must have been paid by the line of 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 of the 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;
}