<?
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename="name.csv"');

require_once "../config/connectdb2.php";
require_once "../config/msqli.php";
$tb="transcripts";
$teach=$objResult["teachcode"];

echo "serail,เลขประจำตัว,ชื่อ-นามสกุล,ระดับชั้น,ห้อง,เลขที่,รหัสวิชา,k1,p1,a1,รวม1,k2,p2,a2,รวม2,k3,p3,a3,รวม3,k4,p4,a4,รวม4,k5,p5,a5,รวม5,k6,p6,a6,รวม6,ก่อน,กลางภาค,หลัง,ปลายภาค,รวม,เกรด,\n";
$sqli = "select * from $tb join klw on klw.Username=transcripts.IDstudent where code LIKE 'ท21101' and room = '$_GET[room]' and teach='$teach' order by room+1 asc,ordinal+1 asc";
$dbquery = mysql_query($sqli);
$num_rows = mysql_num_rows($dbquery);

$i=0;
while ($i < $num_rows)
{
$result= mysql_fetch_array($dbquery);

$k1=$result[scor1k];
$p1=$result[scor1p];
$a1=$result[scor1a];
$k2=$result[scor2k];
$p2=$result[scor2p];
$a2=$result[scor2a];
$k3=$result[scor3k];
$p3=$result[scor3p];
$a3=$result[scor3a];

$sumbe1=$k1+$p1+$a1;
$sumbe2=$k2+$p2+$a2;
$sumbe3=$k3+$p3+$a3;
$sumbeall=$sumbe1+$sumbe2+$sumbe3;


$k4=$result[scor4k];
$p4=$result[scor4p];
$a4=$result[scor4a];
$k5=$result[scor5k];
$p5=$result[scor5p];
$a5=$result[scor5a];
$k6=$result[scor6k];
$p6=$result[scor6p];
$a6=$result[scor6a];



$sumbe4=$k4+$p4+$a4;
$sumbe5=$k5+$p5+$a5;
$sumbe6=$k6+$p6+$a6;
$sumbeall2=$sumbe4+$sumbe5+$sumbe6;


$fina=$result[final1];
$midterm=$result[mid];
$sumtotal=$sumbeall+$sumbeall2+$fina+$midterm;
$grade=$result[grad];

echo "$result[id],$result[Username],$result[prefix]$result[Name]  $result[surname],$result[cllass],$result[room],$result[ordinal],$result[code],$k1,$p1,$a1,$sumbe1,$k2,$p2,$a2,$sumbe2,$k3,$p3,$a3,$sumbe3,$k4,$p4,$a4,$sumbe4,$k5,$p5,$a5,$sumbe5,$k6,$p6,$a6,$sumbe6,$sumbeall,$midterm,$sumbeall2,$fina,$sumtotal,$grade,\n";

$i++;
}
?>