Hvorfor viser tilføjer den ikke til databasen ?
Jeg er desværre nød til at poste hele koden.. da jeg ikke er istand til at fortælle hvor henne af fejlen ligeger:Men jeg skal have den til at tilføje det jeg indtaster, i databasen.
<div align="center">
<center>
<table width="350" align="center" border="0">
<tr>
<td>
<?
// echo '$_POST["action"] = ' . $_POST["action"] . '<br>';
// echo '$_POST["pass"] = ' . $_POST["pass"] . '<br>';
if ($_POST["action"] == "login"){
$pass = $_POST["pass"];
} elseif ($_POST["action"] == "addmatch") {
$pass = $_SESSION["pass"];
$date = $_POST["date"];
$runde = $_POST["runde"];
$kick_off = $_POST["kick_off"];
$hometeam = $_POST["hometeam"];
$awayteam = $_POST["awayteam"];
$homegoal = $_POST["homegoal"];
$awaygoal = $_POST["awaygoal"];
$goals = $_POST["goals"];
$referee = $_POST["referee"];
$attendance = $_POST["attendance"];
$yellow_cards = $_POST["yellow_cards"];
$red_cards = $_POST["red_cards"];
$homelineup = $_POST["homelineup"];
$homelineup = $_POST["awaylineup"];
$homesub = $_POST["homesub"];
$homesub = $_POST["awaysub"];
mysql_query("INSERT INTO matches (date, runde, kick_off, hometeam, awayteam, homegoal, awaygoal, goals, referee, attendance, yellow_cards, red_cards, homelineup, awaylineup, homesub, awaysub) VALUES (" . $date . ", " . $runde . ", " . $kick_off . ", '" . $hometeam . "', '" . $awayteam . "', " . $homegoal . ", " . $awaygoal . ", '" . $goals . "', '" . $referee . "', " . $attendance . ", '" . $yellow_cards . "', '" . $red_cards . "', " . $homelineup . ", " . $awaylineup . ", '" . $homesub . "', '" . $awaysub . "')") or die(mysql_error());
echo "<font face=\"verdana\" size=\"1\" color=\"FFFFFF\">Kampen blev tilføjet</font>";
} elseif ($_POST["action"] == "editmatch") {
$pass = $_SESSION["pass"];
$date = $_POST["date"];
$runde = $_POST["runde"];
$kick_off = $_POST["kick_off"];
$hometeam = $_POST["hometeam"];
$awayteam = $_POST["awayteam"];
$homegoal = $_POST["homegoal"];
$awaygoal = $_POST["awaygoal"];
$goals = $_POST["goals"];
$referee = $_POST["referee"];
$attendance = $_POST["attendance"];
$yellow_cards = $_POST["yellow_cards"];
$red_cards = $_POST["red_cards"];
$homelineup = $_POST["homelineup"];
$homelineup = $_POST["awaylineup"];
$homesub = $_POST["homesub"];
$homesub = $_POST["awaysub"];
$matchid = $_POST["matchid"];
mysql_query("UPDATE matches SET date='$date', runde='$runde', kick_off='$kick_off', hometeam='$hometeam', awayteam='$awayteam', homegoal='$homegoal', awaygoal='$awaygoal', goals='$goals', referee='$referee', attendance='$attendance', yellow_cards='$yellow_cards', red_cards='$red_cards', homelineup='$homelineup', awaylineup='$awaylineup', homesub='$homesub', awaysub='$awaysub' WHERE matchid = $matchid") or die(mysql_error());
$_GET["action"] = "";
echo "<font face=\"verdana\" size=\"1\" color=\"FFFFFF\">Kampen blev ændret!</font>";
} else {
$pass = $_SESSION["pass"];
}
if ($pass == "nbdk3107"){
session_register("pass");
if ($_GET["action"] == "edit"){
$matchid = $_GET["matchid"];
$result = mysql_query("SELECT * FROM matches WHERE matchid = $matchid");
$row = mysql_fetch_array($result);
?>
<form action="<?=$_SERVER["REQUEST_URI"]?>" method="post">
<input type="hidden" name="action" value="editmatch">
<input type="hidden" name="matchid" value="<?=$matchid?>">
<font face="verdana" size="1" color="FFFFFF">Kamptidspunkt:</font><br>
<input type="text" name="date" value="<?=$row["date"]?>"><br>
<font face="verdana" size="1" color="FFFFFF">Kick Off:</font><br>
<input type="text" name="kick_off" value="<?=$row["kick_off"]?>"><br>
<font face="verdana" size="1" color="FFFFFF">Runde nr:</font><br>
<input type="text" name="runde" value="<?=$row["runde"]?>"><br>
<font face="verdana" size="1" color="FFFFFF">Kamp</font><br>
<textarea cols="15" rows="1" name="hometeam"><?=$row["hometeam"]?></textarea>
<font face="verdana" size="1" color="FFFFFF">-</font>
<textarea cols="15" rows="1" name="awayteam"><?=$row["awayteam"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">resultat:</font>
<textarea cols="2" rows="1" name="homegoal"><?=$row["homegoal"]?></textarea>
<font face="verdana" size="1" color="FFFFFF">-</font>
<textarea cols="2" rows="1" name="awaygoal"><?=$row["awaygoal"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Mål</font><br>
<textarea cols="35" rows="10" name="goals"><?=$row["goals"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Tilskuer:</font>
<textarea cols="20" rows="1" name="attendance"><?=$row["attendance"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">referee:</font>
<textarea cols="35" rows="1" name="referee"><?=$row["referee"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Gule kort</font><br>
<textarea cols="35" rows="7" name="yellow_cards"><?=$row["yellow_cards"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Røde Kort</font><br>
<textarea cols="35" rows="4" name="red_cards"><?=$row["red_cards"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Hjemmehold startopstilling:</font><br>
<textarea cols="35" rows="16" name="homelineup"><?=$row["homelineup"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Hjemmehold udskiftninger:</font><br>
<textarea cols="35" rows="4" name="homesub"><?=$row["homesub"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">udehold startopstilling:</font><br>
<textarea cols="35" rows="16" name="awaylineup"><?=$row["awaylineup"]?></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Udehold udskiftninger:</font><br>
<textarea cols="35" rows="4" name="awaysub"><?=$row["awaysub"]?></textarea><br>
<input type="submit" value="Rediger Resultat!">
</form>
<?
} else {
?>
<form action="<?=$_SERVER["REQUEST_URI"]?>" method="post">
<input type="hidden" name="action" value="addmatch">
<input type="hidden" name="matchid" value="<?=$matchid?>">
<font face="verdana" size="1" color="FFFFFF">Kamptidspunkt:</font><br>
<input type="text" name="date"><br>
<font face="verdana" size="1" color="FFFFFF">Kick OFF:</font><br>
<input type="text" name="kick_off"><br>
<font face="verdana" size="1" color="FFFFFF">Runde nr:</font><br>
<input type="text" name="runde"><br>
<font face="verdana" size="1" color="FFFFFF">Kamp</font><br>
<textarea cols="15" rows="1" name="hometeam"></textarea>
<font face="verdana" size="1" color="FFFFFF">-</font>
<textarea cols="15" rows="1" name="awayteam"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">resultat:</font><br>
<textarea cols="2" rows="1" name="homegoal"></textarea>
<font face="verdana" size="1" color="FFFFFF">-</font>
<textarea cols="2" rows="1" name="awaygoal"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Mål</font><br>
<textarea cols="35" rows="10" name="goals"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">tilskuer:</font>
<textarea cols="20" rows="1" name="attendance"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">referee:</font>
<textarea cols="35" rows="1" name="referee"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Gule kort</font><br>
<textarea cols="35" rows="7" name="yellow_cards"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Røde Kort</font><br>
<textarea cols="35" rows="4" name="red_cards"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Hjemmehold startopstilling:</font><br>
<textarea cols="35" rows="16" name="homelineup"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Hjemmehold udskiftninger:</font><br>
<textarea cols="35" rows="4" name="homesub"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">udehold startopstilling:</font><br>
<textarea cols="35" rows="16" name="awaylineup"></textarea><br>
<font face="verdana" size="1" color="FFFFFF">Udehold udskiftninger:</font><br>
<textarea cols="35" rows="4" name="awaysub"></textarea><br>
<input type="submit" value="Tilføj kamp">
</form>
<?
}
echo "<font face=\"verdana\" color=\"#FFFFFF\" size=\"1\">ændre Kampen!<br></font>";
echo "<table>";
$result = mysql_query("SELECT * FROM matches ORDER BY runde DESC");
if (mysql_num_rows($result) > 0){
while ($row = mysql_fetch_array($result)){
echo "<tr><td style=\"border-bottom: 1px dashed white;\"><a href=\"index.php?midten=matchadmin.php&action=edit&id=" . $row["matchid"] . "\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["runde"] . "</font></a></td><td style=\"border-bottom: 1px dashed white;\" width=\"70\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["hometeam"] . "</font></td><td style=\"border-bottom: 1px dashed white;\" width=\"10\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">-</font></td><td style=\"border-bottom: 1px dashed white;\" width=\"70\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["awayteam"] . "</font></td><td style=\"border-bottom: 1px dashed white;\" width=\"20\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["homegoal"] . "</font></td><td style=\"border-bottom: 1px dashed white;\" width=\"10\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">-</font></td><td style=\"border-bottom: 1px dashed white;\" width=\"20\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["awaygoal"] . "</font></td></tr>";
}
} else {
echo "<font face=\"verdana\" color=\"#FFFFFF\" size=\"1\">Vores server er desværre nede i Øjeblikket!!</a>";
}
echo "</table>";
} else {
?>
<form action="<?=$_SERVER["REQUEST_URI"]?>" method="post">
<input type="hidden" name="action" value="login">
<font face="verdana" size="1" color="FFFFFF">Indtast adgangskode:</font><br>
<input type="password" name="pass"> <input type="submit" value="Login">
</form>
<?
}
?>
</td>
</tr>
</table>
</center>
</div>
