Dody Web

CREATE TABLE `log` (
  `log_id` int(11) unsigned NOT NULL auto_increment,
  `data` text collate latin1_general_ci,
  `created_at` char(10) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`log_id`),
  KEY `date` (`created_at`)
);
 
CREATE TABLE `trend` (
  `keyword_id` bigint(20) unsigned NOT NULL auto_increment,
  `keyword` varchar(255) collate latin1_general_ci default NULL,
  `created_at` char(10) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`keyword_id`),
  KEY `kw` (`keyword`),
  KEY `date` (`created_at`)
);

<?php
 
  include "global.php";
 
  $url = 'http://www.google.com/trends/hottrends/atom/hourly';
 
  $raw = file_get_contents($url);
 
  $arr = explode('<li>', $raw);
  //print_r($arr);
 
  foreach ($arr as $k => $v) {
    if ($k>0)
      $arr2[$k] = trim(strip_tags($v));
  }
 
  $temp_100 = explode(']]>', $arr2[100]);  
 
  $arr2[100] = trim($temp_100[0]);  
 
  //print_r($arr2);
 
  $record['data'] = serialize($arr2);
  $record['created_at'] = time();
 
  $gt->db->AutoExecute('log', $record, 'INSERT');
  unset($record);
 
  foreach ($arr2 as $k => $v) {
    $record['keyword'] = $v;
    $record['created_at'] = time();
 
    $gt->db->AutoExecute('trend', $record, 'INSERT');
  }
 
  print "DONE.";
?>

select count(keyword_id) as c, keyword from trend where created_at > 0 group by keyword order by c desc