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