The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I require a script which loads tweets from the Twitter API and stores the information into a mySQL database.
The script must loop through a list of Twitter usernames (from table: users) and store new tweets into the table name: tweets.
I will also need 3 separate tables for urls, hashtags and user_mentions. Each with the tweet id to reference the tweets table.
See Tweet Entities: [obscured] /pages/tweet_entities
Use the following Twitter API call to the user timeline > user_timeline and JSON response.
*Set the following parameters:
screen_name = username from table 'users'
since_id = set as the most recent tweet id already stored in the tweets table (this should prevent multiple tweets from being stored and reduce load on server
page = (you may need to loop through multiple pages. 20 tweets returned / page)
include_rts = 1
include_entities = 1
**Never load more than 100 new Tweets
Table A: users
Sign in or Register to see more