http://jackxiang.com/index.php zh-cn http://jackxiang.com/post// jack <xdy108@126.com> Mon, 14 Jul 2008 09:12:09 +0000 http://jackxiang.com/post// $year = $_REQUEST['year'];
$moth = $_REQUEST['moth'];
$title = "新浪互联星空播客每日运营报表";
$chword = iconv("UTF-8","GBK", $title);
$filename = $year.iconv("UTF-8","GBK", "年").$moth.iconv("UTF-8","GBK", "月").$day.$chword;
//$filename = $year."-".$moth;
header("Content-type:application/vnd.ms-excel");
//header("Content-Disposition:filename=test.xls");
header("Content-Disposition:filename=".$filename.".xls");

$title = "日期\tPV\tUIP\t注册用户数\t视频上传量\t视频播放量\t当日视频总量\t当日视频播放总时长\t\n";
echo iconv("UTF-8","GBK", $title);  //由于php是utf8的编码，为此要转化为gbk到xsl中。。否则乱码

后面按照一定格式输出，比如用"\t"来分割各个字段。

while (!$rs->EOF)
{//遍历记录集
  $result=array("day_key"=>$rs->fields['day_key'],"pv"=>$rs->fields['pv'],"uip"=>$rs->fields['uip'],"reg_member"=> $rs->fields['reg_member'],"upload_ct"=>$rs->fields['upload_ct'],"play_ct"=>$rs->fields['play_ct'],"video_total"=>$rs->fields['video_total'],"play_time"=>$rs->fields['play_time']);    
  //echo count($result);
  foreach ($result as $value)
  {
    echo $value."\t";  
    
  }  
  echo "\n";
  unset($result);  
  $rs->MoveNext();//将指针指到下一条记录,不用的话,会出现死循环!
} ]]> http://jackxiang.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://jackxiang.com/post//#blogcomment