function store_in_db() { //include connection variable global $db; $isActive = parent::getIsActive(); $createdOn = parent::getCreatedOn(); $lastEditedOn = parent::getLastEditedOn(); $user = $this::getUser(); $title = $this::getTitle(); $text = $this::getText(); // sql statement $sql = "INSERT INTO messages\r\n (is_active, created_on, last_edited_on, user_id,\r\n title, text)\r\n VALUES ('{$isActive}',\r\n '{$createdOn}',\r\n '{$lastEditedOn}',\r\n '{$user}',\r\n '{$title}',\r\n '{$text}');"; $db->exec($sql); $info = "User: '******' sends message '{$title}'"; info($info); }
function store_in_db() { //include connection variable global $db; $isActive = parent::getIsActive(); $createdOn = parent::getCreatedOn(); $lastEditedOn = parent::getLastEditedOn(); $user = $this::getUser(); $survey = $this::getSurvey(); $question = $this::getQuestion(); $answer = $this::getAnswer(); $value = $this::getValue(); // sql statement $sql = "INSERT INTO votes\r\n (is_active, created_on, last_edited_on, user_id,\r\n survey_id, question, answer_id, answer_value)\r\n VALUES ('{$isActive}',\r\n '{$createdOn}',\r\n '{$lastEditedOn}',\r\n '{$user}',\r\n '{$survey}',\r\n '{$question}',\r\n '{$answer}',\r\n '{$value}');"; $db->exec($sql); $info = "User: '******' vote on survey '{$survey}', question '{$question}', answer '{$answer}', value '{$value}'"; info($info); }