public function updateTeam($team_number, $data) { if (!($team_number > 0)) { return array("error" => "Invalid team number"); } $where = array("organization_id" => $this->organization_id, "organization_domain_id" => $this->organization_domain_id, "team_number" => $team_number); $where_q = DBHandler::createWhereString($where, "e"); $allowed_fields = array("team_name", "summary", "strengths", "weaknesses", "score", "questions_json", "scores_json", "stats_json", "use_markdown"); $set_data = array(); foreach ($allowed_fields as $field) { if (in_array($field, $allowed_fields) && isset($data[$field])) { $set_data[$field] = $data[$field]; } } $set_q = DBHandler::createSetString($set_data, "e"); $query = "UPDATE team e SET {$set_q[0]} WHERE {$where_q[0]}"; $this->dbh->query($query, array_merge($set_q[1], $where_q[1])); return $this->getItem("team", array("team_number" => $team_number)); }