课程名： 请选择"; 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($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 ""; } ?>