$studyRS = $db->query("SELECT study_id FROM lesson_study WHERE lesson_id='{$lesson_id}' AND user_id='{$user_id}' AND pay_flag=1 LIMIT 1"); if (!$studyRS) { $db->close(); $result->outputErrResult('004'); } $studyObj = $studyRS->fetch_object(); if ($studyObj == NULL) { $db->close(); $result->outputErrResult('501'); } if (!$db->query("UPDATE lesson_study SET theory_score='{$theory_score}',practical_score='{$practical_score}',communicate_ability='{$communicate_ability}',study_ability='{$study_ability}',study_attitube='{$study_attitube}',innovation='{$innovation}' WHERE lesson_id='{$lesson_id}' AND user_id='{$user_id}' AND pay_flag=1")) { $db->close(); $result->outputErrResult('004'); } $db->close(); $result->outputEnd(); //更新数据库 break; /* * 查询对应课程成绩 */ /* * 查询对应课程成绩 */ case 'getGrade': if (!array_key_exists('user_id', $_GET) || !array_key_exists('lesson_id', $_GET)) { $result->outputErrResult('001'); } $user_id = $_GET['user_id']; $lesson_id = $_GET['lesson_id']; $db = new WebTrainDBConnection();