Hello.
I'm working on a website and one of the areas will be an aggregator of Twitter rss updates, related to a certaing category.
Website is programmed in
PHP 5.0, with a
MySql database.
In the table where I will insert all twitter accounts I need to aggregate inserting manually Username, RSS feed. In this table I'd need to import fields: Bio, Location, Number of followers, Img avatar.
This first part of script will run automatically once or twice a day (I will set it in the crontask via server) and it will update imported fields: Bio, Location, Number of followers, Img avatar.
In a table with all updates I need to import: Status, Status Url, Publishing date. Of course, each status will be related to an account (previous table).
This first part of script will run automatically every 10 mins (if possible) and it will import new statuses.
--------------------------------
Let's take, as example, John Mayer profile:
Username: johncmayer
RSS feed: http://twitter.com/statuses/user_timeline/19757371.rss
Bio: Recording/Sandwich Artist
Location: USA
Number of followers: 1,725,661
Img avatar: http://s3.amazonaws.com/twitter_production/profile_images/278051420/liljohnnyiran_bigger.jpg
One of the updates: Okay! I got it. It's knowing the difference between 'suffering' and 'discomfort'. Allay the suffering but stare the discomfort down.
Link to the update: http://twitter.com/johncmayer/status/2667060942
--------------------------------
