Script to find Twitter handles and then search them for key words

IN PROGRESS
Bids
6
Avg Bid (AUD)
$199
Project Budget (AUD)
$100 - $250

Project Description:
Hello.

There are two separate tasks within this project. Your bid should of course cover both tasks.

Task 1

We need you to, using the Twitter API and Search feature as much as possible, write a script to obtain a list of Twitter users. We will provide you with a list of search terms. For example, the set of search terms may be this:

Search Terms=[Kings of Leon, Sydney FC, Keith Urban, The Black Eyed Peas]

You need to write a script which will do the following:
1. Search for each Search Terms element, one at a time
2. Taking the top (first) search result, capture the following information and write it to an Excel file the following information:
a. Twitter Name (e.g. Kings of Leon)
b. Twitter Handle (e.g. @KingsofLeon)
c. Verified (If Verified [which is demonstrated by a white tick inside a blue star], enter “Yes”, otherwise enter “No”)
3. Taking the top (second) search result, capture the same information as in step 2.
4. Repeat steps 1-3, until every element in Search Terms has been searched for.

Note, how exactly you loop through those steps is of course up to you - we just need to make sure we have searched through all search terms, and have captured the output in the Excel sheet.

The Excel spreadsheet would then have only 3 columns. Column A would be Twitter Name, Column B would be Twitter Handle and Column C would be Verified.

Once Task 1 is completed, and we have our fully functioning and accurate Excel database of Twitter accounts, we can then move on to Task 2.

Task 2

We require someone to, using the Twitter API and Twitter Search as much as possible, create a script which will search a series of pre-defined Twitter accounts (the results of Task 1 above) for a series of pre-defined keywords. The script will then need to place this information into a simple SQL database. We will provide more details of what exactly we need here to the winning bidder.

For example, the set of Twitter accounts (found in Task 1) may be the following:
Twitter Accounts=[@kingsofleon, @SydneyFC, @KeithUrban, @bep]

And the set of keywords may be the following:
Keywords=[Australia, Sydney, happy, silly, event, today, soon, announced]

Your script would then need to be able to search through all the Tweets from the Twitter Accounts and test if any element in Keywords are found within the Tweets. We would run this script on some periodic basis (probably daily), and so the script would need to only report any new Tweets that have been generated since the last time the script was run.

In your bid, please write “I am a human” somewhere, and also the write the capital of France in capital letters at the end of your bid.

Please also ask any clarifying questions before submitting a bid, by sending us a message.

Skills required:
MySQL, PHP, Twitter, Web Scraping
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.