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 ""; echo ""; echo ""; echo "
姓名课程名成绩
".$row['xm']."".$row['kcm']."".$row['cj']."
>"; } 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 ""; echo ""; echo ""; echo "
姓名 课程 成绩
".$row['xm'],"".$row['kcm'],"".$row['cj'],"
"; } 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 "". "". "". ""; } echo "
姓名课程成绩
".$row['xm']."".$row['kcm']."".$row['cj']."
"; } 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 "". "". "". ""; echo "
姓名课程成绩
".$row['xm']."".$row['kcm']."".$row['cj']."
"; } 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 "". "". "". ""; } echo "
姓名课程成绩
".$row['xm']."".$row['kcm']."".$row['cj']."
"; } } 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 "". "". "". ""; } echo "
姓名课程成绩
".$row['xm']."".$row['kcm']."".$row['cj']."
"; } } 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 "". "". "". ""; } echo "
姓名课程成绩
".$row['xm']."".$row['kcm']."".$row['cj']."
"; } } 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 "". "". "". ""; } echo "
姓名课程成绩
".$row['xm']."".$row['kcm']."".$row['cj']."
"; } } 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 "". "". "". ""; } echo "
课程姓名成绩
".$row['kcm']."".$row['xm']."".$row['cj']."
"; } else { echo ""; exit(); } } } ?>