📄 handin.php
字号:
<?php header("Content-Type: text/html; charset=UTF8");?><?php putenv("NLS_LANG=AMERICAN_AMERICA.AL32UTF8");?><?php $hw_no=0; if(isset($_REQUEST['hw']) && $_REQUEST['hw']!="" && $_REQUEST['hw']!="0") { $hw_no=htmlentities($_REQUEST['hw']); }else { echo "No homework selected!"; die(); } $conn=oci_connect("zhangsan","p06123456","//127.0.0.1/XE"); if(!$conn) { echo "<h2>db connection error.</h2>".var_dump(oci_error()); die(); } if($_REQUEST['action']=="del") { $sql="DELETE FROM handin WHERE (HOMEWORK_NO,STUDENT_NO)=((".$hw_no.",".$_REQUEST['id']."))"; $s=oci_parse($conn,$sql); oci_execute($s,OCI_COMMIT_ON_SUCCESS); }?><html><head><title>Teacher Assistant System</title><link href="tas.css" rel="stylesheet" type="text/css"></head><body><center><a href=index.php><span class=red>[INDEX]</span></a>/<a href=hw.php><span class=red>[HOMEWORK]</span></a><h1>Students Assigned with Homework No.<?=$hw_no?></h1><a href=handin_edit.php?action=new&hw=<?=$hw_no?>><span class=green>[ADD]</span></a><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=100 height=6><br><b>Student No</b></td><td class=tabhead><img src=img/blank.gif width=60 height=6><br><b>NAME</b></td><td class=tabhead><img src=img/blank.gif width=100 height=6><br><b>Handin Date</b></td><td class=tabhead><img src=img/blank.gif width=80 height=6><br><b>MARKS</b></td><td class=tabhead><img src=img/blank.gif width=300 height=6><br><b>COMMENTS</b></td><td class=tabhead><img src=img/blank.gif width=80 height=6><br><b>COMMAND</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,HANDIN_DATE,MARKS,COMMENTS FROM handin left join students using (STUDENT_NO) where HOMEWORK_NO=".$hw_no." ORDER BY STUDENT_NO"; $s=oci_parse($conn,$sql);$result=oci_execute($s,OCI_DEFAULT); if(!$result) { echo $sql; echo "error!".var_dump(oci_error()); } echo "<p><spen class=yellow>".$sql."</span><p>"; $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=8><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><b>".$row['SID']."</b></td>"; echo "<td class=tabval>".$row['NAME']." </td>"; echo "<td class=tabval>".$row['HANDIN_DATE']." </td>"; echo "<td class=tabval>".$row['MARKS']." </td>"; echo "<td class=tabval>".$row['COMMENTS']." </td>"; echo "<td class=tabval>"; echo "<a onclick=\"return confirm('Delete This Handin??');\" href=handin.php?action=del&hw=".$hw_no."&id=".$row['SID']."><span class=red>[DEL]</span></a>"; echo "/<a href=handin_edit.php?action=edit&hw=".$hw_no."&id=".$row['SID']."><span class=green>[EDIT]</span></a>"; echo "</td>"; echo "<td class=tabval></td>"; echo "</tr>"; $i++; } echo "<tr valign=bottom>"; echo "<td bgcolor=#fb7922 colspan=8><img src=img/blank.gif width=1 height=8></td>"; echo "</tr>"; oci_close($conn);?></table></center></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -