getStatisApp(2,$username,$whereDepartment,$status,$level,$time);$str = mb_convert_encoding ( 姓名,一級部門,所在部門,直屬..."/>
您好,登錄后才能下訂單哦!
$data = array();
$data = $app->getStatisApp(2,$username,$whereDepartment,$status,$level,$time);
$str = mb_convert_encoding ("姓名,一級部門,所在部門,直屬上級,入職時間\n", 'GBK', 'UTF8' );
$filename = "轉(zhuǎn)正申請表審核進(jìn)度統(tǒng)計";
$filename = mb_convert_encoding ( $filename, 'GBK', 'UTF8' );
ob_end_clean ();
header ( "HTTP/1.1 200 OK" );
header ( 'Content-Encoding: none' );
header ( 'Content-type:text/csv' );
header ( "Content-Disposition:p_w_upload;filename={$filename}.csv" );
header ( 'Cache-Control:must-revalidate,post-check=0,pre-check=0,max-age=31536000' );
header ( 'Expires:0' );
header ( 'Pragma:public' );
foreach ( $data as $value ) {
$str .= mb_convert_encoding ( "{$value['truename']},{$value['oneDepartment']},{$value['twoDepartment']},{$value['leaderTruename']},{$value['entry_time']},{$value['formal_time']}\n", 'GBK', 'UTF8');
}
echo $str;
解決內(nèi)容中含有''','"'字符
foreach ($data as $row) {
$str_arr = array();
foreach ($row as $column) {
$column = mb_convert_encoding($column,'GBK', 'UTF8');
$str_arr[] = '"' . str_replace('"', '""', $column) . '"';
}
$str.=implode(',', $str_arr) . PHP_EOL;
}
原文:http://www.cnblogs.com/mybest/archive/2012/11/14/2770635.html
當(dāng)內(nèi)容中含有',' '"'的處理方式
/**
* 生成默認(rèn)以逗號分隔的CSV文件
* 解決:內(nèi)容中包含逗號(,)、雙引號("")
* @author zf
* @version 2012-11-14
*/
header("Content-Type: application/vnd.ms-excel; charset=GB2312");
header("Content-Disposition: p_w_upload;filename=CSV數(shù)據(jù).csv ");
$rs = array(
array('aa', "I'm li lei", '"boy"', '¥122,300.00'),
array('cc', 'I\'m han mei', '"gile"', '¥122,500.00'),
);
$str = '';
foreach ($rs as $row) {
$str_arr = array();
foreach ($row as $column) {
$str_arr[] = '"' . str_replace('"', '""', $column) . '"';
}
$str.=implode(',', $str_arr) . PHP_EOL;
}
echo $str;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。