I am looking for a programmer that can write a php/mysql program that can do the following:
1. Using the twitter api, search twitter for tweets that contain any one of a number of keywords (e.g., hockey, rangers, nhl) and pull the following data on each twitter user:
a. Twitter ID (a unique ID)
b. Number of followers
2. Search the characters of each tweet pulled from step one against a txt file (or database whichever will perform this task the fastest) with various keywords. The keywords in the txt file (or database) will have a numerical value assigned to them. If the keyword(s) from the txt file (or database) is found in the tweet the numerical value of each keyword will be added to give that tweet a numerical value.
3. Store the twitter ID, date, number of followers, tweet, and the numerical value calculated above for each tweet in a mysql database.
I will give you an abbreviated list of keywords forstep one and the txt file(or database) for step two for development purposes. The code should allow me to increase/decrease the list of keywords and/or txt file at my discretion. I prefer the programming languages to be php and mysql.