Code-Bin #919

untitled PHP Code
Posted by: s | October 27, 2010 @ 6:05am

PHP Code

<?php
$query_anketa = $modx->db->query("
	SELECT id, pagetitle, content
	FROM site_content
	WHERE parent=56
	AND published=1 AND deleted=0
");
$anketa = $modx->db->makeArray($query_anketa);
$st_anket = count($anketa);
if ($st_anket) { 
$anketa_id = $anketa[0]['id'];
$query_odgovori = $modx->db->query("
	SELECT id, value
	FROM site_tmplvar_contentvalues
	WHERE contentid=$anketa_id AND tmplvarid!=18
	LIMIT 10
");
$odgovori= $modx->db->makeArray($query_odgovori);

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

for($x=1; $x<=count($odgovori); $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>';
}

$query_rezultati = $modx->db->query("
	SELECT value
	FROM site_tmplvar_contentvalues
	WHERE contentid=$anketa_id AND tmplvarid=18
	LIMIT 1
");
$rezultati= $modx->db->makeArray($query_rezultati);

$res= serialize($result);
$query_rezultat = $modx->db->query("
        UPDATE site_tmplvar_contentvalues SET value='$res' WHERE tmplvarid =18 AND contentid =57;
");

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

Syntax Highlighting

[Open in new window]

Author Comments

none

Rating

4.52 / 8
33 Votes