Example #1
0
 /**
  * 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;
 }
Example #2
0
 /**
  * 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;
 }