php导出数据到csv文件

include("../admin/inc/inc.php");
 $times = time();
 $filename = $times.".csv"; 
 $a = "联系人,联系电话,小区,所需材料,备注,申请时间 "; 
 $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'])."

";  
   }
  //echo $a;
  $hod = fopen ($filename,"w+");
  if( fwrite($hod,$a) )
  {
   echo "生成文件成功，点击下载excel

文档";
  }
 
 

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 ' ';
  }
 
  $array = include("tugou.php");
  $tmp = explode(',',$ars);
  $str ='';
  if( $tmp )
  {
   foreach( $tmp as $c )
   {
   $str .= $array[intval($c)].'|';
   }
  }
  return $str;
 }