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']."
"; } }