<?php include 'header.inc'; ?>
<div style = "text-align:center;">
<h1> 成绩管理 </h1>
</div>
<?php
session_start();
//print_r($_SESSION);
if($_SESSION['role'] != 1)
{
echo 'Error User Role!';
die;
}
require 'connect.inc';
?>
<?php
//显示课程表
$sql = "SELECT * FROM `subject` ";
$result = mysql_query($sql,$con);
?>
<div style = "text-align:center;">学科一栏表</div>
<div style="text-align:center;">
<table align = center cellpadding="10" cellspacing="10">
<tr>
<?php
while ($property = mysql_fetch_field($result))
{
echo "<td>".$property->name."</td>" ;
}
echo "</tr>";
while($property = mysql_fetch_array($result))
{
echo "<tr><td>".$property[0]."</td>";
echo "<td>".$property[1]."</td>";
echo "<td>".$property[2]."</td></tr>";
}
?>
</table>
</div>
<?php
if(isset($_POST['submit']))
{
if(empty($_POST['stunumber']))
{
echo '<script language="javascript">window.alert("学号不能为空");</script>';
}
if(empty($_POST['classID']))
{
echo '<script language="javascript">window.alert("课程ID不能为空");</script>';
}
if(empty($_POST['score']))
{
echo '<script language="javascript">window.alert("分数不能为空");</script>';
}
else
{
if(($_POST['score']<0) || ($_POST['score']>100))
echo '<script language="javascript">window.alert("分数在0-100之间");</script>';
else
{
$sql = "SELECT * FROM `student` WHERE `stunumber` = ";
$sql .= "'".$_POST['stunumber']."'";
//echo $sql;
$result = mysql_query($sql,$con);
//echo "<br>mysql_affected_rows() :";
//echo mysql_affected_rows($con);
if(mysql_affected_rows($con) == 0)
{
echo '<script language="javascript">window.alert("不存在此学号！");</script>';
}
else
{
$sql = "SELECT * FROM `subject` WHERE `id`= ";
$sql .= "'".$_POST['classID']."'";
//echo $sql;
$result = mysql_query($sql,$con);
//echo "<br>mysql_affected_rows() :";
//echo mysql_affected_rows($con);
if(mysql_affected_rows($con) == 0)
{
echo '<script language="javascript">window.alert("不存在此课程ID！");</script>';
}
else
{
$sql = "SELECT * FROM `scores` WHERE `stunumber`= ";
$sql .= "'".$_POST['stunumber']."' AND `classID` = ";
$sql .= "'".$_POST['classID']."'";
//echo $sql;
$result = mysql_query($sql,$con);
//echo "<br>mysql_affected_rows() :";
//echo mysql_affected_rows($con);
if(mysql_affected_rows($con)!= 0)
{
echo '<script language="javascript">window.alert("已存在，请重试！");</script>';
}
else
{
$sql = "INSERT INTO `scores` (`stunumber`,`classID`,`score`) VALUES( ";
$sql .= "'".$_POST['stunumber']."',";
$sql .= "'".$_POST['classID']."',";
$sql .= "'".$_POST['score']."'";
$sql .= ")";
//echo $sql;
$result = mysql_query($sql,$con);
//echo "<br>mysql_affected_rows() :";
//echo mysql_affected_rows($con);
mysql_close($con);
echo '<script language="javascript">window.alert("插入成功！");</script>';
}
}
}
}
}
}
?>
<form enctype="multipart/form-data" method='post' action=''>
<div style="text-align:center;">
在此添加成绩
<table align = center cellpadding="10" cellspacing="10">
<tr>
<td>学号:</td>
<td><input name='stunumber' type='text'></input></td>
</tr><tr>
<td>学科ID</td>
<td><input name='classID' type='text'></input></td>
</tr><tr>
<td>成绩:</td>
<td><input name='score' type='text'></input></td>
</tr><tr>
<td><input type="submit" name = 'submit' value = "添加"/> </td>
<td><input type="reset" value = "重置"/> </td>
</tr>
<tr><td><a href='stuscore.php'>成绩一览表</a></td><td><a href='login.php'>返回</a></td></tr>
</table>
</div>
</form>
<?php include 'footer.inc' ; ?>
php.zip_php mysql_学籍php_学籍管理php
版权申诉
100 浏览量
2022-09-20
23:51:03
上传
评论
收藏 14KB ZIP 举报
php.zip （18个子文件） 
php 
students.php 1KB index.php 2KB password.php 2KB individual.php 3KB localhost .sql 4KB message.php 1KB scores.php 4KB connect.inc 356B footer.inc 95B deletescore.php 736B info.php 93B login.php 2KB delete.php 2KB header.inc 497B select.php 2KB stuscore.php 1KB insert.php 2KB logout.php 334B资源评论
