| 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/admissions3/ |
Upload File : |
<?
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename="name.csv"');
require_once "connectdb.php";
$sql2="SELECT years FROM config";
$result2 = mysql_query($sql2);
while (list($years) = mysql_fetch_row($result2)) {
$xsc_years = $years;
}
$tb="member";
echo "ประเภท,$_GET[id]\n";
echo "เลขประจำตัวสอบ,ชื่อ-นามสกุล,ห้อง,หมายเลขห้อง,โรงเรียน\n";
$sql = "select * from $tb where idstudent = '$_GET[id]' order by idtest+1 asc";
$dbquery = mysql_query($sql);
$num_rows = mysql_num_rows($dbquery);
$i=0;
while ($i < $num_rows)
{
$result= mysql_fetch_array($dbquery);
$k1=$result[k11];
$p1=$result[p11];
$a1=$result[a11];
$k2=$result[k22];
$p2=$result[p22];
$a2=$result[a22];
$k3=$result[k33];
$p3=$result[p33];
$a3=$result[a33];
$sumbe1=$k1+$p1+$a1;
$sumbe2=$k2+$p2+$a2;
$sumbe3=$k3+$p3+$a3;
$sumbeall=$sumbe1+$sumbe2+$sumbe3;
$k4=$result[k44];
$p4=$result[p44];
$a4=$result[a44];
$k5=$result[k55];
$p5=$result[p55];
$a5=$result[a55];
$k6=$result[k66];
$p6=$result[p66];
$a6=$result[a66];
$sumbe4=$k4+$p4+$a4;
$sumbe5=$k5+$p5+$a5;
$sumbe6=$k6+$p6+$a6;
$sumbeall1=$sumbe1+$sumbe2+$sumbe3;
$sumbeall2=$sumbe4+$sumbe5+$sumbe6;
$fina=$result[final2];
$midterm=$result[midterm];
$sumtotal=$sumbeall+$sumbeall2+$fina+$midterm;
$grade=$result[grade2];
$k11=$result[k2];
$r11=$result[r2];
echo "$result[idtest],$result[prefix]$result[name] $result[surname],$result[room],$result[room2],$result[schoolout],\n";
$i++;
}
?>