📄 assign_edit.php
字号:
<?php header("Content-Type: text/html; charset=UTF8");?><?php putenv("NLS_LANG=AMERICAN_AMERICA.AL32UTF8");?><?php //HOMEWORK_NO to assign to new class or modify the assignment. $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['classno']!="") {//to add/update an assignment $class_no=htmlentities($_REQUEST['classno']); list($mjno,$YEAR)=split(",",$class_no); $ASSIGN_DATE=htmlentities($_REQUEST['assdate']); $DEADLINE=htmlentities($_REQUEST['DEADLINE']); $RATIO=htmlentities($_REQUEST['RATIO']); $sql=""; if($_REQUEST['submit']=="Add") $sql="INSERT INTO assign (HOMEWORK_NO,MAJOR_NO,YEAR,ASSIGN_DATE,DEADLINE,RATIO) " ."VALUES($hw_no,$class_no,to_date('$ASSIGN_DATE','YYYY-mm-dd'),to_date('$DEADLINE','YYYY-mm-dd'),$RATIO)"; else $sql="UPDATE assign set MAJOR_NO=$mjno,YEAR=$YEAR,ASSIGN_DATE=to_date('$ASSIGN_DATE','YYYY-mm-dd')," ."DEADLINE=to_date('$DEADLINE','YYYY-mm-dd'),RATIO=$RATIO where (HOMEWORK_NO,MAJOR_NO,YEAR)=((".$hw_no.",".$_REQUEST['id']."))"; $s=oci_parse($conn,$sql); $result=oci_execute($s,OCI_COMMIT_ON_SUCCESS); if(!$result) { echo "SQL:$sql<BR>"; echo "error!".var_dump(oci_error()); } header( 'Location: assign.php?hw='.$hw_no ); } $class_no='1,2006'; $ASSIGN_DATE=Date("Y-m-d"); $DEADLINE=Date("Y-m-d"); $RATIO=20; if($_REQUEST['action']=="edit") {//to update an assignment $sql="SELECT MAJOR_NO,YEAR,to_char(ASSIGN_DATE,'YYYY-mm-dd') as ASSIGN_DATE, to_char(deadline,'YYYY-mm-dd') as DEADLINE,RATIO " ."FROM assign where (HOMEWORK_NO,MAJOR_NO,YEAR)=((".$hw_no.",".$_REQUEST['id']."))"; $s=oci_parse($conn,$sql); $result=oci_execute($s,OCI_DEFAULT); if(!$result) { echo $sql; echo "error!".var_dump(oci_error()); } $row=oci_fetch_array($s,OCI_BOTH); $class_no=$row['MAJOR_NO'].",".$YEAR=$row['YEAR']; $ASSIGN_DATE=$row['ASSIGN_DATE']; $DEADLINE=$row['DEADLINE']; $RATIO=$row['RATIO']; }?><html><head><title>Teacher Assistant System</title><link href="tas.css" rel="stylesheet" type="text/css"></head><body><center><a href=assign.php?hw=<?=$hw_no?>><span class=red>[ASSIGN]</span></a><h1><?if($_REQUEST['action']=="edit") echo "Modify ";else echo "Add "; ?> An Assignment with Homework No.<?=$hw_no?></h1><form action=assign_edit.php method=get><table border=0 cellpadding=0 cellspacing=0><tr><td>Class:</td><td><select NAME='classno'><?php $sql="select NAME||' '||YEAR as CLASS_NAME, MAJOR_NO,YEAR ". "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_no ) echo "selected"; echo ">"; echo $row['CLASS_NAME']; echo "</option>"; } oci_close($conn); ?></select></td></tr><tr><td>Assign Date:</td><td> <input type=text size=50 NAME=assdate value='<?=$ASSIGN_DATE?>'></td></tr><tr><td>DEADLINE:</td><td> <input type=text size=50 NAME=DEADLINE value='<?=$DEADLINE?>'></td></tr><tr><td>RATIO:</td><td> <input type=text size=50 NAME=RATIO value='<?=$RATIO?>'>%</td></tr><tr><td></td><td><input type=hidden NAME=hw value='<?=$_REQUEST['hw']?>'><input type=hidden NAME=id value='<?=$_REQUEST['id']?>'><input type=submit NAME=submit border=0 value="<?if($_REQUEST['action']=="edit") echo "Update";else echo "Add"; ?>"></td></tr></table></form></center></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -