Code666 (代码贴、代码片段)

[PHP] excel表格输出的代码 vnd.ms-excel →→→→→进入此内容的聊天室

来自 , 2020-08-19, 写在 PHP, 查看 134 次.
URL http://www.code666.cn/view/c1502ae5
  1. <?php
  2. $DB_Server = "localhost";
  3. $DB_Username = "mydowns";
  4. $DB_Password = "";
  5. $DB_DBName = "mydowns";
  6. $DB_TBLName = "user";
  7. $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
  8. or die("Couldn@#t connect.");
  9. $Db = @mysql_select_db($DB_DBName, $Connect)
  10. or die("Couldn@#t select database.");
  11. $file_type = "vnd.ms-excel";
  12. $file_ending = "xls";
  13. header("Content-Type: application/$file_type");
  14. header("Content-Disposition: attachment; filename=mydowns.$file_ending");
  15. header("Pragma: no-cache");
  16. header("Expires: 0");
  17. $now_date = date(@#Y-m-d H:i@#);
  18. $title = "数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date";
  19. $sql = "Select * from $DB_TBLName";
  20. $ALT_Db = @mysql_select_db($DB_DBName, $Connect)
  21. or die("Couldn@#t select database");
  22. $result = @mysql_query($sql,$Connect)
  24. echo("$title\n");
  25. $sep = "\t";
  26. for ($i = 0; $i < mysql_num_fields($result); $i++) {
  27. echo mysql_field_name($result,$i) . "\t";
  28. }
  29. print("\n");
  30. $i = 0;
  31. while($row = mysql_fetch_row($result))
  32. {
  33. $schema_insert = "";
  34. for($j=0; $j<mysql_num_fields($result);$j++)
  35. {
  36. if(!isset($row[$j]))
  37. $schema_insert .= "NULL".$sep;
  38. elseif ($row[$j] != "")
  39. $schema_insert .= "$row[$j]".$sep;
  40. else
  41. $schema_insert .= "".$sep;
  42. }
  43. $schema_insert = str_replace($sep."$", "", $schema_insert);
  44. $schema_insert .= "\t";
  45. print(trim($schema_insert));
  46. print "\n";
  47. $i++;
  48. }
  49. return (true);
  50. ?>
  51.  
  52.  

回复 "excel表格输出的代码 vnd.ms-excel"

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

captcha

贴代码片段 - Code666