/** * converts an object to insert/update data * * @return a comma separated string e.g. "a=1,b=2" */ public function getInsertData($doubleEscaped = false) { $values = ''; if ($this->formId != null) { $this->addInsertData($values, 'FO_id', DBJson::mysql_real_escape_string(Form::getIdFromFormId($this->formId))); } if ($this->exerciseId != null) { $this->addInsertData($values, 'E_id', DBJson::mysql_real_escape_string($this->exerciseId)); } if ($this->type != null) { $this->addInsertData($values, 'FO_type', DBJson::mysql_real_escape_string($this->type)); } if ($this->solution != null) { $this->addInsertData($values, 'FO_solution', DBJson::mysql_real_escape_string($this->solution)); } if ($this->task != null) { $this->addInsertData($values, 'FO_task', DBJson::mysql_real_escape_string($this->task)); } if ($values != '') { $values = substr($values, 1); } return $doubleEscaped ? DBJson::mysql_real_escape_string($values) : $values; }
/** * converts an object to insert/update data * * @return a comma separated string e.g. "a=1,b=2" */ public function getInsertData($doubleEscaped = false) { $values = ''; if ($this->choiceId != null) { $this->addInsertData($values, 'CH_id', DBJson::mysql_real_escape_string(Choice::getIdFromChoiceId($this->choiceId))); } if ($this->formId != null) { $this->addInsertData($values, 'FO_id', DBJson::mysql_real_escape_string(Form::getIdFromFormId($this->formId))); } if ($this->text != null) { $this->addInsertData($values, 'CH_text', DBJson::mysql_real_escape_string($this->text)); } if ($this->correct != null) { $this->addInsertData($values, 'CH_correct', DBJson::mysql_real_escape_string($this->correct)); } if ($this->submissionId != null) { $this->addInsertData($values, 'S_id', DBJson::mysql_real_escape_string($this->submissionId)); } if ($values != '') { $values = substr($values, 1); } return $doubleEscaped ? DBJson::mysql_real_escape_string($values) : $values; }