用php导出Excel,这样更能清楚明了!废话不多说了,直接代码!
/*导出xls用户个人信息*/ function export(){ header("Content-type:application/octet-stream"); header("Accept-Ranges:bytes"); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename=用户信息表".date("Y-m-d").".xls"); header("Pragma: no-cache"); header("Expires: 0"); //导出xls 开始 $tag0 = iconv("UTF-8", "GB2312",'用户ID'); $tag1 = iconv("UTF-8", "GB2312",'用户名'); $tag2 = iconv("UTF-8", "GB2312",'待领取'); $tag3 = iconv("UTF-8", "GB2312",'奖金总数'); $tag4 = iconv("UTF-8", "GB2312",'开户行'); $tag5 = iconv("UTF-8", "GB2312",'开户城市'); $tag6 = iconv("UTF-8", "GB2312",'开户行地址'); $tag7 = iconv("UTF-8", "GB2312",'银行卡号'); $tag8 = iconv("UTF-8", "GB2312",'持卡人姓名'); echo "$tag0\t$tag1\t$tag2\t$tag3\t$tag4\t$tag5\t$tag6\t$tag7\n"; ////查询的一张表 //$arr=M ('textpage')->field('username,count(id) as allcount,sum(price) as allprice ')->group('username')->select(); $field="crowd_textpage.tid,crowd_textpage.username,users.bankName,users.city,users.bankAddress, users.bankCard,users.bankUsr,count(crowd_textpage.id) as allcount,sum(crowd_textpage.price) as allprice"; $arr = M ('textpage')->field($field) ->join('crowd_user as users ON crowd_textpage.username=users.username') ->group('crowd_textpage.username') ->select(); //dump(M ('textpage')->getLastSql());die; foreach($arr as $key=>$val){ //$date = date('Y-m-d',$val['pay_time']); $tid = iconv("UTF-8", "GB2312", $val['tid']); $tid=$tid?$tid:'-'; $username = iconv("UTF-8", "GB2312", $val['username']); $username=$username?$username:'-'; $allcount = iconv("UTF-8", "GB2312", $val['allcount']); $allcount=$allcount?$allcount:'-'; $allprice = iconv("UTF-8", "GB2312", $val['allprice']); $allprice=$allprice?$allprice:'-'; $bankName = iconv("UTF-8", "GB2312", $val['bankName']); $bankName=$bankName?$bankName:'-'; $city = iconv("UTF-8", "GB2312", $val['city']); $city=$city?$city:'-'; $bankAddress = iconv("UTF-8", "GB2312", $val['bankAddress']); $bankAddress=$bankAddress?$bankAddress:'-'; $bankCard = iconv("UTF-8", "GB2312", $val['bankCard']); $bankCard=$bankCard?$bankCard:'-'; $bankUsr = iconv("UTF-8", "GB2312", $val['bankUsr']); $bankUsr=$bankUsr?$bankUsr:'-'; echo "$tid\t$username\t$allcount\t$allprice\t$bankName\t$city \t$bankAddress\t'$bankCard\t$bankUsr\n"; } }
这样就ok了!
转载请注明转自:运达's blog 原文地址:http://www.yunda51.com/1204.html
没看懂