Creating keywords hyperlinks in a text

Anon

Hello,

I'm beginning a new projet which is basically a e-magazine. each issue will have up to 10 articles (or subjects). This magazine will be administrated through a browser with a php module and store in a mysql database.

Each article contains some keywords and I want to automatically create hyperlink for each of them as soon as the creation or modification form will be submitted.
The link will open a new window with the word definition.

All keywords and related definitions will be in a separate mysql table.

have you some suggestions and eventually some exemples ?

I've searched through the archives but I didn't find anything similar.

regards

Jean Pierre

Anon

I wrote a script for finding tag-delimited keywords in a string a few days ago,
this might be usefill for you to find the keywords in your app.

<?
$line = "hello, this is a <? id=2 ?> string that needs some <? id=4 ?> work";

while we can find "<?" markers

while ($last_pos=strpos($line,"<?"))
{

print what is in front of marker

print substr($line,0,$last_pos)."\n";

Trash what is in front of the marker

$line = substr($line,$last_pos);

Find the end marker

$last_pos = strpos($line,"?>")+2;

Get what is between the markers, +3 and -6 to get rid of the markser themselves plus the spaces around the markers

$replace_me = substr($line,3,$last_pos-6);

get the key and value

$pieces=explode("=",$replace_me);
print "img src=image.php?$pieces[1]\n";

trash the part between and including the markers.

$line = substr($line,$last_pos);
$last_pos = strpos($line,"<?",0);
};

Don't forget to print the last bit, the part that is left when no more markers exist!

print $line;
print "\n";
?>

Anon

here's what i'd suggest.

$keys=mysql_query("select keywords from magazine where article=".$thisarticle);
$key=mysql_fetch_array($keys);

while (list($junk, $keyword)=each($key) ) {
preg_replace("/(".$keyword.")/i","<a #whatever link stuff#>\1</a>", $articletext);
}

echo $articletext;

--
rad

Anon

Now that is some clean cool code.

thanks!

Anon

one thing i forgot to mention before being condemned to two and a half hours of planning meeting hell:

be careful if these keywords turn up inside tags, because the highlighting can break them.

this might not be a problem, but if it is it might be an idea to specify word boundaries or whitespace in the pattern. if that doesn't work you could strip the tags into an array, run the highlighter, and then put them back. or, as a last resort, split the text into lots of substrings, highlight the ones that're not tags, and then glue them all back together.

--
rad

Anon

Thank you very much for yr help.

I tried to make yr script running correctly but I didn't succeed.

I've some difficulties to figure out how the data are organized.

The table 'magazine' contains the article text.
But where do you store the keywords ?
In a field of the table magazine or in a separate table ?

What is the variable $junk ?

Regards

Jean Pierre

Anon

But where do you store the keywords ?
In a field of the table magazine or in a separate table ?

wherever you like. it's your database :-) that bit of the script was mainly there to demonstrate what the variables i would later use were; i didn't give it to much thought.

What is the variable $junk ?

just that: junk. you need to put it in or list won't work properly, but you never actually use it.