📄 index.php
字号:
<?php header("Content-Type: text/html; charset=utf8");?><?php putenv("NLS_LANG=AMERICAN_AMERICA.AL32UTF8");?><html><head><title>Teacher Assistant System</title><link href="tas.css" rel="stylesheet" type="text/css"></head><body><center><a href=lec.php><span class=red>[LECTURES]</span></a>/ <a href=hw.php><span class=red>[HOMEWORK]</span></a>/ <a href=major.php><span class=red>[MAJORS]</span></a>/ <a href=class.php><span class=red>[CLASSES]</span></a><h1>Roll Book</h1><a href=tas.sql><span class=green>[SQL scripts for Oracle]</span></a> / <a href=TAS.ppt><span class=green>[ER Design (ppt)]</span></a><?php $conn=oci_connect("zhangsan","p06123456","//127.0.0.1/XE"); if(!conn) { echo "<h2>db connection error.</h2>"; die(); } $class_selected="0,0"; if($_REQUEST['m']!="" and $_REQUEST['m']!="0") { $class_selected=htmlentities($_REQUEST['m']); } ?><form NAME=fm action=index.php method=get><h2>Class<select NAME='m' onchange="fm.submit()"><option value=''>no class selected</option><?php $sql="select NAME||' '||YEAR as CLASS_NAME,YEAR, MAJOR_NO " ."from classes left join majors using (MAJOR_NO) " ."where (MAJOR_NO,YEAR) in (select distinct class_major,class_year from students) " ."order by YEAR desc"; $s=oci_parse($conn,$sql); $result=oci_execute($s,OCI_DEFAULT); while( $row=oci_fetch_array($s,OCI_BOTH) ) { echo "<option value='".$row['MAJOR_NO'].",".$row['YEAR']."' "; if ( $row['MAJOR_NO'].",".$row['YEAR']==$class_selected ) echo "selected"; echo ">"; echo $row['CLASS_NAME']; echo "</option>"; }?></select> <?php if ($class_selected!="0,0") {?><a href="att.php?action=att&m=<?=$class_selected?>"><span class=red>[Check Attendances]</span></a><?php }?></h2> </form><table border=0 cellpadding=0 cellspacing=0><tr bgcolor=#f87820><td><img src=img/blank.gif width=10 height=25></td><td class=tabhead><img src=img/blank.gif width=80 height=6><br><b>YEAR</b></td><td class=tabhead><img src=img/blank.gif width=160 height=6><br><b>Student No</b></td><td class=tabhead><img src=img/blank.gif width=100 height=6><br><b>NAME</b></td><td class=tabhead><img src=img/blank.gif width=160 height=6><br><b>PINYIN</b></td><td class=tabhead><img src=img/blank.gif width=120 height=6><br><b>STATUS</b></td><td><img src=img/blank.gif width=10 height=25></td></tr><?php $sql="SELECT lpad(STUDENT_NO,8,'0') as SID,last_NAME||first_NAME as NAME," ."to_char(admission_date,'YYYY') as YEAR,PINYIN,STATUS " ."FROM students natural join majors " ."left join (attend natrual join lectures on ( trunc(LECTURE_DATE)=trunc(SYSDATE) )) using(STUDENT_NO) " ."where (CLASS_MAJOR,CLASS_YEAR)=((".$class_selected.")) " ."ORDER BY MAJOR_NO desc,STUDENT_NO"; echo "<p><spen class=yellow>".$sql."</span><p>"; $s=oci_parse($conn,$sql); $result=oci_execute($s,OCI_DEFAULT); $i=0; while( $row=oci_fetch_array($s,OCI_BOTH) ) { if($i>0) { echo "<tr valign=bottom>"; echo "<td bgcolor=#ffffff background='img/strichel.gif' colspan=7><img src=img/blank.gif width=1 height=1></td>"; echo "</tr>"; } echo "<tr valign=center>"; echo "<td class=tabval><img src=img/blank.gif width=10 height=20></td>"; echo "<td class=tabval>".$row['YEAR']." </td>"; echo "<td class=tabval><b>".$row['SID']."</b></td>"; echo "<td class=tabval>".$row['NAME']." </td>"; echo "<td class=tabval>".$row['PINYIN']." </td>"; echo "<td class=tabval>".$row['STATUS']." </td>"; echo "<td class=tabval></td>"; echo "</tr>"; $i++; } echo "<tr valign=bottom>"; echo "<td bgcolor=#fb7922 colspan=7><img src=img/blank.gif width=1 height=8></td>"; echo "</tr>";?></table></center></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -