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->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;
 }