lec_edit.php
来自「基于数据库设计一个网页,实现基本功能：增删改、查询、统计报表的功能要有.管理信息」· PHP 代码 · 共 85 行
PHP
85 行
<?php header("Content-Type: text/html; charset=UTF8");?><?php putenv("NLS_LANG=AMERICAN_AMERICA.AL32UTF8");?><?php $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['lecno']!="") { $LECTURE_NO=htmlentities($_REQUEST['lecno']); $TOPIC=htmlentities($_REQUEST['TOPIC']); $LECTURE_DATE=htmlentities($_REQUEST['lecdate']); if($_REQUEST['submit']=="Add") $sql="INSERT INTO lectures (LECTURE_NO,TOPIC,LECTURE_DATE) VALUES($LECTURE_NO,'$TOPIC','$LECTURE_DATE')"; else $sql="UPDATE lectures set TOPIC='$TOPIC',LECTURE_DATE='$LECTURE_DATE' where LECTURE_NO=$LECTURE_NO"; $s=oci_parse($conn,$sql); oci_execute($s,OCI_COMMIT_ON_SUCCESS); header( 'Location: lec.php' ); } $major_selected=0; if(isset($_REQUEST['m']) && $_REQUEST['m']!="" && $_REQUEST['m']!="0") { $major_selected=htmlentities($_REQUEST['m']); } $LECTURE_NO=0; $TOPIC="A TOPIC"; $LECTURE_DATE=date("Y-m-d"); if($_REQUEST['action']=="edit") { $sql="SELECT * FROM lectures where LECTURE_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); $LECTURE_NO=$row['LECTURE_NO']; $TOPIC=$row['TOPIC']; $LECTURE_DATE=$row['LECTURE_DATE']; }else if($_REQUEST['action']=="new") { $sql="SELECT max(LECTURE_NO)+1 as NEW_NO FROM lectures"; $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); $LECTURE_NO=$row['NEW_NO']; } oci_close($conn); ?><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><h1><? if($_REQUEST['action']=="edit") echo "Modify ";else echo "Add "; ?> A Lecture</h1><form action=lec_edit.php method=get><table border=0 cellpadding=0 cellspacing=0><tr><td>No:</td><td><input type=text size=30 NAME=lecno <? if($_REQUEST['action']=="edit") echo "readonly"?> value=<?=$LECTURE_NO?>></td></tr><tr><td>TOPIC:</td><td> <input type=text size=30 NAME=TOPIC value='<?=$TOPIC?>'></td></tr><tr><td>Date:</td><td> <input type=text size=10 NAME=lecdate value=<?=$LECTURE_DATE?>></td></tr><tr><td></td><td><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 + =
减小字号Ctrl + -
显示快捷键?