php生成xls文件

phpwzb

?php
include '../../inc/auth.php';
include '../public/Base.php';
include '../public/BoonList.php';
//以上作用为pdo连接数据库
header('Cache-Control: no-cache, must-revalidate');
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: filename=leaveMessage.xls');
?>
html>
body>
table width="100%" border="1" align="center" cellspacing="1" cellpadding="1">
tr align="center">
    td nowrap>b>留言ID/b>/td>
    td nowrap>b>userid/b>/td>
    td nowrap>b>用户名/b>/td>
    td nowrap>b>留言内容/b>/td>
    td nowrap>b>日期/b>/td>
/tr>
?php
if (isset($_GET['trio']) && $_GET['trio']=='trio_message') {
    $sql = "select * from trio_message";
    $order_list = $db->getAll($sql);
    for($i=0;$icount($order_list);$i++){
echo '';
        echo''.$order_list[$i]["id"].'';
        echo''.$order_list[$i]["userid"].'';
        echo''.$order_list[$i]["user_name"].'';
        echo''.$order_list[$i]["content"].'';
        echo''.$order_list[$i]["fdate"].'';
echo '';
    }
}
?>
/table>
/body>
/html>


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/96161/showart_2081954.html