Code: Select all
<?php
error_reporting(E_ALL);
include("connect.php");
?>
<HTML>
<HEAD>
<TITLE>Lägga till en ny vote</TITLE>
</HEAD>
<BODY>
<?php
if(isset($_POST['starta'])) {
$count = "SELECT * FROM vote WHERE status=1";
$ip = GetHostByName($REMOTE_ADDR);
$query = mysql_query($count) or die(mysql_error());
if (mysql_result ($count , 0) > 0)
{
mysql_query("UPDATE vote SET status='0' WHERE status='1'");
echo "<a href='laggtill.php'>Prova igen</a>";
} else {
$insert = "INSERT INTO vote (fraga, ip, status) VALUES ('$_POST[fraga]', '$ip', '1')";
$klart = mysql_query($insert) or die(mysql_error());
$id = "select voteid from vote where status='1'";
$faid = mysql_query($id) or die(mysql_error());
if($_POST['alternativ1'] != "") {
$alternativ1 = "insert into fragealternativ (voteid, svarfraga) VALUES ('$faid', '$_POST[alternativ1]')";
$mysqlalternativ1 = mysql_query($alternativ1) or die(mysql_error());
echo "Alternativ 1 är tillagd......<br>";
}
if($_POST['alternativ2'] != "") {
$alternativ2 = "insert into fragealternativ (voteid, svarfraga) VALUES ('$faid', '$_POST[alternativ2]')";
$mysqlalternativ2 = mysql_query($alternativ2) or die(mysql_error());
echo "Alternativ 2 är tillagd......<br>";
}
if($_POST['alternativ3'] != "") {
$alternativ3 = "insert into fragealternativ (voteid, svarfraga) VALUES ('$faid', '$_POST[alternativ3]')";
$mysqlalternativ3 = mysql_query($alternativ3) or die(mysql_error());
echo "Alternativ 3 är tillagd......<br>";
}
if($_POST['alternativ4'] != "") {
$alternativ4 = "insert into fragealternativ (voteid, svarfraga) VALUES ('$faid', '$_POST[alternativ4]')";
$mysqlalternativ4 = mysql_query($alternativ4) or die(mysql_error());
echo "Alternativ 4 är tillagd......<br>";
}
if($_POST['alternativ5'] != "") {
$alternativ5 = "insert into fragealternativ (voteid, svarfraga) VALUES ('$faid', '$_POST[alternativ5]')";
$mysqlalternativ5 = mysql_query($alternativ5) or die(mysql_error());
echo "Alternativ 5 är tillagd......<br>";
}
}
echo "<form action='laggtill.php' method='POST'>";
echo "Fråga: <INPUT TYPE='text' name='fraga'><br>";
echo "Svar 1: <INPUT TYPE='text' name='alternativ1'><br>";
echo "Svar 2: <INPUT TYPE='text' name='alternativ'><br>";
echo "Svar 3: <INPUT TYPE='text' name='alternativ'><br>";
echo "Svar 4: <INPUT TYPE='text' name='alternativ'><br>";
echo "Svar 5: <INPUT TYPE='text' name='alternativ'><br>";
echo "<input type='submit' name='starta' value='Starta fråga'>";
echo "</form>";
}
?>
</BODY>
</HTML>Lina 61:
Code: Select all
</BODY>Thanks