Code-Bin #917

untitled PHP Code
Posted by: simon | October 27, 2010 @ 5:21am

PHP Code

<?php
$query_anketa = $modx->db->query("
	SELECT c.id,c.pagetitle,c.introtext, c.content, tv.value
	FROM site_content c
	LEFT JOIN site_tmplvar_contentvalues tv
	ON c.id=tv.contentid
	WHERE c.parent=56
	AND c.published=1 AND c.deleted=0 AND tv.tmplvarid!=18
	LIMIT 10
");
$anketa = $modx->db->makeArray($query_anketa);
$st_ponudb = count($anketa);

if (count($anketa)) { 
echo '
<form action="" method="post" id="pool">		                                                  					
<p>'.$anketa[0]['content'].'</p>
<table>
';
$i=0; foreach($anketa as $s){ $i++;
	echo '	
		<tr>
                      <td><input type="radio" name="question"  value="'.$i.'"/></td>
                      <td class="odg">'.$s['value'].'</td>
                </tr>	
	'; 
}

for($x=1; $x<=count($anketa); $x++) {
  if($_POST['question']==$x) { 
     $result[$_POST['question']] = 1 ;
   }
   else {
     $result[$x] = 0 ;
   }
}

echo '</table>
<p>
   <br />
   <input type="submit" value="Glasuj" class="submit" />						
</p>
</form>';
$res= serialize($result);
$query_rezultat = $modx->db->query("
        UPDATE site_tmplvar_contentvalues SET value='$res' WHERE site_tmplvar_contentvalues.tmplvarid =18 AND site_tmplvar_contentvalues.contentid =57;
");
}

echo'<pre style="position:absolute;font-size:9px;background:#FFF;">';
print_r (unserialize($res));
print $res;
echo'</pre>';
?>

Syntax Highlighting

[Open in new window]

Author Comments

none

Rating

4.69 / 8
42 Votes