Este código solo me funciona en localhost. No sé si tenga algún problema para llamar a la API de Twitter.
Si se conecta a la base de datos pero no manda absolutamente nada en el hospedaje que contraté.
Código PHP:
Ver original<?php
$host = 'localhost';
$database = 'u170904_mapas';
$username = 'u170904_don';
$password = 'Mapa2012a';
if (!$con)
{
}
$data = "http://search.twitter.com/search.json?q=%23ViveBarrio&geocode=20.6946,-103.39755,40km&include_entities=true&rpp=500" ;
$valid_data = json_decode($feed); // Converting the JSON data to PHP format. $valid_data = $valid_data->results; // Valid data now with just the tweet result.
foreach ($valid_data as $key=>$status) {
$screen_name = "ViveBarrio";
$imagen = $status->entities->media[0]->media_url;
$id = $status->id;
$caracter = $status->entities->media[0]->expanded_url;
mysql_query("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')"); $count = $conn->exec($sql); }
if($count !== false) echo 'Number of rows added: '. $count;
$data = "http://search.twitter.com/search.json?q=%23EnmiBarrio&geocode=20.6946,-103.39755,40km&include_entities=true&rpp=500" ;
$valid_data = json_decode($feed); // Converting the JSON data to PHP format. $valid_data = $valid_data->results; // Valid data now with just the tweet result.
foreach ($valid_data as $key=>$status) {
$screen_name = "EnMiBarrio";
$imagen = $status->entities->media[0]->media_url;
$id = $status->id;
$caracter = $status->entities->media[0]->expanded_url;
mysql_query("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')"); $count = $conn->exec($sql); }
if($count !== false) echo 'Number of rows added: '. $count;
$data = "http://search.twitter.com/search.json?q=%23ConsumeBarrio&geocode=20.6946,-103.39755,40km&include_entities=true&rpp=500" ;
$valid_data = json_decode($feed); // Converting the JSON data to PHP format. $valid_data = $valid_data->results; // Valid data now with just the tweet result.
foreach ($valid_data as $key=>$status) {
$screen_name = "#ConsumeBarrio";
$imagen = $status->entities->media[0]->media_url;
$id = $status->id;
$caracter = $status->entities->media[0]->expanded_url;
mysql_query("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')"); $count = $conn->exec($sql); }
if($count !== false) echo 'Number of rows added: '. $count;
$data = "http://search.twitter.com/search.json?q=%23VocesBarrio&geocode=20.6946,-103.39755,40km&include_entities=true&rpp=500" ;
$valid_data = json_decode($feed); // Converting the JSON data to PHP format. $valid_data = $valid_data->results; // Valid data now with just the tweet result.
foreach ($valid_data as $key=>$status) {
$screen_name = "#VocesBarrio";
$imagen = $status->entities->media[0]->media_url;
$id = $status->id;
$caracter = $status->entities->media[0]->expanded_url;
mysql_query("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')"); $count = $conn->exec($sql); }
if($count !== false) echo 'Number of rows added: '. $count;
?>