| 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/students/ |
Upload File : |
<html>
<head>
<meta http-equiv="Content-type" content="text/html; charset=tis-620" />
</head>
<?
require_once "../config/connectdb.php";
$sql2="SELECT namesc,years,termx FROM config";
$result2 = mysql_query($sql2);
while (list($namesc,$years,$termx) = mysql_fetch_row($result2)) {
$xsc_Name = $namesc;
$years1 = $years;
$termx1=$termx;
}
?>
<?php
$dbname = "klw";
$tblname = "transcripsactivi";
$crsql="SELECT count(idstin) FROM `transcriptintall` WHERE idstin = '$idstin'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_0=$dcrd[0];
$timeac= date("j/n/").(date("Y")+543) ;
$sql2="select idstuac,codeac from transcripsactivi where idstuac='$_POST[idstuac]' and codeac='$_POST[codeac]' ";
mysql_query("SET character_set_results=tis620");//ตั้งค่าการดึงข้อมูลออกมาให้เป็น tis620
$result=mysql_query($sql2);
$row=mysql_fetch_array($result);
if($row)
{
echo "ลงทะเบียนวิชานี้แล้ว<hr> <a href=add.php>เลือกวิชาใหม่"; exit;
}
$sql = "insert into $tblname (idacti,idstuac,codeac,teachac,timeac,termac,yearac) values ('','$_POST[idstuac]','$_POST[codeac]','$_POST[teachac]','$timeac','$termx1','$years1')";
$dbquery = mysql_db_query($dbname, $sql);
if($dbquery)
{
echo "สักครู่";
echo "<br>";
echo "<meta http-equiv=\"refresh\" content=\"2;URL=addacti.php\">";
}
else
{
echo "Error Save [".$strSQL."]";
}
mysql_close();
?>
<? echo number_format($slipnum_0); ?>
</html>