php将数据导出为execl文件格式

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 .= '

id	标题	电话	地址	审核状态	内容	留言时间
".$value['id'].'	".$value['title'].'	".$value['phone'].'	".$value['address'].'	".$value['ischeck'].'	".$value['content'].'	".substr($value['datetime'],0,11).'

';
37. echo $table;
39. ?>

复制代码

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 '
';
23. echo '
';
24. echo '
';
25. echo '
';
26. foreach ($content as $k => $v){
27. echo "
";
28. echo "
";
29. echo "
";
30. echo "
";
31. echo "
";
32. echo "
";
33. echo "
";
34. echo "
";
35. echo "
";
36. }
37. echo '';
38. echo '
';
39. echo '

视频列表(index:在首页显示 lanmu:在视频页显示)

序号	用户uid	显示位置	文件名	视频名	视频介绍	上传时间
$k	{$v['title']}	{$v['phone']}	{$v['address']}	{$v['ischeck']}	{$v['content']}	{$v['datetime']}

';
40. //var_dump($content);
41. mysql_free_result($rs1);
42. mysql_close($link);
43. ?>

复制代码