| Server IP : 61.19.30.66 / Your IP : 216.73.216.59 Web Server : Apache/2.2.22 (Ubuntu) System : Linux klw 3.11.0-15-generic #25~precise1-Ubuntu SMP Thu Jan 30 17:39:31 UTC 2014 x86_64 User : www-data ( 33) PHP Version : 5.3.10-1ubuntu3.48 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/gpa/ |
Upload File : |
<?
require_once "config/connectdb.php";
$sql2="SELECT namesc,tumbolsc,amps,dissc,years,termx FROM config";
mysql_query("SET character_set_results=tis620");//ตั้งค่าการดึงข้อมูลออกมาให้เป็น tis620
mysql_query("SET character_set_client=tis620");//ตั้งค่าการส่งข้อมุลลงฐานข้อมูลออกมาให้ เป็น tis620
mysql_query("SET character_set_connection=tis620");//ตั้งค่าการติดต่อฐานข้อมูลให้เป็น ti
$result2 = mysql_query($sql2);
while (list($namesc,$tumbolsc,$amps,$dissc,$years,$termx) = mysql_fetch_row($result2)) {
$xsc_Name = $namesc;
$xsc_tumbolsc = $tumbolsc;
$xsc_disc = $dissc;
$xsc_amps = $amps;
$xsc_years = $years;
$xsc_termx = $termx;
}
?>
<?
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename="name.csv"');
$tb="transcriptintall";
echo "เลขประจำตัว,ชื่อ-นามสกุล,ระดับชั้น,ห้อง,เลขที่,รหัส,คะแนนรวม,เกรด,ครู,\n";
$sql = "select * from $tb join klw on klw.Username=transcriptintall.idstin
where codin = '$_GET[id]' and yearsx='$xsc_years' and termx='$xsc_termx'
order by room+1 asc,ordinal+1 asc";
$dbquery = mysql_query($sql);
$num_rows = mysql_num_rows($dbquery);
$i=0;
while ($i < $num_rows)
{
$result= mysql_fetch_array($dbquery);
$scor1k=$result[k11];
$scor1p=$result[p11];
$scor1a=$result[a11];
$sum1=$scor1k+$scor1p+$scor1a;
$scor2k=$result[k22];
$scor2p=$result[p22];
$scor2a=$result[a22];
$sum2=$scor2k+$scor2p+$scor2a;
$scor3k=$result[k33];
$scor3p=$result[p33];
$scor3a=$result[a33];
$sum3=$scor3k+$scor3p+$scor3a;
$scor4k=$result[k44];
$scor4p=$result[p44];
$scor4a=$result[a44];
$sum4=$scor4k+$scor4p+$scor4a;
$scor5k=$result[k55];
$scor5p=$result[p55];
$scor5a=$result[a55];
$sum5=$scor5k+$scor5p+$scor5a;
$scor6k=$result[k66];
$scor6p=$result[p66];
$scor6a=$result[a66];
$sum6=$scor6k+$scor6p+$scor6a;
$mid=$result[midterm];
$final1=$result[final2];
$sumtotal=$sum1+$sum2+$sum3+$sum4+$sum5+$sum6+$mid+$final1;
echo "$result[Username],$result[prefix]$result[Name] $result[surname],$result[cllass],$result[room],$result[ordinal],$result[codin],$sumtotal,$result[grade2],$result[teachin],\n";
$i++;
}
?>