|
|
Posted by Realtime on 12/23/05 03:28
Thanks
Also is there a application out there that does scheduled database processing
with mySQL.
Hello NC,
> Realtime wrote:
>
>> How do I go about writing a php application that will alert people in
>> a database
>> from different RSS news feeds from different sites. So lets say we
>> have
>> a database and user A has a list of news alerts he wants to be
>> alerted on.
>> So the application will go to a search engine that will bring up the
>> results
>> in XML. The results are then stored in the database. I just need
>> the logic
>> process. Because I am worried of the latency on the server. So how
>> can
>> i process multiple alerts per user? Or even process multiple users at
>> once.
> If you can schedule your script to run every hour or every day using
> your operating system's scheduling facility, here's what you can do in
> the script itself:
>
> Query the database and obtain a list of all RSS feeds to which users
> are sunscribed
> For each RSS on the list {
> Retrieve the feed
> Parse the feed
> For each item identified {
> Check if it's in the database
> If not, write it into the database and send an alert
> to all users who subscribe to the feed
> }
> }
> You might want to run this script using the command-line interpreter;
> this will save system resources and help you get around the execution
> time limit...
>
> Cheers, NC
>
Navigation:
[Reply to this message]
|