php导出数据到csv文件 |
时间:2015-01-23 来源:西部数据 作者:西部数据 |
|
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'])."
- ";
- }
-
- $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 ;
|
|
|
|