str_replace refcode click manager

[kidgeek_dfw]

I'm building an email program, that finds and replaces reference codes for urls to be tracked through a click thru manger program.

Basically the program needs a ton of custom reference codes that turn into URLS...

Here's an example:
!link_example turns in to http://www.disney.com

Basically getting the text from a form text field (message)...
Doing something like a str_replace to find and replace all the refernce codes...

There is a MySql table full of custom reference codes and urls...
1000s

How can I search through text quickly comparing the reference codes in the text to the reference codes in the database...

$text = str_replace('!link_disney.com','http://www.disney.com',$text);

I know something link this would work...
But there are 1000s of reference codes...

How can I do this efficiently?

[onion2k]

Go through the email and extract all the link codes into an array, then go off to the database and get the URLs they relate to, putting them into an associative array (array("!link_example"=>"www.domain.com") 😉 then go back to the email and loop through this new array of link codes to convert the link codes into the URLs.

Instead of comparing 1000s of link codes from the database, you'd only compare the number of link codes in the email.

[kidgeek_dfw]

Yeah thats a really good idea thanks...

KidGeek