| 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/homeroom/ |
Upload File : |
<?
require_once "../config/confiteacher.inc.php";
$ttt=$objResult["teachcode"];
$namet=$objResult["name"];
$lastname=$objResult["lastname"];
?>
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=tis-620">
<title>½èÒºÃÔËÒçҹÇÔªÒ¡ÒÃ</title>
</head>
<body onload="window.print()">
<?
require_once "../config/connectdb.php";
$year=date(" Y ")+542;
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
$strSQL = "UPDATE transcripsactivi SET ";
$strSQL .="gradeac = '".$_POST["txtgradeac$i"]."' ";
$strSQL .="WHERE idacti = '".$_POST["hdnid$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$sql2="SELECT years,termx FROM config";
$result2 = mysql_query($sql2);
while (list($years,$termx) = mysql_fetch_row($result2)) {
$xsc_years = $years;
$xsc_term = $termx;
$strSQL = "SELECT h_id,h_ids,h_idt,h_years,h_term,h_1,h_2,h_3,h_4,h_5,h_6,h_7,h_8,h_9,h_10,h_11,h_12,h_13,h_14,h_15,Username,Name,surname,room,ordinal,cllass FROM homeroom JOIN klw ON klw.Username=homeroom.h_ids WHERE h_idt = '$_GET[id]' and h_years='$xsc_years' and h_term='$xsc_term' order by room+1 asc,ordinal+1 asc";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$i = 1;
}
?>
<table width="773" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="198"><a href="regis.php"><font color="#FF0000" size="2">˹éÒËÅÑ¡</font></a>
</td>
<td width="575"><table width="100%" border="0" cellspacing="1" cellpadding="1">
</table></td>
</tr>
</table>
<table width="100%" border="0" bgcolor="#999999">
<tr bgcolor="#FFFFFF">
<th width="10" colspan="3"> <div align="center"><br>Home room</font>
</div></th>
<th width="10" colspan="3"> <div align="center"><font size=1>¤Òº</font></div></th>
<th width="10" colspan="3"> <div align="center"><font size=1>¤Òº</font></div></th>
<th width="10" colspan="3"> <div align="center"><font size=1>¤Òº</font></div></th>
<th width="10" colspan="3"> <div align="center"><font size=1>¤Òº</font></div></th>
<th width="10" colspan="3"> <div align="center"><font size=1>¤Òº</font></div></th>
<th width="10"> <div align="center"><font size=1>ÁÒ</font></div></th>
<th width="10"> <div align="center"><font size=1>ÅÒ</font></div></th>
<th width="10"> <div align="center"><font size=1>¢Ò´</font></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10" colspan="3"> <div align="center"><font size=1>¤ÃÙ <? echo "$ttt"; ?> <? echo "$namet"; ?> <? echo "$lastname"; ?>
</font></div></th>
<th width="20" colspan="3"> <div align="center"><font size=1>.........</font></div></th>
<th width="20" colspan="3"> <div align="center"><font size=1>.........</font></div></th>
<th width="20" colspan="3"> <div align="center"><font size=1>.........</font></div></th>
<th width="20" colspan="3"> <div align="center"><font size=1>.........</font></div></th>
<th width="20" colspan="3"> <div align="center"><font size=1>.........</font></div></th>
<th width="20"> <div align="center"><font size=1>.........</font></div></th>
<th width="20"> <div align="center"><font size=1>.........</font></div></th>
<th width="20"> <div align="center"><font size=1>.........</font></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10" colspan="3"> <div align="center"></div></th>
<th width="10"> <div align="center"><font size=1>1</font></div></th>
<th width="10"> <div align="center"><font size=1>2</font></div></th>
<th width="10"> <div align="center"><font size=1>3</font></div></th>
<th width="10"> <div align="center"><font size=1>4</font></div></th>
<th width="10"> <div align="center"><font size=1>5</font></div></th>
<th width="10"> <div align="center"><font size=1>6</font></div></th>
<th width="10"> <div align="center"><font size=1>7</font></div></th>
<th width="10"> <div align="center"><font size=1>8</font></div></th>
<th width="10"> <div align="center"><font size=1>9</font></div></th>
<th width="10"> <div align="center"><font size=1>10</font></div></th>
<th width="10"> <div align="center"><font size=1>11</font></div></th>
<th width="10"> <div align="center"><font size=1>12</font></div></th>
<th width="10"> <div align="center"><font size=1>14</font></div></th>
<th width="10"> <div align="center"><font size=1>15</font></div></th>
<th width="10"> <div align="center"><font size=1>16</font></div></th>
<th width="10"> <div align="center"><font size=1></font></div></th>
<th width="10"> <div align="center"><font size=1></font></div></th>
<th width="10"> <div align="center"><font size=1></font></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">#</div></th>
<th width="10"> <div align="center"><font size=1>ÃËÑʹÃ.</font></div></th>
<th width="200"> <div align="center"><font size=1>ª×èÍ-Ê¡ØÅ</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
<th width="10"> <div align="center"><font size=1>......</font></div></th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
if($bg == "#EEEEEE") { //Êèǹ¢Í§¡Òà ÊÅѺÊÕ
$bg = "#FFFFFF";
} else {
$bg = "#EEEEEE";
}
$i = $i + 1;
$h1 =$objResult["h_1"];
$h2 =$objResult["h_2"];
$h3 =$objResult["h_3"];
$h4 =$objResult["h_4"];
$h5 =$objResult["h_5"];
$h6 =$objResult["h_6"];
$h7 =$objResult["h_7"];
$h8 =$objResult["h_8"];
$h9 =$objResult["h_9"];
$h10 =$objResult["h_10"];
$h11 =$objResult["h_11"];
$h12 =$objResult["h_12"];
$h13 =$objResult["h_13"];
$h14 =$objResult["h_14"];
$h15 =$objResult["h_15"];
$room =$objResult['room'];
$Username =$objResult['Username'];
$codtime =$objResult['codtime'];
$ordinal =$objResult['ordinal'];
$cllass =$objResult['cllass'];
$w1=5;
$w2=500;
$w3=1;
$comeall=$h1+$h2+$h3+$h4+$h5+$h6+$h7+$h8+$h9+$h10+$h11+$h12+$h13+$h14+$h15;
$crsql="SELECT count(h_1) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_1='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh1=$dcrd[0];
$crsql="SELECT count(h_2) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_2='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh2=$dcrd[0];
$crsql="SELECT count(h_3) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_3='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh3=$dcrd[0];
$crsql="SELECT count(h_4) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_4='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh4=$dcrd[0];
$crsql="SELECT count(h_5) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_5='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh5=$dcrd[0];
$crsql="SELECT count(h_6) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_6='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh6=$dcrd[0];
$crsql="SELECT count(h_7) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_7='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh7=$dcrd[0];
$crsql="SELECT count(h_8) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_8='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh8=$dcrd[0];
$crsql="SELECT count(h_9) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_9='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh9=$dcrd[0];
$crsql="SELECT count(h_10) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_10='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh10=$dcrd[0];
$crsql="SELECT count(h_11) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_11='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh11=$dcrd[0];
$crsql="SELECT count(h_12) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_12='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh12=$dcrd[0];
$crsql="SELECT count(h_13) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_13='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh13=$dcrd[0];
$crsql="SELECT count(h_14) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_14='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh14=$dcrd[0];
$crsql="SELECT count(h_15) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_15='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh15=$dcrd[0];
$crsql="SELECT count(h_16) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_16='0'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nh16=$dcrd[0];
$comnon=$nh1+$nh2+$nh3+$nh4+$nh5+$nh6+$nh7+$nh8+$nh9+$nh10+$nh11+$nh12+$nh13+$nh14+$nh15+$nh16;
$crsql="SELECT count(h_1) FROM `homeroom`
WHERE h_ids='$Username' and h_idt='$ttt' and h_years='$xsc_years' and h_term='$xsc_term' and h_1='s'" ;
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$nhs1=$dcrd[0];
$la=$nhs1;
?>
<tr bgcolor="<?=$bg?>">
<input type="hidden" name="hdnid<?=$i;?>" size="1" value="<?=$objResult["h_id"];?>">
<td width="10"><?=$i?></td>
<td width="10"><font size=1><div align="right"><?=$objResult["Username"];?>
</div></font></td>
<td width="50%"><div align="left"><font size=1><?=$objResult["prefix"];?><?=$objResult["Name"];?> <?=$objResult["surname"];?>
<? echo "$cllass"; ?>/<? echo "$room"; ?>
</font></div></td>
<td width='$w1'><font size=2><? echo "$h1"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h2"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h3"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h4"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h5"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h6"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h7"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h8"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h9"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h10"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h11"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h12"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h13"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h14"; ?></font></td>
<td width='$w1'><font size=2><? echo "$h15"; ?></font></td>
<td><font size=2></font><? echo "$comeall"; ?></td>
<td><font size=2></font><? echo "$la"; ?></td>
<td><font size=2></font><? echo "$comnon"; ?></td>
</tr>
<?
$i = $i;
}
?>
</table>
</body>
</html>