<?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;
?>
评论12