Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Home > Backend Development > PHP Tutorial > body text

A small example of php generating xls file

WBOY

Release： 2016-07-25 08:56:15

Original

1104 people have browsed it

include '../../inc/auth.php';
include '../public/Base.php';
include '../public /BoonList.php';
//The above is the code for pdo to connect to the database, you can complete it by yourself.
header('Cache-Control: no-cache, must-revalidate');
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: filename=leaveMessage.xls' );
?>
< ;td nowrap>Message content

< ?php
if (isset($_GET['trio']) && $_GET['trio']=='trio_message') {
$sql = "select * from trio_message";
$order_list = $db-> getAll($sql);
for($i=0;$i
echo '
' ;
echo'
';
echo'
';
echo'
';
echo'
';
echo'
' ;
echo '
';
}
}
?>

Message ID

userid username Date

'.$order_list[$i]["id"].' '.$order_list[$i]["userid "].' '.$order_list[$i]["user_name"].' ' .$order_list[$i]["content"].' '.$order_list[$i]["fdate"].'

Copy code

Related labels：

php生成xls文件的小例子

source：php.cn

Previous article：Detailed explanation of the usage of php header function (2) Next article：php method to traverse CSV php class to traverse csv

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn