| Server IP : 61.19.30.66 / Your IP : 216.73.216.80 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/net/ |
Upload File : |
<html>
<head>
<title>k.l.w school</title>
</head>
<body>
<?
$filName = "customer.csv";
$objWrite = fopen("customer.csv", "w");
$objConnect = mysql_connect("localhost","root","klw3322") or die("Error Connect to Database");
$objDB = mysql_select_db("klw");
mysql_query("SET character_set_results=tis620");//ตั้งค่าการดึงข้อมูลออกมาให้เป็น tis620
mysql_query("SET character_set_client=tis620");//ตั้งค่าการส่งข้อมุลลงฐานข้อมูลออกมาให้ เป็น tis620
mysql_query("SET character_set_connection=tis620");//ตั้งค่าการติดต่อฐานข้อมูลให้เป็น tis6
$strSQL = "SELECT * FROM mainsubject LEFT JOIN transcripts ON
mainsubject.Codesub=transcripts.code JOIN klw ON transcripts.IDstudent=klw.Username JOIN teacher ON teacher.teachcode=transcripts.teach where idcode = '$_GET[id]'";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
{
fwrite($objWrite, "\"$objResult[IDstudent]\",\"$objResult[Name]\",\"$objResult[cllass]\",");
fwrite($objWrite, "\"$objResult[room]\",\"$objResult[ordinal]\",\"$objResult[code]\",\"$objResult[xyy]\",\"$objResult[xterm]\",\"$objResult[total]\",");
fwrite($objWrite, "\"$objResult[grad]\",\"$objResult[k1]\",\"$objResult[r1]\",\"$objResult[teach]\" \n");
}
fclose($objWrite);
echo "<br>คลิ๊ก <br><a href=$filName>Download</a>";
?>
</table>
</body>
</html>