[Sleepy]

Ich weiß nicht :) wie gesagt ich bin noch anfänger.

so siehts jetzt komplett aus:

PHP-Code:

<a href="admin.php" title="test">admin</a>
<a href="eintragen.php" title="test">Eintragen</a>
<br>
    <?
        if ($_GET['do'] == 'logout') {
            session_destroy();
            session_unset();
            echo '<meta http-equiv="refresh" content="0; url=index.php" />';
        }
    ?>
<table border="1">
<tr>
<th>
<table border="1">
<tr>
<th><a href="<? echo $_SERVER['PHP_SELF']; ?>?action=add&amp;SID=<? echo $sid; ?>" title="Neuen Eintrag hinzuf&uuml;gen">Neuer Eintrag</a></th>

</tr>
<tr>
<td><a href="<? echo $_SERVER['PHP_SELF']; ?>?action=edit&amp;SID=<? echo $sid; ?>" title="Eintrag bearbeiten">Eintrag bearbeiten</a></td>
</tr>
<tr>
<td><a href="<? echo $_SERVER['PHP_SELF']; ?>?action=delete&amp;SID=<? echo $sid; ?>" title="Eintrag l&ouml;schen">Eintrag l&ouml;schen</a></td>
</tr>
</table>
</th>
<th>
<?
                require ('conf.php');
                mysql_connect($host, $user, $pass);
                mysql_select_db($db);

                switch ($_GET['action']) {

                    case 'add':
                    ?>


                        <h3>Admin Bereich</h3>
                        <p>Trage hier Titel und Inhalt ein.</p>
                        <form name="add" action="<? echo $_SERVER['PHP_SELF']; ?>?action=add_entry&amp;SID=<? echo $sid; ?>" method="post">
                            <div class="form">
                                                         <table border="1">
                                                         <tr>
                                                                <th><label for="tag">Tag</label><br /><input id="tag" type="text" name="tag" tabindex="1" /></th>
                                                                <th><label for="date">Datum</label><br /><input id="date" type="text" name="date" tabindex="1" /></th>
                                   <th><label for="veranstaltung">Veranstaltung</label><br /><input id="veranstaltung" type="text" name="veranstaltung" tabindex="1" /></th>
                                                                 <th><label for="tag">Ort</label><br /><input id="ort" type="ort" name="ort" tabindex="1" /></th>
                                                          </tr>
                                                          </table>
                            </div>
                            <input id="submit" type="submit" name="submit_add" value="FAQ anlegen" tabindex="1" />
                        </form>
                    <?
                    break;

                    case 'add_entry':
                                             $datum = date("Y-m-d", mktime(0,0,0,$monat,$tag,$jahr));
                        $sql = mysql_query("INSERT INTO ".$prefix."faq
                                            (id, veranstaltung, date, tag, ort, author, timestamp)
                                        VALUES  ('$datum');
                                            (''

                                                                                         , '".trim(strip_tags(htmlentities($_POST['veranstaltung'])))."'
                                                                                         , '".trim(strip_tags(htmlentities($_POST['date'])))."'
                                                                                         , '".trim(strip_tags(htmlentities($_POST['tag'])))."'
                                                                                          , '".trim(strip_tags(htmlentities($_POST['ort'])))."'

                                                                                         , '".$_SESSION['loginname']."', '".time()."') ") or die(mysql_error());
                        if ($sql) echo '<p>Eintrag wurde erfolgreich in die Datenbank aufgenommen</p>';
                    break;

                    case 'edit':
                        if ($_GET['id']) {
                            $sql = mysql_query("SELECT vorname, content FROM ".$prefix."faq WHERE id = '".$_GET['id']."'") or die(mysql_error());
                            $row = mysql_fetch_object($sql);
                            ?>
                            <form action="<? echo $_SERVER['PHP_SELF']; ?>?action=edit_entry&amp;SID=<? echo $sid; ?>" method="post">
                                <div class="form">
                                    <label for="Eintrag">Titel:</label><br /><input id="Eintrag" type="text" name="vorname" value="<? echo $row->title; ?>" tabindex="1" /><br />
                                    <label for="Inhalt">Inhalt:</label><br /><textarea id="Inhalt" name="content" rows="5" cols="35" tabindex="2"><? echo $row->content; ?></textarea>
                                </div>
                                <input type="submit" name="submit" value="bearbeiten" tabindex="3" />
                                <input type="hidden" name="id" value="<? echo $_GET['id']; ?>" />
                            </form>
                            <?
                        } else {
                            ?>
                            <h3>F.A.Q. Eintrag bearbeiten</h3>
                            <p>Tippfehler entdeckt? ...</p>
                            <div class="form">
                                <?
                                $get = mysql_query("SELECT id, title FROM ".$prefix."faq") or die(mysql_error());

                                while ($row = mysql_fetch_object($get)) {
                                    echo '    Eintrag: <a href="'.$_SERVER['PHP_SELF'].'?action=edit&amp;id='.$row->id.'&amp;SID='.$sid.'" title="Hier klicken um den Eintrag zu &auml;ndern">'.$row->title.'</a><br />';
                                }
                                ?>
                            </div>
                            <?
                        }
                    break;

                    case 'edit_entry':
                        if (isset($_POST['submit'])) {
                            $sql = mysql_query("UPDATE ".$prefix."faq
                                                    SET
                                                        title        = '".strip_tags(trim(htmlentities($_POST['title'])))."',
                                                        content        = '".strip_tags(trim(htmlentities($_POST['content'])))."',
                                                        author        = '".$_SESSION['loginname']."',
                                                        timestamp    = '".time()."'
                                                    WHERE
                                                        id = '".$_POST['id']."'") or die(mysql_error());
                            if ($sql) echo '<p>Der F.A.Q. Eintrag wurde erfolgreich ge&auml;ndert.</p>';
                        }
                    break;

                                         case 'delete':
                    ?>
                        <h3>F.A.Q. Eintrag l&ouml;schen</h3>
                        <p>Um einen Eintrag zu entfernen, bitte auf den jeweiligen Link klicken.</p>
                        <div class="form">
                        <?
                            $get = mysql_query("SELECT id, veranstaltung, tag,ort FROM ".$prefix."faq") or die(mysql_error());

                            while ($row = mysql_fetch_object($get)) {
                                $_SESSION['veranstaltung']    = $row->veranstaltung;
                                echo '<label>F.A.Q.:</label><a href="'.$_SERVER['PHP_SELF'].'?action=delete_entry&amp;id='.$row->id.'&amp;SID='.$sid.'" title="Hier klicken um diesen Eintrag zu entfernen">'.$row->veranstaltung.'</a><br />';
                            }
                        ?>
                        </div>
                        <?
                    break;

                    case 'delete_entry':
                        if ($_GET['id']) {
                            $sql = mysql_query("DELETE FROM ".$prefix."faq WHERE id = '".$_GET['id']."'") or die(mysql_error());
                            if ($sql) echo 'Eintrag &raquo;<strong>'.$_SESSION['title'].'</strong>&laquo; wurder erfolgreich aus der Datenbank entfernt';
                        }
                    break;
                }
            ?>

</th>
</tr>
</table>

  <?
                $sql = mysql_query("SELECT veranstaltung, tag, date, ort FROM ".$prefix."faq") or die(mysql_error());
                                 while ($row = mysql_fetch_array($sql)) {

                                  echo "<table>";
                                 echo "<tr><td>Tag</td><td>Datum</td><td>Veranstaltung</td><td>Ort</td></tr>";
                echo "<tr><td>" . $row['tag'] . "</td><td>" . $row['date'] . "</td><td>" . $row['veranstaltung'] . "</td><td>" . $row['ort'] . "</td></tr>";
                echo "</table>"
;#
     }


            ?>



</body>
</html>