$sql = 'select * from ' . tablename('zy_name'). ' ORDER BY `addtime` DESC '; $list = pdo_fetchall($sql); $tableheader = array('姓名', '手機(jī)', '身份證', '是否審核通過', '房號', '報名時間'); $html = "\xEF\xBB\xBF"; foreach ($tableheader as $value) { $html .= $value . "\t ,"; } $html .= "\n"; foreach ($list as $value) { $html .= $value['name'] . "\t ,"; $html .= $value['staus'] . "\t ,"; $html .= $value['tel'] . "\t ,"; $html .= $value['jifen'] . "\t ,"; $html .= $value['home'] . "\t ,"; $html .= date('Y-m-d H:i:s', $value['addtime']) . "\n"; } $filename = "報名數(shù)據(jù)".date('Y-m-d',time()); header("Content-type:text/csv"); header("Content-Disposition:attachment; filename={$filename}.csv"); echo $html; exit();
|