Posted By

eddequincey on 07/21/11

Tagged

Versions (?)

Last Edited at 07/21/11 11:58pm

Statistics

Viewed 837 times

Favorited by 0 user(s)

Related snippets

Save tweets using PHP from the twitter search API to a MySQL database

/ Published in: PHP

[Related SQL query to create the storage table](http://snipplr.com/view/56995/sql-query-to-create-a-table-in-mysql-to-store-tweets/ "Related SQL query to create the storage table")

Highlighted TextExpand

<?php

$q = $_GET["q"]; // query string
$request = "http://search.twitter.com/search.json?q=".urlencode($q);
$response = file_get_contents($request);
$jsonobj = json_decode($response);

if($jsonobj != null){

$con = mysql_connect('host', 'username', 'password');

if (!$con){
		die('Could not connect: ' . mysql_error());
	}

foreach($jsonobj->results as $item){
		
		$id = $item->id;
		$created_at = $item->created_at;
		$created_at = strtotime($created_at);
		$mysqldate = date('Y-m-d H:i:s',$created_at);
		$from_user = mysql_real_escape_string($item->from_user);
		$from_user_id = $item->from_user_id;
		$text = mysql_real_escape_string($item->text);
		$source = mysql_real_escape_string($item->source);
		$geo = $item->geo;
		$iso_language_code = $item->iso_language_code;
		$profile_image_url = mysql_real_escape_string($item->profile_image_url);
		$to_user_id = $item->to_user_id;
		if($to_user_id==""){ $to_user_id = 0; }
		$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 VALUES ($id,'$mysqldate','$from_user',$from_user_id,'$text','$source','$geo','$iso_language_code','$profile_image_url',$to_user_id,'$q')";
		$result = mysql_query($query);

}
	
	mysql_close($con);
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.