php 查询二个时间段然后导出excel怎么做,新手

php 查询二个时间段然后导出excel怎么做,
附:bmtime > '$time1' and bmtime < '$time2

作者: aiyoucn   发布时间: 2011-05-13

给你个函数
$data_array为要导出数据数组
$keynames为表头数组
$keynames=array("username"=>"用户名","password"=>"密码");
PHP code

function exportExcel($data_array,$keynames,$filename) {
        //组合表头行,以制表符\t分隔,并转码为gb18030
        $title = implode ( "\t", array_values ( $keynames ) );
        $title = iconv ( "UTF-8", "GB18030", $title );
        
        $result [] = $title;
        //组合表体行
        foreach ( $data_array as $data ) {
            //按行组合数据体
            $a1 = array ();
            foreach ( $keynames as $k => $v ) {
                if ($k == "time") {
                    $data [$k] = date ( "Y-m-d", $data [$k] );
                }
                //utf8转码到gb18030,为了windows正常显示
                $a1 [] = iconv ( "UTF-8", "GB18030", preg_replace ( "/[\t]+/", " ", $data [$k] ) );
            }
            //以制表符分隔每列gb2312
            $result [] = implode ( "\t", $a1 );
        }
        
        //为了windows下正常显示,以\r\n为换行符,分隔数据字符串
        $result = implode ( "\r\n", $result );
        header ( "Content-type: text/html; charset=GB18030" );
        header ( "Content-Disposition: attachment; filename=\"" . $filename . ".xls\"" );
        exit ( $result );
    }

作者: dani1984   发布时间: 2011-05-13

$filename为导出excel表名
编码可以改成gb2312

作者: dani1984   发布时间: 2011-05-13