function GetWeather()
{
//Return all forecasts that are less than 4 hours old. (Should be either 1 or 0).
$sql = 'SELECT weather_cache_timestamp, weather_cache_html
FROM weather_cache
WHERE weather_cache_timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 HOUR) ';
$query = $this->db->query($sql);
//If 0 rows returned then get up to date weather
if ($query->num_rows() == 0) {
//Get the rss feed
try {
$weather_data = 'http://xml.weather.yahoo.com/forecastrss?p=UKXX0162&u=c';
$response = @file_get_contents($weather_data);
if (false === $response) {
$html = null;
} else {
$weather = new simplexmlelement($response);
$weather->registerXPathNamespace('data', 'http://xml.weather.yahoo.com/ns/rss/1.0');
$weather_forecast = $weather->xpath('//channel/item/data:forecast');
//Generate the html to be displayed
$html = '<table id="weather">';
$html .= ' <tr><td align="center">';
$html .= ' <div class="Date">' . date('l jS', strtotime($weather_forecast[0]->attributes()->date)) . '</div>';
$html .= ' </td>';
$html .= ' <td align="center">';
$html .= ' <div class="Date">' . date('l jS', strtotime($weather_forecast[1]->attributes()->date)) . '</div>';
$html .= ' </td></tr>';
$html .= ' <tr><td align="center">';
$html .= ' <img src="http://us.i1.yimg.com/us.yimg.com/i/us/we/52/' . xml_escape($weather_forecast[0]->attributes()->code) . '.gif" title="' . xml_escape($weather_forecast[0]->attributes()->text) . '" alt="' . xml_escape($weather_forecast[0]->attributes()->text) . '" />';
$html .= ' </td>';
$html .= ' <td align="center">';
$html .= ' <img src="http://us.i1.yimg.com/us.yimg.com/i/us/we/52/' . xml_escape($weather_forecast[1]->attributes()->code) . '.gif" title="' . xml_escape($weather_forecast[1]->attributes()->text) . '" alt="' . xml_escape($weather_forecast[1]->attributes()->text) . '" />';
$html .= ' </td></tr>';
$html .= ' <tr><td align="center">';
$html .= ' ' . xml_escape($weather_forecast[0]->attributes()->low) . '°C - ' . xml_escape($weather_forecast[0]->attributes()->high) . '°C';
$html .= ' </td>';
$html .= ' <td align="center">';
$html .= ' ' . xml_escape($weather_forecast[1]->attributes()->low) . '°C - ' . xml_escape($weather_forecast[1]->attributes()->high) . '°C';
$html .= ' </td></tr>';
$html .= '</table>';
//$html .= '<p class="Discreet">Data provided by Yahoo</p>';
/// @todo Can't we use REPLACE INTO here?
//Delete the old weather forecast
$sql = 'DELETE FROM weather_cache';
$query = $this->db->query($sql);
//Add the new weather forecast
$sql = 'INSERT INTO weather_cache(weather_cache_html) VALUES (?)';
$query = $this->db->query($sql, array($html));
}
} catch (Exception $e) {
$html = null;
}
//Return the new html
return $html;
} else {
//Otherwise return cached forecast from table
$row = $query->row();
//Return cached html
return $row->weather_cache_html;
}
}
/**
* sort children of $node, identified by $child_id_attribute
* this is done because the simplexml iterator can't be swap-sorted
*
* @param simplexmlelement $to_node node to sort children of
* @param simplexmlelement $from_node children element name to sort
* @param boolean $copy_attributes should the attributes of from_node be copied to to_node
*
* @return void
*/
protected static function file_sort_children_node_merge(&$to_node, &$from_node, $copy_attributes = TRUE)
{
// merge 'from' attributes onto 'to' node
if ($copy_attributes) {
foreach ($from_node->attributes() as $attr_key => $attr_value) {
$to_node->addAttribute($attr_key, $attr_value);
}
}
foreach ($from_node->children() as $simplexml_child) {
$simplexml_temp = $to_node->addChild($simplexml_child->getName(), self::ampersand_magic($simplexml_child));
foreach ($simplexml_child->attributes() as $attr_key => $attr_value) {
$simplexml_temp->addAttribute($attr_key, $attr_value);
}
self::file_sort_children_node_merge($simplexml_temp, $simplexml_child, FALSE);
}
}
