Código PHP:
Ver original
$url = "http://search.twitter.com/search.json?q=%23ViveBarrio&geocode=20.6946,-103.39755,40km&include_entities=true&rpp=500" ; $return = $return->results; // Valid data now with just the tweet result. //$return = $return->results; // Valid data now with just the tweet result. foreach ($return as $key=>$status) { $screen_name = "ViveBarrio"; $imagen = $status->entities->media[0]->media_url; $id = $status->id; $caracter = $status->entities->media[0]->expanded_url; $sql="INSERT INTO twitter (`id`,`screen_name`,`time`,`usuario`,`nick`,`profile`,`text`,`geo1`,`geo2`,`media`,`link`,`hidden`) VALUES ('$id','$screen_name','$time','$usuario','$nick','$profile','$text','$geo1','$geo2','$media','$link','n')"; }