php 导出csv 图片,php 导出csv文件

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;

}

if(!empty($rows)){

include(PLUS_PATH."city.cache.php");

foreach( $rows as $key => $val ){

switch ($val['status']){

case 0 :

$rows[$key]['status_msg'] = '未跟进';

break;

case 1 :

$rows[$key]['status_msg'] = '未跟进';

break;

case 2 :

$rows[$key]['status_msg'] = '未跟进';

break;

case 3 :

$rows[$key]['status_msg'] = '跟进中';

break;

case 4 :

$rows[$key]['status_msg'] = '跟进成功';

break;

case 5 :

$rows[$key]['status_msg'] = '放弃跟进';

break;

default:

break ;

}

$company_name = iconv('utf-8','gb2312',$val['company_name']); //中文转码

$connecter_one = iconv('utf-8','gb2312',$val['connecter_one']); //中文转码

$connecter_one_phone = iconv('utf-8','gb2312',$val['connecter_one_phone']); //中文转码

$connecter_name = iconv('utf-8','gb2312',$_SESSION["name"]); //中文转码

$status_msg = iconv('utf-8','gb2312',$rows[$key]['status_msg']); //中文转码

$up_time = iconv('utf-8','gb2312',date('Y-m-d h:i:s',$val['up_time'])); //中文转码date('Y-m-d h:i:s',$val['up_time']);

$str .= $company_name.",".$connecter_one.",".$connecter_one_phone.",".$connecter_name.",".$status_msg.",".$up_time."\n"; //用引文逗号分开

}

$filename = date('Y-m-d').'-'.$_SESSION['name'].'客户跟进情况'.'.csv'; //设置文件名

$this->export_csv($filename,$str); //导出

}

注意：要用同步的方式调用。不能用异步的方式调用哦