20. februar 2002 - 22:52
#4
Jeg har lavet et link til den poll.
Men hvis i vil have det
poll.php
<?PHP
include("db.php");
$table = "poll"; // mySQL Tabel navn
$table_spm = "poll_spm"; // mySQL Spm tabel navn
$sql = "SELECT * FROM $table_spm ORDER BY ID DESC LIMIT 0,1";
$result = mysql_query($sql);
$row = mysql_fetch_array ($result);
echo "<form method='post' action='$PHP_SELF'>\n";
echo "<b>$row[1]</b>";
echo "<br><br>";
$sql = "SELECT * FROM $table ORDER BY ID DESC LIMIT 0,1";
$result2 = mysql_query($sql);
$row2 = mysql_fetch_array ($result2);
if ($stem || $har_stemt == $spm ||$vis_resultat) {
//Tæller svarmulighederne op
for ($i=2; $i<=8; $i++) {
if ($row[$i] != '') {
$antalspm = $antalspm + 1;
$procent1[] = $row2[$i-1];
$rialt = $rialt + $row2[$i-1];
$udskriv1[] = "$row[$i]<br><img src=\"billeder/bar_end.gif\" width=\"1\" height=\"10\" alt=\"\" border=\"0\"><img src='billeder/bar.gif' width='";
$udskriv2[] = "' height='10'><img src=\"billeder/bar_end.gif\" width=\"1\" height=\"10\" alt=\"\" border=\"0\"> ";
}
}
$antalspm = $antalspm - 1;
for ($i=0; $i<=sizeof($udskriv1) - 1; $i++) {
$procent[$i] = $procent1[$i] / $rialt * 100;
$procent[$i] = round($procent[$i]);
$slutudskriv[$i] = $udskriv1[$i] . $procent[$i] . $udskriv2[$i] . $procent[$i] . " %<br><br>";
echo $slutudskriv[$i];
}
echo "Stemmer: $rialt ialt<br>";
} else {
//Udskrive stemmeformen
for ($i=2; $i<=8; $i++) {
if ($row[$i] != '') {
$antalspm = $antalspm + 1;
$procent1[] = $row2[$i-1];
$rialt = $rialt + $row2[$i-1];
echo "<input type='radio' style='background-color : #DEE3EF;' name='stem' value='$i'>$row[$i]\n";
echo "<br>";
}
}
echo "<br><input type='image' border='0' title='Stem' alt='Stem' src='billeder/vote.gif' name='Stem'> <a href=\"?vis_resultat=ja\"><img src=\"billeder/vis_resultat.gif\" width=\"78\" height=\"15\" alt=\"\" border=\"0\"></a>";
}
echo "</form>\n";
echo "<a href=\"polls.php\">Tidligere afstemninger</a>";
//
?>
polls.php
<?PHP
include("db.php");
?><br>
<a href="polls.php">Vis oversigt</a><br><br>
<B>Tidligere afstemninger</B><BR>
Her er de tidligere afstemninger, klik på dem for at se svarene:<br><br>
<?PHP
if($id) {
$polltable = "poll"; // mySQL Tabel navn
$polltable_spm = "poll_spm"; // mySQL Spm tabel navn
$pollsql = "SELECT * FROM $polltable_spm WHERE ID = $id";
$pollresult = mysql_query($pollsql);
$pollrow = mysql_fetch_array ($pollresult);
echo "<b>$pollrow[1]</b>";
echo "<br><br>";
$pollsql = "SELECT * FROM $polltable WHERE ID = $id";
$pollresult2 = mysql_query($pollsql);
$pollrow2 = mysql_fetch_array ($pollresult2);
//Tæller svarmulighederne op
for ($polli=2; $polli<=8; $polli++) {
if ($pollrow[$polli] != '') {
$pollantalspm = $pollantalspm + 1;
$pollprocent1[] = $pollrow2[$polli-1];
$pollrialt = $pollrialt + $pollrow2[$polli-1];
$polludskriv1[] = "$pollrow[$polli]<br><img src=\"billeder/bar_end.gif\" width=\"1\" height=\"10\" alt=\"\" border=\"0\"><img src='billeder/bar.gif' width='";
$polludskriv2[] = "' height='10'><img src=\"billeder/bar_end.gif\" width=\"1\" height=\"10\" alt=\"\" border=\"0\"> ";
}
}
$pollantalspm = $pollantalspm - 1;
for ($polli=0; $polli<=sizeof($polludskriv1) - 1; $polli++) {
$pollprocent[$polli] = $pollprocent1[$polli] / $pollrialt * 100;
$pollprocent[$polli] = round($pollprocent[$polli]);
$pollslutudskriv[$polli] = $polludskriv1[$polli] . $pollprocent[$polli] . $polludskriv2[$polli] . $pollprocent[$polli] . " %<br><br>";
echo $pollslutudskriv[$polli];
}
echo "Stemmer: $pollrialt ialt<br>";
} else {
$pollquery = mysql_query("SELECT * FROM poll_spm ORDER BY ID DESC LIMIT 1, 20") or die(mysql_error());
if (!mysql_num_rows($pollquery)) {
echo "Intet fundet.\n";
}
while($pollrow = mysql_fetch_array($pollquery)){
$pollresult = mysql_query("SELECT * FROM poll_spm WHERE ID = $pollrow[ID]");
$pollmyrow = mysql_fetch_array ($pollresult);
$pollspm = $pollmyrow[spm]; // Afstemnings spørgsmål
echo "<a href=\"?id=$pollmyrow[ID]\">$pollspm</a><br>";
}
}
?>
<br>Har du en ide til en god afstemning så send en mail til <a href="mailto:mj@divxit.dk">mj@divxit.dk</a>
db.php
<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
global $dbhost, $dbuser, $dbpass;
$dbcnx = @mysql_connect($dbhost, $dbuser, $dbpass) or die ("Databasen lader til at være nede.");
if (!@mysql_SELECT_db("poll")) {
die ("Databasen er ikke tilgængelig.");
}
?>
admin.php
<?PHP
if ($status == 'gem') {
$sql = "INSERT INTO poll (stem1, stem2, stem3, stem4, stem5, stem6, stem7, stem8) VALUES ('1', '0', '0', '0', '0', '0', '0', '0')";
mysql_query($sql);
$sql = "INSERT INTO poll_spm (spm, stem1, stem2, stem3, stem4, stem5, stem6, stem7, stem8) VALUES ('$nyt_spm', '$svar1', '$svar2', '$svar3', '$svar4', '$svar5', '$svar6', '$svar7', '$svar8')";
echo $sql;
mysql_query($sql);
echo "Afstemning oprettet!";
} else {
?>
<table width="100%" cellspacing="1" cellpadding="1" border="0">
<form name="form" method="post" action="admin.php">
<input name="status" type="hidden" value="gem">
<tr>
<td align=right>Spørgsmål: </td><td width="100%"><input name="Virker det ?" class="text" type="text" size="40"></td>
</tr>
<tr>
<td align=right>Svar 1: </td><td><input name="svar1" class="text" type="Ja" size="40"></td>
</tr>
<tr>
<td align=right>Svar 2: </td><td><input name="svar2" class="text" type="Nej" size="40"></td>
</tr>
<tr>
<td align=right>Svar 3: </td><td><input name="svar3" class="text" type="Hvad fanden snakker han om ?" size="40"></td>
</tr>
<tr>
<td align=right>Svar 4: </td><td><input name="svar4" class="text" type="text" size="40"></td>
</tr>
<tr>
<td align=right>Svar 5: </td><td><input name="svar5" class="text" type="text" size="40"></td>
</tr>
<tr>
<td align=right>Svar 6: </td><td><input name="svar6" class="text" type="text" size="40"></td>
</tr>
<tr>
<td align=right>Svar 7: </td><td><input name="svar7" class="text" type="text" size="40"></td>
</tr>
<tr>
<td align=right>Svar 8: </td><td><input name="svar8" class="text" type="text" size="40"></td>
</tr>
<tr><td align=right colspan=2><input type="image" src="../billeder/opret.gif" border="0" alt="Opret" name="opret">
</td>
</tr>
</form>
</table>
<?PHP
}
?>
Så er der også det i MySQL databasen
#
# Struktur dump for tabellen `poll`
#
CREATE TABLE poll (
ID int(11) NOT NULL auto_increment,
stem1 int(11) NOT NULL default '0',
stem2 int(11) NOT NULL default '0',
stem3 int(11) NOT NULL default '0',
stem4 int(11) NOT NULL default '0',
stem5 int(11) NOT NULL default '0',
stem6 int(11) NOT NULL default '0',
stem7 int(11) NOT NULL default '0',
stem8 int(11) NOT NULL default '0',
PRIMARY KEY (ID),
KEY ID (ID)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `poll_spm`
#
CREATE TABLE poll_spm (
ID int(11) NOT NULL auto_increment,
spm text NOT NULL,
stem1 text NOT NULL,
stem2 text NOT NULL,
stem3 text NOT NULL,
stem4 text NOT NULL,
stem5 text NOT NULL,
stem6 text NOT NULL,
stem7 text NOT NULL,
stem8 text NOT NULL,
PRIMARY KEY (ID),
KEY ID (ID)
) TYPE=MyISAM;
Det skulle være det hele.