public static function editCategory2($category, $eAchievement, $cAchievement) { $db = Connection::getInstance(); $mysqli = $db->getConnection(); $mysqli->autocommit(FALSE); $schoolId = $category->getSchoolId(); $nic = $category->getNIC(); $gradeOfAdmission = $category->getGradeOfAdmission(); $gradeOfLeaving = $category->getGradeOfLeaving(); $pastPupilOrganizationMembership = $category->getPastPupilOrganizationMembership(); $query = "update pastPupil set gradeOfAdmission='{$gradeOfAdmission}',gradeOfLeaving='{$gradeOfLeaving}', pastPupilOrganizationMembership='{$pastPupilOrganizationMembership}' where schoolId='{$schoolId}' and NIC='{$nic}'"; $result1 = $mysqli->query($query); $result2 = DBPPAchievementController::editPPAchievement($cAchievement); $result3 = DBPPAchievementController::editPPAchievement($eAchievement); if ($result1 and $result2 and $result3) { $mysqli->commit(); return true; } else { $mysqli->rollback(); $mysqli->commit(); return false; } }