Subversion-Projekte lars-tiefland.php_share

<?
        if ($_POST[action])
        {
                $required = array
                                        (
                                                "Name",
                                                "mail",
                                                "homepage",
                                                "Stadt",
                                                "Bundesland",
                                                "Staat",
                                                "text"
                                        );
                                        
                $transportArray = array();
                $error = array();
                foreach($required as $key)
                {
                        if (!$_POST[$key]) { $error[] = $key; }
                        $transportArray[] = $key."=".urlencode($_POST[$key]);
                }
                $transportArray[] = "error=".implode(";",$error);

                if ($error == true)
                {
                        header("Location: gaestebuchinput.htm?".implode("&",$transportArray));
                        exit;
                }

                $query="
                        insert into gaestebuch_eintraege
                        (
                                site,
                                Name,
                                mail,
                                homepage,
                                Stadt,
                                Bundesland,
                                Staat,
                                headline,
                                text,
                                erstellt_am,
                                erstellt_von,
                                letzte_Aenderung_am,
                                letzte_Aenderung_von
                        )
                        values
                        (
                                'mediaran.de',
                                '$_POST[Name]',
                                '$_POST[mail]',
                                '$_POST[homepage]',
                                '$_POST[Stadt]',
                                '$_POST[Bundesland]',
                                '$_POST[Staat]',
                                '$_POST[headline]',
                                '$_POST[text]',
                                NOW(),
                                'Webinterface',
                                NOW(),
                                'Webinterface'
                        )
                ";
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
        }

        $query="
                SELECT
                        *,
                        DATE_FORMAT(erstellt_am, '%d.%m.%Y') as Datum
                FROM
                        gaestebuch_eintraege
                WHERE
                        site='mediaran.de'
                ORDER BY
                        erstellt_am desc";
        $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
?> 
<div class=whiteBox style="padding:3px"> 
  <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
    <tr> 
      <td class="tablecolor2"> 
        <center>
          <a href="gaestebuchinput.htm"><strong>Neueintrag</strong></a> 
        </center>
      </td>
    </tr>
  </table>
</div>
<?
        while ($zeile=mysql_fetch_array($result))
        {
?>
<div class=whiteBox style="padding:3px"> 
  <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
    <tr> 
      <td nowrap><?=$zeile[headline];?></td>
      <td align="right"><?=$zeile[Datum];?></td>
    </tr>
    <tr> 
      <td colspan="2"> 
        <? if ($zeile[mail]) { echo "<a href=\"mailto:$zeile[mail]\">$zeile[Name]</a>"; } else { echo $zeile[Name]; } ?>
        &nbsp; 
        <? if ($zeile[homepage]) { echo "<a href=\"$zeile[homepage]\" target=\"_blank\">$zeile[homepage]</a>"; } ?>
      </td>
    </tr>
    <tr> 
      <td colspan="2">
        <?=$zeile[Stadt]; ?>
        <?=$zeile[Bundesland]; ?>
        <?=$zeile[Staat]; ?>
      </td>
    </tr>
    <tr> 
      <td colspan="2">&nbsp;</td>
    </tr>
    <tr> 
      <td colspan="2">
        <?=nl2br($zeile[text]); ?>
      </td>
    </tr>
  </table>
</div>
<?
        }
?>
<div class=whiteBox style="padding:3px"> 
  <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
    <tr> 
      <td class="tablecolor2"> 
        <center>
          <a href="gaestebuchinput.htm"><strong>Neueintrag</strong></a> 
        </center>
      </td>
    </tr>
  </table>
</div>