Cacher is the code snippet organizer for pro developers

<?php


    $enlace =  mysqli_connect('localhost', 'xxx_aire', 'xxx');
    if (!$enlace) {
        die('No pudo conectarse: ' . mysql_error());
    }
    mysqli_select_db($enlace, 'bd_aire'); 


    $sql ="SELECT hour, value FROM madrid WHERE code=\"NO2\" AND place=\"ladreda\" order by id desc limit 1";
    $no2 = mysqli_query($enlace, $sql);

    $sql ="SELECT hour, value FROM madrid WHERE code=\"O3\" AND place=\"ladreda\" order by id desc limit 1";
    $o3 = mysqli_query($enlace, $sql);

    $sql ="SELECT hour, value FROM madrid WHERE code=\"CO\" AND place=\"ladreda\" order by id desc limit 1";
    $co = mysqli_query($enlace, $sql);

    $res_no2 = $no2->fetch_row();
    $res_o3  = $o3->fetch_row();
    $res_co  = $co->fetch_row();

    $out  = "Contaminación atmosférica en Plaza Fdez. Ladreda: [". date('d') ."/". date('m') ."/". date('Y')  ." - ". $res_no2[0] . ":00 h ] " ;
    $out .= "
| $res_no2[1] NO2 | $res_o3[1] O3 | $res_co[1] CO |";

    if (is_numeric($res_no2[1])) {
	echo $out;
    }else{
	die("no hay datos");
    }

$agent = "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1309.0 Safari/537.17";
ini_set('user_agent', $agent);


require_once 'abre_conex.php';
require_once 'funcs.php';
require_once '../twitteroauth/twitteroauth.php';


define("CONSUMER_KEY","A0VAHvAAAAAuNBXUCdA");
define("CONSUMER_SECRET","DzoAAAAAEiXcYX6jVyfAAAAANSLZQEqYe");
define("OAUTH_TOKEN", "27AAAAAXdPLld7AAAAA");
define("OAUTH_SECRET", "IgAAAAAZenMsF95AAAAAW6Q0i");

$connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, OAUTH_TOKEN, OAUTH_SECRET);

/** UPDATE 20130612 TWITTER v.1 API IS DEAD **/
$connection->host = "https://api.twitter.com/1.1/";
$connection->useragent = "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1309.0 Safari/537.17";
$connection->ssl_verifypeer = TRUE;


/** **/

$status = $connection->post('statuses/update', array('status' => $out));
echo $status->id_str;