gpt4 book ai didi

thinkPHP导出csv文件及用表格输出excel的方法

转载 作者:qq735679552 更新时间:2022-09-28 22:32:09 26 4
gpt4 key购买 nike

CFSDN坚持开源创造价值,我们致力于搭建一个资源共享平台,让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章thinkPHP导出csv文件及用表格输出excel的方法由作者收集整理,如果你对这篇文章有兴趣,记得点赞哟.

本文实例讲述了thinkPHP导出csv文件及用表格输出excel的方法。分享给大家供大家参考,具体如下:

1.thinkphp导出csv文件 。

导出csv文件可能就那几行代码,今天有个问题困扰我好久,就是导出之后出现一些html代码,这个不应该,view里面是空的,controller中最后也没有$this->display(),最后细心看到think_page_trace这样的字样,恍然大悟,是页面的跟踪日志,这个默认是会输出来的。最后在方法后面加了一个exit结束就好了,下面是代码:

1.IndexController.class.php 。

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<?php
namespace Home\Controller;
use Think\Controller;
class IndexController extends Controller {
  public function index(){
   $hotel = M( 'keywords' )->field( 'PageName,Page' )->select();
   $str = "关键字,名称\n" ;
   $str = iconv( 'utf-8' , 'gb2312' , $str );
   $result = mysql_query( "select PageName,Page from hotel_keywords" );
   while ( $row =mysql_fetch_array( $result )){
    $PageName = iconv( 'utf-8' , 'gb2312' , $row [ 'PageName' ]);
    $Page = iconv( 'utf-8' , 'gb2312' , $row [ 'Page' ]);
    $str .= $PageName . "," . $Page . "\n" ;
   }
   $fileName = date ( 'Ymd' ). '.csv' ;
   $model = D( 'Keywords' );
   $model ->export_csv( $fileName , $str );
   exit ;
  }
}

2.KeywordsModel.class.php 。

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<?php
namespace Home\Model;
use Think\Model;
class KeywordsModel extends Model{
  public function export_csv( $filename , $data ){
   header( "Content-type:text/csv" );
   header( "Content-Disposition:attachment;filename=" . $filename );
   header( 'Cache-Control:must-revalidate,post-check=0,pre-check=0' );
   header( 'Expires:0' );
   header( 'Pragma:public' );
   echo $data ;
  
  }
}

奥妙就在IndexController.class.php代码最后一句的exit这里,如果不写这句,输出的excel里面有html源码,截图如下:

thinkPHP导出csv文件及用表格输出excel的方法

2.用表格输出excel 。

如下代码purchase_prospects.php 。

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
<?php
require ( 'page_header.php' );
$site_id = getIfSet( $_GET , 'site_id' , 0);
$customer_type = getIfSet( $_GET , 'customer_type' ,0);
$DB = Database::connect( $site_id );
if ( $site_id >0 && $customer_type >0){
  $sql = '' ;
  $out = '' ;
  $short_name_array = SiteSettings:: $SITE_SHORT_NAME ;
  $short_name = $short_name_array [ $site_id ];
  switch ( $customer_type ) {
   case '1' :{
    $sql = "SELECT
       email, CONCAT(UCASE(LEFT(firstname, 1)),SUBSTRING(firstname, 2)) AS firstname, CONCAT(UCASE(LEFT(lastname, 1)),SUBSTRING(lastname, 2)) AS lastname
      FROM customers
      WHERE site_id = $site_id
       AND email NOT REGEXP '.+(avanquest)|(planetart)|(novadevelop)|(qatest).+'
       AND email IN(SELECT a.email FROM customers a INNER JOIN orders b ON a.id=b.`customer_id` AND b.is_test=0 AND a.site_id = $site_id )
       AND email NOT IN (SELECT email_address FROM `newsletter_unsubscribes` WHERE site_id = $site_id );";
    $res = $DB ->query( $sql );
    $out = '<table class="data_table"><tr><th>email</th><th>firstname</th><th>lastname</th></tr>' ;
    while ( $row = mysql_fetch_array( $res )){
     $out .= '<tr><td>' . $row [ 'email' ]. '</td><td>' . $row [ 'firstname' ]. '</td><td>' . $row [ 'lastname' ]. '</td></tr>' ;
    }
    $short_name .= '_purchased' ;
    break ;
   }
   case '2' :{
    $DB ->query( "DROP TEMPORARY TABLE IF EXISTS tmp_purchase;" );
    $DB ->query( "CREATE TEMPORARY TABLE tmp_purchase SELECT a.email FROM customers a INNER JOIN orders b ON a.id=b.`customer_id` AND b.is_test=0 AND a.site_id =$site_id; " );
    $DB ->query( "DROP TEMPORARY TABLE IF EXISTS tmp_nopurchase;" );
    $DB ->query( "CREATE TEMPORARY TABLE tmp_nopurchase SELECT email FROM customers WHERE site_id =$site_id AND email NOT IN(SELECT email FROM tmp_purchase);" );
    if (9 != $site_id ){
     $datatype = SiteSettings::getPurchaseDataType( $site_id );
     $DB ->query( "INSERT tmp_nopurchase SELECT DISTINCT email FROM triggered_email_data WHERE datatype='$datatype' AND email NOT IN(SELECT email FROM tmp_purchase);" );
    }
    $sql = "SELECT DISTINCT email FROM tmp_nopurchase WHERE email NOT REGEXP '.+(avanquest)|(planetart)|(novadevelop)|(qatest).+' AND Email REGEXP '[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$' AND email NOT IN (SELECT email_address FROM `newsletter_unsubscribes` WHERE site_id =$site_id);" ;
    $res = $DB ->query( $sql );
    $out = '<table class="data_table"><tr><th>email</th></tr>' ;
    while ( $row = mysql_fetch_array( $res )){
     $out .= '<tr><td>' . $row [ 'email' ]. '</td></tr>' ;
    }
    $short_name .= '_non-purchased and signup' ;
    break ;
   }
   default :
    break ;
  }
  $out .= '</table>' ;
  header( "Content-type:application/vnd.ms-excel" );
  header( "Content-Disposition:filename=$short_name.xls" );
  echo $out ;
  exit ;
}
?>
<h1>Purchase Prospects Report</h1>
<form name= "frm" method= "get" action= "purchase_prospects.php" >
<strong>Select Site:</strong>
<select name= "site_id" id= "site_id" >
  <option value= "0" >== select site ==</option>
  <option value= "1" >STI</option>
  <option value= "2" >PA</option>
  <option value= "3" >CW</option>
  <option value= "6" >MCC</option>
  <option value= "9" >CB</option>
  <option value= "4" >STIUK</option>
  <option value= "8" >MCCUK</option>
</select> &nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
<strong>Select Type:</strong>
<select id= "customer_type" name= "customer_type" >
  <option value= "0" >== select type ==</option>
  <option value= "1" >purchased</option>
  <option value= "2" >non-purchased and signup</option>
</select>
&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
<input id= "submit" type= "submit" value= "Run &raquo;" >
</form>
<script type= "text/javascript" >
  $( function (){
   $( "#submit" ).click( function (){
    if ( '0' == $( "#site_id" ).val() || '0' == $( "#customer_type" ).val()){
     alert( 'please select Site and Site' );
     return false;
    }
   })
  });
</script>

这样也可以导出ecxcel文件,截图如下 。

thinkPHP导出csv文件及用表格输出excel的方法

依然注意最后一句exit;如果没有这一句,excel里面会有一些页面元素.

希望本文所述对大家基于thinkPHP框架的php程序设计有所帮助.

最后此篇关于thinkPHP导出csv文件及用表格输出excel的方法的文章就讲到这里了,如果你想了解更多关于thinkPHP导出csv文件及用表格输出excel的方法的内容请搜索CFSDN的文章或继续浏览相关文章,希望大家以后支持我的博客! 。

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com