Code666 (代码贴、代码片段)

[PHP] PHP导出Excel文件 →→→→→进入此内容的聊天室

来自 , 2020-10-14, 写在 PHP, 查看 138 次.
URL http://www.code666.cn/view/c7558e9d
  1. <?
  2. define("DB_HOST","localhost");
  3. define("DB_USER","root");
  4. define("DB_PASS","root");
  5. define("DB_DATABASE","cowaw");
  6. mysql_connect(DB_HOST,DB_USER,DB_PASS) or die('can not connect mysql database!');
  7. mysql_select_db(DB_DATABASE) or die('can not select database!');
  8. mysql_query('set names utf8');
  9.  
  10. header("Content-type:application/vnd.ms-excel"); //excel文件头
  11. header("Content-Disposition:filename=xlstest.xls"); //excel文件头
  12.  
  13. $query = mysql_query("select name,sex,city,job from xlstest ");
  14. while ($result=mysql_fetch_array($query)){
  15.         echo $result['name']."\t".$result['sex']."\t".$result['city']."\t".$result['job']."\t\n";
  16.  
  17. }
  18. ?>

回复 "PHP导出Excel文件"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666