学步园

$result=mysql_query("select * from 表名");
export_csv($result);
function export_csv($result) {
    $filename = date('YmdHis').".csv";
    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 array_to_string($result);
}
function array_to_string($result) {
    if(empty($result)) {
        return i("没有符合您要求的数据！");
    }
    //对应需要输出表中的字段
    $data = 'passport,prize,order,games,charge,gamesname,chargetime,username,card,phone,address,code'."\n";
    $size_result = sizeof($result);
    for($i = 0 ; $i < $size_result ;  $i++) {
        $data .= i($result[$i]['passport']).','.i($result[$i]['prize']).','.i($result[$i]['order']).','.i($result[$i]['games']).','.i($result[$i]['charge']).','.i($result[$i]['gamesname']).','.i($result[$i]['chargetime']).','.i($result[$i]['username']).','.i('('.$result[$i]['card']).','.i('('.$result[$i]['phone']).','.i($result[$i]['address']).','.i('('.$result[$i]['code'])."\n";
    }
    return $data;
    
}
//字符串的转换
 function i($strInput) {
    return iconv('utf-8','gb2312',$strInput);//页面编码为utf-8时使用，否则导出的中文为乱码
}