phpエクスポートデータexcel
1111 ワード
function down_grade()
{
//
$tb_tester = new IModel("tester");
$tb_paper = new IModel('paper');
$tb_exam = new IModel("exam");
$tb_group = new IModel('group');
$exam_info = $tb_exam->query("Eischeck <> 0");
$name = date('Ymd')." .xls";
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=".$name);
$tx=" \t \t \t \t \t
";
echo $tx;
foreach($exam_info as $exam)
{
$tester = $tb_tester->getObj('ID='.$exam['Etesterid']);
$paper = $tb_paper->getObj('ID='.$exam['Epaperid']);
$group = $tb_group->getObj('ID='.$tester['Tgroupid']);
echo $tester['Tname']."\t".$group['Ggroupname']."\t";
echo $paper['Ppapername']."\t";
echo $exam['Esubmittime']."\t".$exam['Egrades']."\t";
echo $tester['Tmobile']."
";
}
}