Convert word to link from MySQL data

vabiro

Hi,

I have been trying to take some info from a MySQL database and use that as target criterion to hyperlink each occurance to another page.

For example if I were to be doing this with country names it would be like this:

The database:

id country_name
1 Afghanistan
2 Albania
3 Algeria

the text:

"I traveled first to Afganistan then move to Albania but I decided to settle in Algeria."

Output:

"I traveled first to <a href="countryinfo.php?id=1">Afganistan</a> then move to <a href="countryinfo.php?id=2">Albania</a> but I decided to settle in <a href="countryinfo.php?id=3">Algeria</a>."

By the way, the text is also saved in the MySQL database.

Any help would be appreciated.

Thanks,
Victor

dopey

Not sure about the performance of this, give it a try:

?php

$q = "  SELECT
            *
        FROM
            country_table";

$res = mysql_query($q) or die(mysql_error());

while( $row = mysql_fetch_row($res) )
{
    list($id,$name) = $row;
    $search[] = "/\\b$name\\b/i";
    $rpl[] = "<A HREF='country.php?id=$id'>$name</A>";
}

$txt = "I traveled first to Afganistan then move to Albania but I decided to settle in Algeria";

$txt = preg_replace( $search, $rpl, $txt );

echo $txt;

?>