176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Store Twitter User Tweets in mySQL on Cron Job
Sign in to Add to Watch List

IT & Programming > Web Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Nov 17, 2010

Job opened to all freelancers. Previously: Invite only

Nov 16, 2010
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Nov 16, 2010
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Hello,

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.
  [obscured]  /doc/get/statuses/user_timeline

*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

DATABASE SETUP

Table A: users
Field 1:...

Sign in or Register to see more

Job ID: 21932900
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
We have a dedicated team of 50, experts in PHP/MySQL, HTML 5, CSS 3, HTML, Ajax, Wordpress, Joomla, Custom CMS, Ecommerce, Social Networking,...
2
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 21951896  |  Submitted: Nov 17, 2010 08:51 ET 
Proposal SEALED

 Germany
INVITED
We are a premium brand strategy and internet development company based out of Germany. Our globalized work concept and strategic partnerships allow...
1
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 21951834  |  Submitted: Nov 17, 2010 08:46 ET 
Proposal SEALED

Isuru Ratnayake      
Isuru Ratnayake's identity has been verified.  Learn More
 Sri Lanka  |  
I have 5+ years experience in web development + server management in both open source and Microsoft platform. I can finish your work in 100%...
4
  |  
 5.0   |  Private   |  6 Jobs
Bid ID: 21945982  |  Submitted: Nov 16, 2010 22:22 ET 
Proposal SEALED

 United Kingdom  |  
Winner
I solve problems and build applications for the Web, Windows and Linux. I believe that the best solution is one that 'just works' - intuitive to...
1
  |  
 3.8   |  Private   |  1 Jobs
Bid ID: 21939729  |  Submitted: Nov 16, 2010 11:46 ET 
Delivery
Within 1 week
$100.00
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »