php匯出資料到csv檔

php教程匯出資料到csv檔
include(".. /admin/inc/inc.php");
$times = time();
$filename = $times.". csv";
$a = "連絡人,聯繫電話,社區,所需材料,備註,申請時間 n";
$days = postget("days");
$mktime = daystomktime($days);
$sql = "select * from  tugou where ($times-times)<$mktime";
$db = new db();
$result = $db->query( $sql );
$rs = $db->fetch($result,0);
foreach($rs as $v=>$vv)
{
$a.=$vv['name'].','. $vv['mo'].",". $vv['comm'].",".

commbox($vv['cbox']).",";
$a.="".$vv['bak'].",". date('y-m-d',$vv['times'])." rn

";
}
echo $a;
$hod = fopen ($filename,"w+");
if( fwrite($hod,$a) )
{
echo "生成檔成功，點擊<a href=$filename target=_blank>下載excel

文檔</a>";
}

function daystomktime($days)
{
switch( $days )
{
case 1:
$t = 86400;
break;
case 7:
$t = 86400*7;
break;
case 30:
$t = 86400*30;
break;
case 90:
$t = 86400*90;
break;
case 2048:
$t = 86400*2048;
break;
}
return $t;
}

function commbox( $ars )
 {
  if( trim( $ars ) == '' )
  {
   return '&nbs p;';
  }
 
  $array = include("tugou.php");
  $tmp = explode(',',$ars);
  $str ='';
  ; if( $tmp )
  {
   foreach( $tmp as $c )
   {
   $str .= $array[intval($ c)].'|';
   }
  }
  return $str;
 }
 
/*
 結構
 create table if not exists `tugou` (
  `id` int(8) not null auto_increm ent,
  `name` Varchar(20) default null comment '名字',
  `mo` Varchar(20) default null comment '手機',
& nbsp; `comm` Varchar(100) default null,
  `bak` Varchar(500) default null comment '備份',
  `cbox` Varchar(500) default null comment '類型',
  `times` int(4) default null,
  `ip` Varchar(20) default null,
  pr imary key  (`id`)
) engine=innodb  default charset=utf8 auto_increment=8 ;