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 ' ';
}

$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_increment,
`name` varchar(20) default null comment '名字',
`mo` varchar(20) default null comment '手机',
`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,
primary key (`id`)
) engine=innodb default charset=utf8 auto_increment=8 ;

补充：Php教程,Php常用代码