Mayday's story

留言

張貼留言

這個網誌中的熱門文章

How to PHP export to Excel

How to PHP export to Excel export.php <?php require 'php-excel.class.php'; $xls = new Excel('Sheet1'); $xls->worksheets['Sheet']->addRow(array("col1"," col2 "," col3 ")); $xls->addsheet(' Sheet2 '); $xls->worksheets[' Sheet2 ']->addRow(array(" col1a "," col2a "," col3a ")); $xls->generate('export'); ?> php-excel.class.php <?php class WorkSheet { private $lines = array(); public $sWorksheetTitle; public function __construct($sWorksheetTitle) { $this->setWorksheetTitle($sWorksheetTitle); } public function setWorksheetTitle ($title) { $title = preg_replace ("/[\\\¦:¦\/¦\?¦\*¦\[¦\]]/", "", $title); $title = substr ($title, 0, 31); $this->sWorksheetTitle = $title; } public function addRow ($array) { $cells = ""; foreach ...
閱讀完整內容

Get latest google trends with php

Get latest google trends with php Here we come to the fact that if you want traffic to your website it would be good to create posts about the subjects that people search the most which will lead to more visitors and visitors are money. I needed an automated way to extract google trends on hourly bases and store in my database so I can then use them. Google does not provide API for this so here is a script that scrapes google feed and extracts the keywords. <?php     $url = 'http://www.google.com/trends/hottrends/atom/feed?pn=p1';     $referrer = 'http://www.google.com';     $agent = 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8';     $ch = curl_init();     curl_setopt($ch, CURLOPT_URL, $url);     curl_setopt($ch, CURLOPT_HEADER, 0);     curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);     curl_setopt($ch, CURLOPT_HTTPPRO...
閱讀完整內容