Weblabor

<?php
if(!$_GET['results']) {
    $query = mysql_query("SELECT id, datum, ip FROM poll_ip WHERE ip='".$_SERVER['REMOTE_ADDR']."'") or die(mysql_error());
    // Ha a szavazni kívánó user ipje megtalálható az adatbázisban..
    if (mysql_num_rows($query) == 1) {
        while ($rows = mysql_fetch_assoc($query)) {
        	// akkor ellenőrizzük hogy nem e szavazott a mai napon, ha szavazot irány az eredmények
            if(time()-strtotime($rows['datum']) <= 86400) {
                header("Location: ".$_SERVER['PHP_SELF']."?results=1");
            }
        }
    } else {
        $query = mysql_query("SELECT id, kerdes FROM poll_questions ORDER BY id DESC LIMIT 0,1") or die(mysql_error());
        while ($rows = mysql_fetch_assoc($query)) {
            echo"{$rows['kerdes']}<br /><br />";
            $query2 = mysql_query("SELECT id, valasz, kerdes_id FROM poll_answers WHERE kerdes_id='".$rows['id']."'") or die(mysql_error());
            echo"<form id=\"form1\" name=\"form1\" method=\"post\" action=\"".$_SERVER['PHP_SELF']."?vote=1\">";
            echo"<p>";
            while ($rows2 = mysql_fetch_assoc($query2)) {
                echo"<label>";
                  echo"<input type=\"radio\" name=\"poll\" value=\"{$rows2['id']}\" />";
                  echo"{$rows2['valasz']}</label>";
                echo"<br />";
            }
            echo"</p><input type=\"submit\" name=\"Submit\" value=\"Submit\" />";
            echo"</form>";
        }
    }
}


if($_GET['vote'] == 1) {
    $query = mysql_query("SELECT id, szavazatok FROM poll_answers WHERE id='".$_POST['poll']."'") or die(mysql_error());
    while ($rows = mysql_fetch_assoc($query)) {
        mysql_query("UPDATE poll_answers SET szavazatok = {$rows['szavazatok']}+1 WHERE id='".$_POST['poll']."'") or die(mysql_error());
        mysql_query("INSERT INTO poll_ip SET datum = NOW(), ip = '".$_SERVER['REMOTE_ADDR']."'") or die(mysql_error());
        header("Location: ".$_SERVER['PHP_SELF']."?results=1");
    }
}

if($_GET['results'] == 1) {
    $query = mysql_query("SELECT id, kerdes FROM poll_questions ORDER BY id DESC LIMIT 0,1") or die(mysql_error());
    while ($rows = mysql_fetch_assoc($query)) {
        echo"{$rows['kerdes']}<br /><br />";
        $query2 = mysql_query("SELECT id, valasz, szavazatok, kerdes_id FROM poll_answers WHERE kerdes_id='".$rows['id']."'") or die(mysql_error());;
        while ($rows2 = mysql_fetch_assoc($query2)) {
            $query3 = mysql_query("SELECT SUM(szavazatok) as szavazatok FROM poll_answers WHERE kerdes_id='".$rows['id']."'") or die(mysql_error());;
            while ($rows3 = mysql_fetch_assoc($query3)) {
            	// itt rajzolom ki a csikokat, remélem jó ez a megoldás
            echo"{$rows2['valasz']} - {$rows2['szavazatok']}x<div height: 10px; style=\"background-image: url(poll.png); width: ".ceil(200/$rows3['szavazatok']*$rows2['szavazatok'])."px\"></div><br />";
            }
        }
    }
}
?>