public function setScores($score_arr) { $conn = Connection::getInstance("write"); $class = new SchoolClass($this->class_id); $subjects = $class->getSubjectsID(); $i = 0; $sub_command = null; foreach ($subjects as $id) { $score = $score_arr[$i]; $sub_command .= "({$this->id}, {$id}, {$score}, {$this->student_id}, '{$this->year}', {$this->term_id})"; if ($i < count($subjects) - 1) { $sub_command .= ","; } $i++; } $command = "REPLACE INTO scores (ass_id, subject_id, score, student_id, year, term_id)\n\t\t\t\t\tVALUES {$sub_command}"; return $conn->execInsert($command); }
<?php include "../../includes/functions.inc"; if (Tools::valuePost("action") == "set") { $scores = Tools::valuePost("scores"); $scores = explode(",", $scores); //print_r($raw_scores); $assID = 'NULL'; if (Tools::valuePost("assID")) { //THIS IS TO UPDATE EXISTING ASSESSMENTS $assessment = new Assessment(Tools::valuePost("assID")); //$assessment->getClassID(); $ass_class = new SchoolClass($assessment->getClassID()); $subjects = $ass_class->getSubjectsID(); $assessment->setScores($scores); } else { //THIS IS TO INSERT NEW ASSESSMENTS $student = new Student(Tools::valuePost("student")); if ($ass_id = $student->addAssessment($user->getID(), Tools::valuePost("year"), Tools::valuePost("term"))) { $assessment = new Assessment($ass_id); $assessment->setScores($scores); echo $ass_id; } } } if (Tools::valuePost("action") == "delete") { $assessment = new Assessment(Tools::valuePost("id")); $assessment->delete(); }