PHP从数据库中导出Excel表格导出Excel表格类下载地址:http://code.google.com/p/php-excel/ 数据库test中products表结构: CREATE TABLE IF NOT EXISTS `products` ( `PRODUCTID` int(11) NOT NULL AUTO_INCREMENT, `PRODUCTNAME` varchar(255) NOT NULL DEFAULT '', `UNITPRICE` varchar(255) NOT NULL DEFAULT '', `UNITSINSTOCK` varchar(255) NOT NULL DEFAULT '', `DISCONTINUED` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`PRODUCTID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1233 ; 导出数据生成Excel表格PHP代码: <?php require (dirname (FILE) . "/php-excel.class.php"); $connection = mysql_connect("localhost", "root", ""); mysql_select_db("test", $connection); $query = "select productid, productname, unitprice, unitsinstock, discontinued from products"; $result = mysql_query($query) or die($query . '<br>' . mysql_error()); $headeAarray = array(); $headeAarray[] = array('产品ID', '产品名称', '单价', '单股', '是否停产'); //表头二维数组 $dataArray = array(); while($row = mysql_fetch_array($result)) { $dataArray[] = array($row['productid'], $row['productname'], $row['unitprice'], $row['unitsinstock'], $row['discontinued']); //数据库数据存放的二维数组 } $xls = new Excel_XML('GB2312', true, '测试Excel表格'); //编码格式、true是文本类型、false是数据类型 $xls->addArray($headeAarray); //向所要生成的excel文件中加入表头 $xls->addArray($dataArray); //向所要生成的excel文件中加入数据 $xls->generateXML('test'); //输出生成名字为test的excel文件 ?> |
|