公共课平时成绩查询系统PHP代码.doc
学生成绩查询界面:<!DOCTYPEHTMLPUBLIC"-/W3C/DTDHTML4.0Transitional/EN"><!-savedfromurl=(0026)http:/202.120.35.20:8500/-><HTML><HEAD><TITLE>欢迎进入延边大学公共课学生成绩查询系统</TITLE><METAhttp-equiv=Content-Typecontent="text/html;charset=gb2312"><LINKhref="file:/C|/u盘;/欢;迎;进;入;上;海;交;通;大;学;学;生;成;绩;查;询;系;统;.files/style.css"rel=stylesheet><SCRIPTlanguage=JavaScript><!-></SCRIPT><METAcontent="MSHTML6.00.2900.2604"name=GENERATOR><styletype="text/css"><!-.style5font-size:x-large;font-weight:bold;-></style></HEAD><BODYtext=#000000bgColor=#ffffffleftMargin=0topMargin=0><TABLEheight="100%"cellSpacing=0cellPadding=0width=780border=0><TBODY><TR><TDvAlign=topbackground=file:/C|/u盘;/欢;迎;进;入;上;海;交;通;大;学;学;生;成;绩;查;询;系;统;.files/bckHom1.gifheight=16><TABLEcellSpacing=0cellPadding=0width="100%"border=0><TBODY><TR><TDbgColor=#6699cc><imgsrc="banner.jpg"width="772"height="59"></TD></TR></TBODY></TABLE><TABLEcellSpacing=0cellPadding=0width="100%"><!-DWLayoutTable-><TBODY><TR><TDwidth="776"height=25> ;</TD></TR></TBODY></TABLE></TD></TR><TR><TDvAlign=topbackground=file:/C|/u盘;/欢;迎;进;入;上;海;交;通;大;学;学;生;成;绩;查;询;系;统;.files/bckHom1.gif><TABLEcellSpacing=0cellPadding=0width="100%"border=0><!-DWLayoutTable-><TBODY><TR><TDwidth=387rowspan="3"><DIValign=center><IMGheight=205src="PortMainFTU.gif"width=300></DIV></TD><TDwidth="70"height="93"> ;</TD><TDwidth="294"> ;</TD><TDwidth="29"> ;</TD></TR><TR><TDheight="109"> ;</TD><TDvAlign=topbgcolor="#FFFFFF">请输入学号:<formname="form2"method="post"action="student_chaxun2.php"><inputname="xuehao"type="text"id="xuehao"><inputtype="submit"name="Submit2"value="查询"><inputtype="reset"name="Submit"value="重填"></form><formname="form1"method="post"action=""><divalign="left"></div></form></TD><TD> ;</TD></TR><TR><TDheight="72"> ;</TD><TD> ;</TD><TD> ;</TD></TR></TBODY></TABLE></TD></TR><TR><TDvAlign=topbackground=file:/C|/u盘;/欢;迎;进;入;上;海;交;通;大;学;学;生;成;绩;查;询;系;统;.files/bckHom1.gifheight=20><TABLEcellSpacing=0cellPadding=0width="100%"><!-DWLayoutTable-><TBODY><TR><TDwidth="776"height=25> ;</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></BODY></HTML>平时成绩界面:<?phprequire_once(Connections/con1.php);?><?phpmysql_select_db($database_con1,$con1);$colname_Recordset2="1";if(isset($_POSTxuehao)$colname_Recordset2=(get_magic_quotes_gpc()?$_POSTxuehao:addslashes($_POSTxuehao);mysql_select_db($database_con1,$con1);$query_Recordset2=sprintf("SELECT*FROMstatistic,teacher_fbchengjiWHEREnum=%sANDteacher_fbchengji.xuehao=%s",$colname_Recordset2,$colname_Recordset2);$Recordset2=mysql_query($query_Recordset2,$con1)ordie(mysql_error();$row_Recordset2=mysql_fetch_assoc($Recordset2);$totalRows_Recordset2=mysql_num_rows($Recordset2);?><!DOCTYPEHTMLPUBLIC"-/W3C/DTDHTML4.0Transitional/EN"><!-savedfromurl=(0026)http:/202.120.35.20:8500/-><HTML><HEAD><TITLE>欢迎进入延边大学公共课学生成绩查询系统</TITLE><METAhttp-equiv=Content-Typecontent="text/html;charset=gb2312"><LINKhref="file:/C|/u盘;/欢;迎;进;入;上;海;交;通;大;学;学;生;成;绩;查;询;系;统;.files/style.css"rel=stylesheet><SCRIPTlanguage=JavaScript><!-></SCRIPT><METAcontent="MSHTML6.00.2900.2604"name=GENERATOR><styletype="text/css"><!-.style5font-size:x-large;font-weight:bold;-></style><scriptlanguage="JavaScript"type="text/JavaScript"><!-functionMM_reloadPage(init)/reloadsthewindowifNav4resizedif(init=true)with(navigator)if(appName="Netscape")&&(parseInt(appVersion)=4)document.MM_pgW=innerWidth;document.MM_pgH=innerHeight;onresize=MM_reloadPage;elseif(innerWidth!=document.MM_pgW|innerHeight!=document.MM_pgH)location.reload();MM_reloadPage(true);/-></script></HEAD><BODYtext=#000000bgColor=#ffffffleftMargin=0topMargin=0><TABLEheight="100%"cellSpacing=0cellPadding=0width=780border=0><TBODY><TR><TDvAlign=topbackground=file:/C|/u盘;/欢;迎;进;入;上;海;交;通;大;学;学;生;成;绩;查;询;系;统;.files/bckHom1.gifheight=16><TABLEcellSpacing=0cellPadding=0width="100%"border=0><TBODY><TR><TDbgColor=#6699cc><imgsrc="banner.jpg"width="772"height="59"></TD></TR></TBODY></TABLE><TABLEcellSpacing=0cellPadding=0width="100%"><!-DWLayoutTable-><TBODY><TR><TDwidth="776"height=25> ;</TD></TR></TBODY></TABLE></TD></TR><TR><TDvAlign=topbackground=file:/C|/u盘;/欢;迎;进;入;上;海;交;通;大;学;学;生;成;绩;查;询;系;统;.files/bckHom1.gif> ;<p> ;</p>