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 = $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')"); } 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 = $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')"); } 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 = $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')"); } 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 = $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')"); } if($count !== false) echo 'Number of rows added: '. $count; ?>