http://snipplr.com Snipplr comments feed' en-us Mon, 20 May 2013 01:48:55 GMT http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ results as $status) { $text = mysql_real_escape_string($item->text); $created_at = $status->created_at; $created_at = strtotime($created_at); $mysqldate = date('Y-m-d H:i:s',$created_at); $profile_image_url = mysql_real_escape_string($item->profile_image_url); $screen_name = $status->user->screen_name; $query = mysql_real_escape_string($query); mysql_select_db($database, $con); // SQL query to create table available at http://snipplr.com/view/56995/sql-query-to-create-a-table-in-mysql-to-store-tweets/ $query = "INSERT into tweets (`tweet_id`,`text`,`screen_name`,`created_at`,`q`) VALUES ('','$text','$screen_name',' $created_at','$q')"; $result = mysql_query($query); } mysql_close($con); } ]]> Tue, 07 Aug 2012 08:40:28 GMT http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ Mon, 12 Mar 2012 11:08:27 GMT http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ Sun, 04 Dec 2011 09:34:19 GMT http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/