<?
// MySQL gegevens
$cfg["sql_host"] = "localhost"; // De host
$cfg["sql_user"] = ""; // Gebruikersnaam
$cfg["sql_pass"] = ""; // Wachtwoord
$cfg["sql_db"] = ""; // De database
// Poll vraag & antwoorden
$cfg["vragen"] = array("Een antwoord","Nog een antwoord","En nog een","Nummer 4","Antwoord vijf","Nog iets"); // De vragen
// PHP codes
$connect = @mysql_connect($cfg["sql_host"],$cfg["sql_user"],$cfg["sql_pass"]) or die("Kon geen verbinding maken de MySQL server: " . mysql_error());
@mysql_select_db($cfg["sql_db"],$connect) or die("Kon database niet selecteren: " . mysql_error());
$ip = $_SERVER["REMOTE_ADDR"];
$gestemd = FALSE;
$query = "SELECT id FROM stemmen WHERE ip = '" . $ip . "' LIMIT 0,1";
$result = @mysql_query($query) or die("Kon query niet uitvoeren: " . mysql_error());
if(mysql_num_rows($result) > 0)
{
$gestemd = TRUE;
}
if(isset($_POST["stem"]) == TRUE)
{
if(gettype($_POST["stem"]) == "array")
{
if($gestemd == TRUE)
{
echo "Je hebt al op deze poll gestemd";
}
else
{
$stemmen = "";
for($i=0;$i<count($cfg["vragen"]);$i++)
{
if(isset($_POST["stem"][$i]) == FALSE)
{
echo "Selecteer alle opties";
die();
}
if($stemmen != "")
{
$stemmen .= ",";
}
$stemmen .= ((int) $_POST["stem"][$i]);
}
$query = "INSERT INTO stemmen (id,ip,stem) VALUES ('','" . $ip . "','" . $stemmen . "')";
$result = @mysql_query($query) or die("Kon query niet uitvoeren: " . mysql_error());
if(mysql_affected_rows() == 0)
{
echo "Om onbekende redenen konden je stemmen niet in de database worden ingevoerd.";
}
else
{
echo "Bedankt voor je stemmen !";
}
}
echo "<br><br>";
}
}
$query = "SELECT * FROM stemmen";
$result = @mysql_query($query) or die("Kon query niet uitvoeren: " . mysql_error());
$totaal = 0;
$stemmen = array();
while($rij = mysql_fetch_object($result))
{
$stem = explode(",",$rij->stem);
foreach($stem AS $key => $value)
{
if(isset($stemmen[$key][$value]) == FALSE)
{
$stemmen[$key][$value] = 1;
}
else
{
$stemmen[$key][$value]++;
}
}
}
echo "<form action=\"" . $_SERVER["PHP_SELF"] . "\" method=\"post\">\n";
foreach($cfg["vragen"] AS $key => $value)
{
echo "<b>" . $cfg["vragen"][$key] . "</b><br>\n";
echo "<input type=\"radio\" name=\"stem[" . $key . "]\" value=\"1\">Yes (";
if(isset($stemmen[$key][1]) == FALSE)
{
echo "0";
}
else
{
echo $stemmen[$key][1];
}
echo " votes)<br>\n";
echo "<input type=\"radio\" name=\"stem[" . $key . "]\" value=\"0\">No (";
if(isset($stemmen[$key][0]) == FALSE)
{
echo "0";
}
else
{
echo $stemmen[$key][0];
}
echo " votes)<br>\n";
}
echo "<input type=\"submit\" value=\"Stem !\"></form>\n";
?>