search
Homephp教程php手册通过table标签,PHP输出EXCEL的实现方法

通过table标签,PHP输出EXCEL的实现方法

Jun 13, 2016 am 11:42 AM
excelheaderphptablecodeThe essentialcopyaccomplishmethodLabelofoutputpass

关键代码:

复制代码 代码如下:


 header("Content-type:application/vnd.ms-excel");
 header("Conten-Disposition:filename=hp.xlsx");
 ?>


第一句是用来声明文件内容的格式;第二局是用来修改文件名的。如果没有第二个语句的话,生成的文件将是没有后缀名的。
实现代码:

复制代码 代码如下:



 header("Content-type:application/vnd.ms-excel");
 header("Conten-Disposition:filename=hp.xlsx");
 ?>
 


 
   
 
 
   
   
   
 
 
   
   
   
 
 
   
   
   
 
i love you
编号 姓名 年龄
1 test 20
2 test2 22



当然,我们很自然的想到了,是否可以把数据库的内容也通过这种方式输出到表格呢?
答案是可以的。
实现代码:

复制代码 代码如下:



header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=qianshou.xls");
mysql_connect("localhost","root","");
mysql_select_db("test");
mysql_query("SET NAMES GBK");
$query="select * from city ";
$r=mysql_query($query);
?>


 
   
 
 
   
   
   
 
    while($row=mysql_fetch_assoc($r)){
   ?>
 
   
   
   
 
    }
   ?>
城市列表
id p_id name


Statement
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool