alert(\"请输入姓名,课程名和成绩\");";
exit();
}
$sql = "select cj from cj where xm = '$name' and kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if(mysqli_num_rows($result)>0)
{
echo"";
exit();
}
$sql = "insert into cj(xm,kcm,cj) values('$name','$kcm','$score')";
$result = mysqli_query($db,$sql);
if($result)
{
echo"";
$result = mysqli_query($db,"select * from cj where xm = '$name' and kcm = '$kcm'");
$row = mysqli_fetch_array($result);
echo "
姓名 | 课程名 | 成绩 | ";
echo "
---|
".$row['xm']." | ";
echo "".$row['kcm']." | ";
echo "".$row['cj']." |
";
echo "
>";
}
else
{
echo "";
exit();
}
$sql = "select xm from cj where xm = '$name'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
if(strlen($kcm)&&strlen($name))
{
$sql = "delete from cj where xm = '$name' and kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
exit();
}
else
{
echo "";
exit();
}
}
else if(strlen($name))
{
$sql = "delete from cj where xm = '$name'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
exit();
}
else
{
echo "";
exit();
}
}
}
if(isset($_POST['更新']))
{
if(!strlen($name) || !strlen($kcm) || !strlen($score))
{
echo "";
exit();
}
$sql = "select xm from cj where xm = '$name'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
$sql = "update cj set cj = '$score' where xm = '$name' and kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
$result = mysqli_query($db,"select * from cj where xm = '$name' and kcm = '$kcm'");
$row = mysqli_fetch_array($result);
echo "
姓名 |
课程 |
成绩 |
";
echo "".$row['xm']," | ";
echo "".$row['kcm']," | ";
echo "".$row['cj']," |
";
echo "
";
}
else
{
echo "";
exit();
}
}
if(isset($_POST['查询']))
{
if(strlen($name)&&!strlen($score)&&!strlen($kcm))
{
$sql = "select xm from cj where xm = '$name'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
$sql = "select xm,kcm,cj from cj where xm = '$name'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "姓名 | 课程 | 成绩 |
";
while($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
echo "".$row['xm']." | ".
"".$row['kcm']." | ".
"".$row['cj']." | ".
"
";
}
echo "
";
}
else
{
echo "";
exit();
}
}
else if(strlen($name)&&strlen($kcm))
{
$sql = "select xm,kcm,cj from cj where xm = '$name' and kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($row = mysqli_fetch_array($result))
{
echo "姓名 | 课程 | 成绩 |
";
echo "".$row['xm']." | ".
"".$row['kcm']." | ".
"".$row['cj']." | ".
"
";
echo "
";
}
else{
echo "";
exit();
}
}
else if(strlen($name)&&strlen($score))
{
$sql = "select xm,cj from cj where xm = '$name' and cj = '$score'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
$sql = "select xm,kcm,cj from cj where cj= '$score' and xm = '$name'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "姓名 | 课程 | 成绩 |
";
while($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
echo "".$row['xm']." | ".
"".$row['kcm']." | ".
"".$row['cj']." | ".
"
";
}
echo "
";
}
}
else if(strlen($kcm)&&strlen($score))
{
$sql = "select kcm,cj from cj where kcm = '$kcm' and cj = '$score'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
$sql = "select xm,kcm,cj from cj where cj= '$score' and kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "姓名 | 课程 | 成绩 |
";
while($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
echo "".$row['xm']." | ".
"".$row['kcm']." | ".
"".$row['cj']." | ".
"
";
}
echo "
";
}
}
else if(strlen($score)&&!strlen($kcm)&&!strlen($name))
{
$sql = "select cj from cj where cj = '$score'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
$sql = "select xm,kcm,cj from cj where cj= '$score'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "姓名 | 课程 | 成绩 |
";
while($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
echo "".$row['xm']." | ".
"".$row['kcm']." | ".
"".$row['cj']." | ".
"
";
}
echo "
";
}
}
else if(!strlen($score)&&strlen($kcm)&&!strlen($name))
{
$sql = "select kcm from cj where kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
$sql = "select xm,kcm,cj from cj where kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "姓名 | 课程 | 成绩 |
";
while($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
echo "".$row['xm']." | ".
"".$row['kcm']." | ".
"".$row['cj']." | ".
"
";
}
echo "
";
}
}
else
{
$sql = "select xm,cj,kcm from cj";
$result = mysqli_query($db,$sql);
if($result)
{
echo "课程 | 姓名 | 成绩 |
";
while($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
echo "".$row['kcm']." | ".
"".$row['xm']." | ".
"".$row['cj']." | ".
"
";
}
echo "
";
}
else
{
echo "";
exit();
}
}
}
?>