Avatar billede zeldo Nybegynder
30. august 2002 - 23:30 Der er 1 kommentar og
1 løsning

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">&nbsp;&nbsp;<input type="submit" value="Login">
            </form>
        <?
    }
?>
      </td>
    </tr>
  </table>
</center>
</div>
Avatar billede jakoba Nybegynder
30. august 2002 - 23:52 #1
enhver <form kommando har en attrubut der hedder 'action' så det navn er brugt og bør ikke bruges igen som navn på et felt i formen. Kald feltet noget andet.
Avatar billede zeldo Nybegynder
01. september 2002 - 08:37 #2
Har løst det på anden måde...
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester