<?php
$query_anketa = $modx->db->query("
SELECT id, pagetitle, content
FROM site_content
WHERE parent=56
AND published=1 AND deleted=0
ORDER BY ID DESC
LIMIT 1
");
$anketa = $modx->db->makeArray($query_anketa);
$anketa_id = $anketa[0]['id'];
$query_odgovori = $modx->db->query("
SELECT id, value
FROM site_tmplvar_contentvalues
WHERE contentid=$anketa_id AND tmplvarid!=18
");
$odgovori= $modx->db->makeArray($query_odgovori);
$rezultati = $modx->db->getValue("SELECT value FROM site_tmplvar_contentvalues WHERE contentid=$anketa_id AND tmplvarid=18");
<form action="" method="post" id="pool">
<p>'.$anketa[0]['content'].'</p>
<table>
';
foreach($odgovori as $s){
<tr>
<td><input type="radio" name="question" value="'.$s['id'].'"/></td>
<td class="odg">'.$s['value'].'</td>
</tr>
';
}
if($rezultati[$_POST['question']]) {
$rezultati[$_POST['question']]=$rezultati[$_POST['question']]+1;
}
else {
$rezultati[$_POST['question']]=1;
}
<p>
<br />
<input type="submit" value="Glasuj" class="submit" />
</p>
</form>';
if(!
(count($rezultati))) { $query_rezultat = $modx->db->query("
INSERT INTO site_tmplvar_contentvalues(tmplvarid, contentid, value) VALUES ('18', '$anketa_id','$res');
");
}
else {
$query_rezultat = $modx->db->query("
UPDATE site_tmplvar_contentvalues SET value='$res' WHERE tmplvarid =18 AND contentid =$anketa_id;
");
}
echo'<pre style="position:absolute;font-size:9px;background:#FFF; padding:20px;">';
echo '<br/>Rezultati:<br/><br/><table>';
foreach($odgovori as $s){
<tr>
<td style="padding:10px;">'.$s['value'].'</td>
<td style="padding:10px;">'.$res2[$s['id']].'</td>
</tr>
';
}
echo '</table><br/><br/>';
?>