//print_r($db->errorInfo());
//adds the poll
if ($title != '') {
$stmt = $db->prepare('INSERT INTO poll(id,title,userId, titleHash, groupId) VALUES (?,?,?,?,?)');
/*$titleHash = create_hash($title);*/
$titleHash = md5('poll' . $title);
$stmt->execute(array(NULL, $title, $userId, $titleHash, $groupId));
//print_r($db->errorInfo()); echo '<br>';
}
//else echo 'titleVazio<br>';
//verifies if all the options are filled
foreach ($options as $option) {
if ($option == '') {
//echo 'optionVazia<br>';
} else {
$poll = getPollByTitle($title);
$poll_id = $poll['id'];
//echo 'pollId = '.$poll_id.'<br>';
//echo 'option = '.$option.'<br>';
//console.log( 'heelo 1');
if ($option != '') {
$optionT = htmlspecialchars($option);
$db->exec("INSERT INTO pollOption VALUES(NULL,'{$poll_id}', '{$optionT}', 0)");
//print_r($db->errorInfo());
//echo '<br>';
}
}
}
//imagens
//echo 'pre';
if (isset($_FILES['image']['name']) && isset($_FILES['image']['type']) && isset($_FILES['image']['size']) && isset($_FILES['image']['tmp_name'])) {
function getPollOptions($title)
{
global $db;
$poll_id = getPollByTitle($title)['id'];
$stmt = $db->prepare('SELECT * FROM pollOption WHERE poll_id = ?');
$stmt->execute(array($poll_id));
$result = $stmt->fetchAll();
return $result;
}
