[nycphp-talk] Dynamically Add Links to Text

Glenn Powell glenn310b at
Thu Aug 27 17:12:56 EDT 2009

If the article copy is stored in the db, and you've got sql to work  
with, then at the
point of publication of a new article, it might be possible to narrow  
the targets

select id from articles where article_text like %valley forge%";
(or something like that).

Then you can do whatever you need to on only those ids.

That might avoid the overhead of selecting the content of all the  
articles for
processing in php.

On Aug 27, 2009, at 4:26 PM, Randal Rust wrote:

> On Thu, Aug 27, 2009 at 4:16 PM, Andrew Muraco<amuraco at>  
> wrote:
>> Personally, i think a spider/bot is the best bet, maintain a list of
>> phrases/words that should point to links and add those in.
> I am leaning towards thinking that is the best option. The other way
> would be to simply provide the editor with a button they can click
> that automatically does the updates and then provides a list of
> articles that they need to review. If all is good, then they can
> approve and publish.
> -- 
> Randal Rust
> R.Squared Communications
> 614-370-0036
> _______________________________________________
> New York PHP User Group Community Talk Mailing List

More information about the talk mailing list