简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Backend Development> PHP Tutorial> body text

php export data to execl file format

WBOY
Release： 2016-07-25 09:08:27
Original
1083 people have browsed it
php将数据导出为execl文件格式
  1. ? session_start();
  2. $sql_excel="";
  3. if(isset($_SESSION["excel"]))
  4. {
  5. $sql_excel=$_SESSION["excel"];
  6. }
  7. //unset($_SESSION["excel"]);
  8. $conn=mysql_connect("localhost","root","");
  9. mysql_select_db("test");
  10. mysql_query("set names utf8",$conn);
  11. $result=mysql_query($sql_excel);
  12. header("Content-type:application/vnd.ms-excel");
  13. header("Content-Disposition:attachment;filename=export_data.xls");
  14. //$result=mysql_query($sql_excel);
  15. $result=mysql_query($sql_excel);
  16. while($arr = mysql_fetch_assoc($result)){
  17. $content[]=$arr;
  19. }
  20. // print_r($content);
  21. $table = '
  22. $table .= '
  23. $table .= '
  24. foreach($content as $key=>$value){
  25. $table .= "
  26. $table .= "
  27. $table .= "
  28. $table .= "
  29. $table .= "
  30. $table .= "
  31. $table .= "
  32. $table .= "
  33. $table .= '
  34. }
  35. $table .= '
  36. $table .= '
    37. '; '; '; "; '; '; '; '; '; '; '; '; ';
    id 标题 电话 地址 审核状态 内容 留言时间
    ".$value['id'].'".$value['title'].'".$value['phone'].'".$value['address'].'".$value['ischeck'].'".$value['content'].'".substr($value['datetime'],0,11).'
    ';
  37. echo $table;
  39. ?>
复制代码
php export data to execl file format
  1. session_start();
  2. $link= mysql_connect("localhost", "root", "") or die("Could not connect: " . mysql_error());
  3. mysql_query("set names utf8",$link);
  4. mysql_select_db("test");
  5. $sqls = "select * from news order by id desc ";
  6. $_SESSION["excel"]=$sqls;
  7. $rs1 = mysql_query($ sqls);
  8. while($arr = mysql_fetch_assoc($rs1)){
  9. $content[]=$arr;
  11. }
  12. echo '
  13. echo '
  14. echo '
  15. echo '
  16. echo '
  17. echo '
  18. echo '
  19. echo '
  20. echo '
  21. echo '
  22. echo '< /thead>';
  23. echo '
  24. foreach ($content as $k => $v){
  25. echo "
  26. echo "
  27. echo "
  28. echo "
  29. echo "
  30. echo "
  31. echo "
  32. echo "
  33. }
  34. echo '';
  35. echo '
  36. echo '
    37. '; '; '; '; '; '; '; '; '; '; '; "; "; "; "; "; "; "; "; ';
    Video list (index: Display on the homepage lanmu: Display on the video page)
    serial numberuser uid< /th>';
  37. echo '
    		38.  Display locationFile nameVideo name
  38. echo '
    		39.  Video introductionUpload time
    $k{$v['title']}< ;/td>";
  39. echo "
    		40.  {$v['phone']}{$v['address']}{$v['ischeck']}{$v['content']}{$v['datetime']}
    ';
  40. //var_dump($content);
  41. mysql_free_result($ rs1);
  42. mysql_close($link);
  43. ?>
Copy code


Related labels：
php将数据导出为execl文件格式
source：php.cn
Previous article：Multi-content paging Next article：Self-written simple PHP framework (with chm manual included)
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
Latest Articles by Author
Latest Issues
Stream data from OpenAI's API using AJAX, PHP, and server-sent events How can I use Server Sent Events (SSE) to stream data from the above API to a browser clie...
From 2023-11-11 12:03:23
0
1
497
What are the performance numbers next to components in the Vue dev tools? Does anyone have insights or resources for a certain feature in the Vue development tools?...
From 2023-11-09 14:46:48
0
1
305
How to export partial rows of a MySQL table from WHERE clause? How to export certain rows of MySQL table using where clause from PHP script? I have a MyS...
From 2023-10-21 11:41:17
0
2
271
Why in Sass stylesheets, we should use @use to import code instead of using @import directly? I'm implementing a project and from what I understand, @use will only import code into the...
From 2023-09-15 21:45:03
0
1
455
Add dynamic links to AJAX HTML tables generated by JavaScript I'm using JavaScript to generate an HTML table to populate with data from an AJAX file. I ...
From 2023-09-15 11:20:12
0
1
198
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！