This is a really simple PHP script that chews through your Twitter archive and plops it into a mysql table. Helps with the default JS format that Twitter provides and also tags up the entity data (hashtags, user mentions, etc).
- PHP (version 5 or better)
- JSON extension
You will need to set six variables before running
- mysql host
- mysql user
- mysql password
- mysql database
- mysql table name
- timezone identifier php.net
You will also want to download your twitter archive
- download from twitter.com
- place unzipped directory in same directory as index.php before running*
(*) If you want to put it somewhere else just modify the $path_pattern parameter
v1.0 (2013-03-29)
- initial release
- Project at GitHub jacobemerck/twitter-archive-parser
- Jacob Emerick @jpemeric jacobemerick.com