November 14th, 2008
导出csv文件
No Comments php 浏览量:118网上找的,还不错,留下来备用
< ?php /* ini_set("error_reporting",E_ALL); ini_set("display_startup_errors",1); ini_set("display_errors",1); */ function escapeCSV($str){ $str = str_replace(array(',','"',"\n\r"),array('','""',''),$str); if($str == ""){ $str = '""'; } return $str; } function iconvstr($str){ return iconv('utf-8','gb2312',escapeCSV($str)); } $intent = in_array($_GET['intent'],array('y','n')) ? $_GET['intent'] : ''; if($intent != ''){ $query_cond = " WHERE `intent` ='$intent' "; }else{ $query_cond = ''; } $result = mysql_query("SELECT * FROM `{$db_fix}report` $query_cond ORDER BY `id` DESC"); $filename = date('YmdHis').'.csv'; $data = "\"ID\",Username,Company,Email,Mobile,Day,Time,Attendance"."\n"; while($r = mysql_fetch_array($result)) { $daytime1 = date('Y-m-d',$r['daytime']); $daytime2 = date('H:i:s',$r['daytime']); //$daytime = intval($daytime); $intent = ($r['intent'] == 'y') ? 'Yes' : 'No'; $data .= $r['id'].','.iconvstr($r['username']).','.iconvstr($r['company']).','.$r['email'].','.$r['mob'].','.$daytime1.','.$daytime2.','.$intent."\n"; } 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; ?> |
