I've broken the task into logical steps to get you started. I'd suggest searching Google and the wiki [1] for the libraries and implementation details for each:
1. Download a timeline or a set of statuses. 2. Iterate through that set of statuses, pulling out each individual status. 3. For each status in the set, perform an SQL insert to save the status. A great way to learn is to try and find sample code that gets you each of these steps separately, then put them together. There is plenty of PHP and MySQL sample code available online or in books to get you started. 1. http://apiwiki.twitter.com/Libraries#PHP Thanks, Doug Williams Twitter API Support http://twitter.com/dougw On Mon, Apr 20, 2009 at 1:53 PM, Andrew Badera <[email protected]> wrote: > This isn't a SQL tutorial nor a MySQL list. Some might suggest you'd be > better off learning the basics of what you're trying to do -- learning how > to walk before you can run and all that. > > Thanks- > - Andy Badera > - [email protected] > - Google me: http://www.google.com/search?q=andrew+badera > > > > > On Mon, Apr 20, 2009 at 4:41 PM, CWitt <[email protected]> wrote: > >> >> Is there anywhere I could take a look at some of this code to store >> the Twitter data in a MySQL databases? >> >> On Apr 19, 8:50 pm, Nick Arnett <[email protected]> wrote: >> > On Sun, Apr 19, 2009 at 2:45 PM, CWitt <[email protected]> wrote: >> > >> > > My skills are rather limited, but I was thinking PHP and MySQL. I was >> > > thinking about hiring it out, but putting together the process flow to >> > > help the programmer and also help me find the correct programmer. >> > >> > PHP and MySQL sound appropriate to what you're hoping to do. Storing >> > Twitter data in MySQL is generally not a big deal, since there is such >> > limited data. A lot of us have probably created similar schemas for >> that >> > purpose. The rest of your code sounds slightly more complex, especially >> if >> > you're trying to do some sort of natural language parsing, which is >> always >> > hard. I don't know if there are libraries in PHP for that purpose. >> There >> > are in other languages. >> > >> > In any case, without specifics, it would be hard for anyone to guide >> you. >> > >> > Nick >> > >
