课程名： 请选择"; require "fun.php"; $kcm_sql = "select distinct KCM from KC"; //查找所有的课程名 $kcm_result = $db->query($kcm_sql); while(list($KCM) = $kcm_result->fetch(PDO::FETCH_NUM)) { //输出课程名到下拉框中 $KC = iconv('UTF-8', 'UTF-8', $KCM); echo "$KC"; } ?>
姓名：   成绩：
query(iconv('UTF-8', 'UTF-8', $cj_sql)); if ($cj_result->rowCount() == 0) // 判断该学生是否存在 echo ""; else { while (list ($XM, $CJ) = $cj_result->fetch(PDO::FETCH_NUM)) { // 获取查询结果集 $Name = iconv('UTF-8', 'UTF-8', $XM); // 在表格中显示输出"姓名-成绩"信息 echo ""; } } } ?> 姓名 成绩 $Name  $CJ

query(iconv('UTF-8', 'UTF-8', $cj_sql)); //单击【录入】按钮 if(@$_POST["btn"] == '录入') { if(empty($StudentName)||empty($Score)) echo ""; else { if($result->rowCount() != 0) //查询结果不为空，表示该成绩记录已经存在 echo ""; else { //不存在才可以添加 $insert_sql = "insert into CJ(XM, KCM, CJ) values('$StudentName', '$CourseName', '$Score')"; //添加新记录 $insert_result = $db->query(iconv('UTF-8', 'UTF-8', $insert_sql)); //执行操作 if($insert_result->rowCount() != 0) echo ""; else echo ""; } } } //单击【删除】按钮 if(@$_POST["btn"] == '删除') { if($result->rowCount() != 0) { //查询结果不为空，该成绩记录存在可删除 $delete_sql = "delete from CJ where XM ='$StudentName' and KCM ='$CourseName'"; //删除该记录 $del_affected = $db->exec(iconv('UTF-8', 'UTF-8', $delete_sql)); //执行操作 if($del_affected) echo ""; else echo ""; } else //不存在该记录，无法删 echo ""; } if(@$_POST["btn"] == '更新'){ //单击"更新"按钮 if($result->rowCount() != 0) { $update_sql = "update CJ set CJ = $Score where XM = '$StudentName' and KCM = '$CourseName'"; $update_affected = $db->exec(iconv('UTF-8', 'UTF-8', $update_sql)); if($update_affected) echo ""; else echo ""; } else echo ""; } ?>