plugin lấy giá vàng từ Tuổi trẻ Online

< ?php
   /*
CREATE TABLE IF NOT EXISTS `mk_giavang` (
  `code` char(5) NOT NULL,
  `name` char(25) NOT NULL,
  `buy` char(10) NOT NULL,
  `transfer` char(10) NOT NULL,
  `sell` char(10) NOT NULL,
  `date_create` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 */

function giavang() {    

$ci = &get_instance();    
$time = time();        
$ci->load->database();

  $row = $ci->db->limit(1)->get('giavang')->row_array();
  if(!$row || $row['date_create']<($time-3600))     {         if($data = get_giavang())         {             $ci->db->empty_table('giavang');
       
          foreach($data as $row)
          {
              $ci->db->insert('giavang', $row);
          }
      }
      else if($row){
          return $ci->db->get('giavang')->result_array();
      }
  }

  return $ci->db->get('giavang')->result_array();

}

function get_giavang()
{
  $data = array();
  $time = time();

  if(!$content = file_get_contents('http://www3.tuoitre.com.vn/transweb/giavang.htm'))
      return $data;
   
  $content = substr($content, strpos($content, ''));
  $text = trim(substr($content, 0, strpos($content, '')+8));

  $xml = simplexml_load_string($text);
  foreach($xml as $a=>$b){
      $row['code'] = trim((string)$b->td[0]);
      $row['buy'] = trim((string)$b->td[1]);
      $row['sell'] = trim((string)$b->td[2]);
      $row['date_create'] = $time;     
      $data[] = $row;
  }

  unset($data[0]);

  return $data;
}