excel.php

来自「a short sketch about linux syntex lines.」· PHP 代码 · 共 23 行

<?php
/*
导出数据到Excel;
*/
class Excel extends DBModel {
	public function export($sql){
		//echo $sql;
		ob_start();
		$sql = preg_replace('/limit (\d+),(\d+)/is', '' , $sql);
		if ($sql)
		$data = ($this->_DB->fetAll($sql));
		if (count($data)>0){
			header("Content-type:application/vnd.ms-excel");
			header("Content-Disposition:filename=".date("Y-m-d")."export.xls");
			$body = implode("\t", array_keys($data[0]))."\n";
			foreach ($data as $row){
				$body.= implode("\t", array_values($row))."\n";
			}
			echo $body;
		}
		ob_flush();
	}
}