Skip to content

Instantly share code, notes, and snippets.

@micheljp
micheljp / twitter_display.php
Created October 6, 2012 20:45
Outputs stored Tweets from MySQL table
<?php
echo '<head>';
echo '<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />';
echo '</head>';
echo '<body>';
@micheljp
micheljp / twitter_indicators.php
Created October 6, 2012 20:22
Query Twitter Search API for specific keywords in specific geolocation and insert into MySQL table
<?php
/*This script hits the Twitter Search API for a specific set of keywords in a specific geolocation, takes and stores those **tweets in a MySQL table
**Note that this page is not public facing, outputs raw data for debugging
**If you want to store the data, and get up and running create MySQL table with following structure
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+