$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();
