I have a database table full of words. What I would like to do is to have a way to show the user in the html in the form of a hyperlink, any of these keywords. Kind of like you see on many forums now a days. When a keyword is noted in the html, it becomes clickable. Is there a way to do this? I'm using php.
Thanks
You create a table of link URLs with an ID field and a field that stores the ID of a row in your keyword table. You select the linked url with something like:
select keywords.name, links.url
from keywords, links
where keywords.id = links.keywords_id
and keyword.name = 'keyword_in_the_html'
The most obvious way I can think of doing this is looping through every keyword from your database, and running a preg_replace on your HTML for each (just replace each word with an appropriate hyperlink).
Your regular expression is likely to be complex, because you will need to make sure that none of the word replacements interfere with your HTML, and you will also want to make sure you only replace whole words and not partial words.
Lastly, if your word database is very large, this will be expensive to do on every request. So consider performing it once and storing the result.
Alternatively, offload the processing to the client and do the replacement with JavaScript. Modifying HTML tags may not be a problem then, because you should be able to run the replace on only the text nodes of the DOM. But again, if your database is large, you will have to send a long list of words to the client for the JavaScript to loop through.