Undskyld jeg fik ikke læst hele spm'et..
Først laver vi en tabel
create table vote_body (
id int(11) not null auto_increment, // ID'en på afstemningen
af int(11) not null, // bruger ID'et
vote0 char(255) not null, // Er spm'et
vote1 char(255) not null, // Er svar 1
vote2 char(255) not null, // Er svar 2
vote3 char(255) not null, // Er svar 3
vote4 char(255) not null, // Er svar 4
vote5 char(255) not null, // Er svar 5
vote6 char(255) not null, // Er svar 6
unique(id)
)
create table vote_svar (
id int(11) not null auto_increment,
af int(11) not null, // Den bruger der har stems ID
svar int(1) not null, // SVARET
til int(11) not null, // ID'en til afstemningen i vote_body
unique(id)
)
Nu har vi så lavet tabellen så skal vi oprette afstemningen.
opret.php
-------------------------------------
<?
// Link til database
// Denne side opretter en afstemning hvis brugerens ID, spm, svar1 og svar2 er der..
if (($af) && ($vote0) && ($vote1) && ($vote2)) {
echo "Din afstemning er nu oprettet!";
mysql_query("INSERT INTO vote_body (af,vote0,vote1,vote2,vote3,vote4,vote5,vote6) VALUES ('$af','$vote0','$vote1','$vote2','$vote3','$vote4','$vote5','$vote6')");
}
else {
?>
<form action="opret.php" method="post">
BRUGER ID: * <input name="af" type="text"><br>
Spørgsmål: * <input name="vote0" type="text"><br>
Svar 1: * <input name="vote1" type="text"><br>
Svar 2: * <input name="vote2" type="text"><br>
Svar 3: <input name="vote3" type="text"><br>
Svar 4: <input name="vote4" type="text"><br>
Svar 5: <input name="vote5" type="text"><br>
Svar 6: <input name="vote6" type="text"><br>
* skal udfyldes.<br>
<input type="submit" value="Opret afstemning">
</form>
<?
}
?>
vis.php
--------------------------------------
<?
// Link til database
// Denne side Viser hvilke(n) afstemning(er) brugeren har oprettet! Eller en bruger får lov til at stemme
// Den enkle bruger bestemmes ud fra $brugerid
if ($action=='stem') {
if ($vote) {
echo "Tak for din stemme!";
mysql_query("INSERT INTO vote_svar (af,svar,til) VALUES ('$brugerid','$vote','$id')");
}
}
else {
$query = mysql_query("SELECT * FORM vote_body WHERE af = '$brugerid'");
while($row = mysql_fetch_array($query)) {
?>
<form action="vis.php?brugerid=<? echo $brugerid; ?>&action=stem&id=<? echo $row[id]; ?>" method="post">
<table>
<tr>
<td colspan="2"><b><? echo $row[vote0]; ?></b></td>
</tr>
<tr>
<td><input name="vote" value="1" type="radio"></td>
<td><? echo $row[vote1]; ?></td>
</tr>
<tr>
<td><input name="vote" value="2" type="radio"></td>
<td><? echo $row[vote2]; ?></td>
</tr>
<? if ($row[vote3]) { ?>
<tr>
<td><input name="vote" value="3" type="radio"></td>
<td><? echo $row[vote3]; ?></td>
</tr>
<? } if ($row[vote4]) { ?>
<tr>
<td><input name="vote" value="4" type="radio"></td>
<td><? echo $row[vote4]; ?></td>
</tr>
<? } if ($row[vote5]) { ?>
<tr>
<td><input name="vote" value="5" type="radio"></td>
<td><? echo $row[vote5]; ?></td>
</tr>
<? } if ($row[vote6]) { ?>
<tr>
<td><input name="vote" value="6" type="radio"></td>
<td><? echo $row[vote6]; ?></td>
</tr>
<? } ?>
</table>
</form>
<?
}
}
?>
result.php
---------------------------------------
<?
// Link til database
// Her udskriver vi resultatet af en bestemt afstemning bestemt af id
$query = mysql_query("SELECT * FORM vote_body WHERE id = '$id'");
while($row = mysql_fetch_array($query)) {
$antal = mysql_num_row($query);
// UDREGN - her finder vi ud af hvor mange svar de forskellige spm har fået..
$vote1q = mysql_query("SELECT * FORM vote_body WHERE id = '$id' AND svar = 1");
$vote1a = mysql_num_row($vote1q);
$vote2q = mysql_query("SELECT * FORM vote_body WHERE id = '$id' AND svar = 2");
$vote2a = mysql_num_row($vote1q);
if ($row[vote3]) {
$vote2q = mysql_query("SELECT * FORM vote_body WHERE id = '$id' AND svar = 3");
$vote2a = mysql_num_row($vote1q);
}
if ($row[vote4]) {
$vote2q = mysql_query("SELECT * FORM vote_body WHERE id = '$id' AND svar = 4");
$vote2a = mysql_num_row($vote1q);
}
if ($row[vote5]) {
$vote2q = mysql_query("SELECT * FORM vote_body WHERE id = '$id' AND svar = 5");
$vote2a = mysql_num_row($vote1q);
}
if ($row[vote6]) {
$vote2q = mysql_query("SELECT * FORM vote_body WHERE id = '$id' AND svar = 6");
$vote2a = mysql_num_row($vote1q);
}
// SLUT UDREGN
// Antal max bredte på baurometerne
// Valg1 _____| 25%
// Valg2 _________| 50%
// Valg3 __| 10%
// Valg4 ___| 15%
$maxwidth = 200;
?>
<table>
<tr>
<td colspan="2"><b><? echo $row[vote0]; ?></b></td>
</tr>
<tr>
<td><? echo $row[vote1]; ?></td>
<td><img src="dot.gif" width="<? echo round($maxwidth / $antal * $vote1a); ?>"><? echo round($maxwidth / $antal * $vote1a); ?></td>
</tr>
<tr>
<td><? echo $row[vote2]; ?></td>
<td><img src="dot.gif" width="<? echo round($maxwidth / $antal * $vote2a); ?>"><? echo round($maxwidth / $antal * $vote2a); ?></td>
</tr>
<? if ($row[vote3]) { ?>
<tr>
<td><? echo $row[vote3]; ?></td>
<td><img src="dot.gif" width="<? echo round($maxwidth / $antal * $vote3a); ?>"><? echo round($maxwidth / $antal * $vote3a); ?></td>
</tr>
<? } if ($row[vote4]) { ?>
<tr>
<td><? echo $row[vote4]; ?></td>
<td><img src="dot.gif" width="<? echo round($maxwidth / $antal * $vote4a); ?>"><? echo round($maxwidth / $antal * $vote4a); ?></td>
</tr>
<? } if ($row[vote5]) { ?>
<tr>
<td><? echo $row[vote5]; ?></td>
<td><img src="dot.gif" width="<? echo round($maxwidth / $antal * $vote5a); ?>"><? echo round($maxwidth / $antal * $vote5a); ?></td>
</tr>
<? } if ($row[vote6]) { ?>
<tr>
<td><? echo $row[vote6]; ?></td>
<td><img src="dot.gif" width="<? echo round($maxwidth / $antal * $vote6a); ?>"><? echo round($maxwidth / $antal * $vote6a); ?></td>
</tr>
<? } ?>
</table>
<?
}
?>
