<?php
$conn = mysql_connect ( 'localhost', 'root', 'admin' ) or die ( 'could not connect: ' . mysql_error () );
mysql_select_db ( 'sybgtjxt' ) or die ( 'could not select database' );
mysql_query ( "set names gbk" );
?>
实验报告提交系统
h2, font { font-style: oblique; color: #FCC898; font-weight: normal id=top; valign =top; position: relative; } function YanZheng() { var cname = document.getElementById("cname").value; var tname = document.getElementById("tname").value; var ppro = document.getElementById("ppro").value; var pgrade = document.getElementById("pgrade").value; var pcol = document.getElementById("pcol").value; //var pcutdate = document.getElementById("pcutdate").value; var pname = document.getElementById("pname").value; var paim = document.form1.paim.value; var pcontent = document.getElementById("pcontent").value; var pstep = document.getElementById("pstep").value; var panalyse = document.getElementById("panalyse").value; var presult = document.getElementById(" presult").value; //这个功能没实现 if (cname=="") { window.alert("请输入所有内容"); return false; } } function Reset() { document.getElementById("cname").value = ""; document.getElementById("tname").value = 0; document.getElementById("ppro").value = 0; document.getElementById("pgrade").value = 0; document.getElementById("pcol").value = 0; document.getElementById("pcutdate").value = ""; document.getElementById("pname").value = ""; document.getElementById("paim").value = ""; document.getElementById("pcontent").value = ""; document.getElementById("pstep").value = ""; document.getElementById("panalyse").value = ""; document.getElementById("presult").value = ""; } function YYYYMMDDstart() { MonHead = [31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31]; //先给年下拉框赋内容 var y = new Date().getFullYear(); for (var i = (y-30); i < (y+30); i++) //以今年为准,前30年,后30年 document.form1.YYYY.options.add(new Option(" "+ i, i)); //赋月份的下拉框 for (var i = 1; i < 13; i++){ if(i>=1&&i<10) document.form1.MM.options.add(new Option(" " +"0"+i, i)); else{ document.form1.MM.options.add(new Option(" "+i, i)); } } document.form1.YYYY.value = y; document.form1.MM.value = new Date().getMonth() + 1; var n = MonHead[new Date().getMonth()]; if (new Date().getMonth() ==1 && IsPinYear(YYYYvalue)) n++; writeDay(n); //赋日期下拉框 document.form1.DD.value = new Date().getDate(); } if(document.attachEvent) window.attachEvent("onload", YYYYMMDDstart); else window.addEventListener('load', YYYYMMDDstart, false); function YYYYDD(str) //年发生变化时日期发生变化(主要是判断闰平年) { var MMvalue = document.form1.MM.options[document.form1.MM.selectedIndex].value; if (MMvalue == ""){ var e = document.form1.DD; optionsClear(e); return;} var n = MonHead[MMvalue - 1]; if (MMvalue ==2 && IsPinYear(str)) n++; writeDay(n) } function MMDD(str) //月发生变化时日期联动 { var YYYYvalue = document.form1.YYYY.options[document.form1.YYYY.selectedIndex].value; if (YYYYvalue == ""){ var e = document.form1.DD; optionsClear(e); return;} var n = MonHead[str - 1]; if (str ==2 && IsPinYear(YYYYvalue)) n++; writeDay(n) } function writeDay(n) //据条件写日期的下拉框 { var e = document.form1.DD; optionsClear(e); for (var i=1; i<(n+1); i++) e.options.add(new Option(" "+ i, i)); } function IsPinYear(year)//判断是否闰平年 { return(0 == year%4 && (year%100 !=0 || year%400 == 0)); } function optionsClear(e) { e.options.length = 1; }
onsubmit="return YanZheng();">
<caption>
<h2>布置作业</h2>
</caption>
<tr>
<th style="text-align: left">课程名称:</th>
<td><input type="text" name="cname" id="cname"
style="border-color: #FCC898; border-width: 3px; border-style: solid; font-weight: normal; width: 400px;">
</td>
</tr>
<tr>
<th style="text-align: left">任课老师:</th>
<td><select name="tname" id="tname">
<option value='0' selected>请选择</option>
<?php
$sql = "select tname from tblteacher";
$result = mysql_query ( $sql );
while ( $row = mysql_fetch_assoc ( $result ) ) {
?>
学 院:
<tr>
<th style="text-align: left">实验名称:</th>
<td><input type="text" name="pname" id="pname"
style="border-color: #FCC898; border-width: 3px; border-style: solid; font-weight: normal; width: 400px;">
</td>
</tr>
<tr>
<th style="text-align: left">实验目的:</th>
<td><textarea cols="58" rows="4" name="paim" id="paim"
cellspacing="0"
style="border-color: #FCC898; resize: none; border-width: 3px; border-style: solid; font-weight: normal; width: 400px;"></textarea>
</td>
</tr>
<tr>
<th style="text-align: left">实验内容:</th>
<td><textarea cols="58" rows="4" name="pcontent" id="pcontent"
cellspacing="0"
style="border-color: #FCC898; resize: none; border-width: 3px; border-style: solid; font-weight: normal; width: 400px;"></textarea>
</td>
</tr>
<tr>
<th style="text-align: left">实验步骤:</th>
<td><textarea cols="58" rows="4" name="pstep" id="pstep"
cellspacing="0"
style="border-color: #FCC898; resize: none; border-width: 3px; border-style: solid; font-weight: normal; width: 400px;"></textarea>
</td>
</tr>
<tr>
<th style="text-align: left">实验结果:</th>
<td><textarea cols="58" rows="4" name="presult" id="presult"
cellspacing="0"
style="border-color: #FCC898; resize: none; border-width: 3px; border-style: solid; font-weight: normal; width: 400px;"></textarea>
</td>
</tr>
<tr>
<th style="text-align: left">分析讨论:</th>
<td><textarea cols="58" rows="4" name="panalyse" id="panalyse"
cellspacing="0"
style="border-color: #FCC898; resize: none; border-width: 3px; border-style: solid; font-weight: normal; width: 400px;""></textarea>
</td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="提交"> <input
type="reset" value="重置" onclick="Reset()"></td>
</tr>
</table>
</form>
请选择
<?php
$sql = "select colname from college";
$result = mysql_query ( $sql );
while ( $row = mysql_fetch_assoc ( $result ) ) {
?>
专 业:
请选择
<?php
$sql = "select pro_name from pro";
$result = mysql_query ( $sql );
while ( $row = mysql_fetch_assoc ( $result ) ) {
?>
年 级:
请选择
<?php
$sql = "select sgrade from tblstudent";
$result = mysql_query ( $sql );
while ( $row = mysql_fetch_assoc ( $result ) ) {
?>
截止日期:
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。