<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
****************************
* Design and *
* Programming by *
****************************
//-->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="de" lang="de">
<head>
<title>Gästebuch</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta http-equiv="content-language" content="de, at" />
<meta http-equiv="pragma" content="no-cache" />
<meta name="design" content="*" />
<meta name="author" content="*" />
<meta name="date" content="2008-01-21" />
<meta name="description" content="*" />
<meta name="keywords" content="*" />
<meta name="robots" content="index" />
<meta name="robots" content="follow" />
<meta name="revisit-after" content="30 days" />
<!-- Deine CSS-Datei -->
<link rel="stylesheet" type="text/css" href="*" />
<script type="text/javascript">
/* <![CDATA[ */
function chkFormular()
{
if (document.gaeste.vorname.value == "")
{
alert("Bitte Ihren Vornamen eingeben!");
document.gaeste.vorname.focus();
return false;
}
if (document.gaeste.name.value == "")
{
alert("Bitte Ihren Namen eingeben!");
document.gaeste.name.focus();
return false;
}
if (document.gaeste.nickname.value == "")
{
alert("Bitte Ihren Nicknamen eingeben!");
document.gaeste.nickname.focus();
return false;
}
if (document.gaeste.email.value == "")
{
alert("Bitte Ihre Emailadresse eingeben!");
document.gaeste.email.focus();
return false;
}
if (document.gaeste.email.value.indexOf("@") == -1)
{
alert("Keine E-Mail-Adresse!");
document.gaeste.email.focus();
return false;
}
if (document.gaeste.message.value == "")
{
alert("Bitte Kommentar eingeben!");
document.gaeste.message.focus();
return false;
}
}
function warnung()
{
return confirm('Wollen Sie die Eingaben wirklich l\u00f6schen?');
}
/* ]]> */
</script>
<?php
/* Datenbank einbinden */
include "db.inc.php";
/* Datenbankeintrag erstellen */
if (isset($_POST['submit']))
{
mysql_query("
INSERT INTO gaeste (datum, name, vorname, nickname, email, message)
VALUES (now(), '".$_POST['name']."', '".$_POST['vorname']."', '".$_POST['nickname']."', '".$_POST['email']."', '".$_POST['message']."')");
}
/* Datenbank auslesen */
$result = mysql_query ('
SELECT UNIX_TIMESTAMP(datum) AS datum, name, vorname, nickname, message
FROM gaeste
ORDER BY datum DESC');
?>
</head>
<body>
<!-- Eingabe Daten -->
<form name="gaeste" action="gaeste.php" method="post" onsubmit="return chkFormular();" onreset="return warnung();">
<table border="0" cellpadding="0" cellspacing="2" width="1000">
<tr>
<td colspan="2"><h1>Gästebuch</h1></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><h3>Neuer Eintrag</h3></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>Vorname</td>
<td><input name="vorname" type="text" maxlength="40" size="25" /></td>
</tr>
<tr>
<td>Name</td>
<td><input name="name" type="text" maxlength="40" size="25" /></td>
</tr>
<tr>
<td>Nickname</td>
<td><input name="nickname" type="text" maxlength="40" size="25" /></td>
</tr>
<tr>
<td>Email</td>
<td><input name="email" type="text" maxlength="40" size="25" /></td>
</tr>
<tr>
<td valign="top">Mitteilung</td>
<td><textarea name="message" cols="60" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="Eintragen" /> <input type="reset" name="reset" value="Löschen"</td>
</tr>
</table>
</form>
<!-- Ausgabe Daten -->
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><h1>Einträge</h1></td>
</tr>
<?php
/* Ausgabe */
if (mysql_num_rows($result) == 0)
{
echo "<tr>";
echo "<td colspan=\"2\">Es sind keine Eintrgäe vorhanden</td>";
echo "</tr>";
}
for ($row = 0; $row < mysql_num_rows($result); $row++)
{
$eintrag = localtime(mysql_result($result, $row, 'datum'), true);
$monate = Array("Januar", "Februar", "März", "April", "Mai", "Juni", "Juli", "August", "September", "Oktober", "November", "Dezember");
$monat = $eintrag['tm_mon'];
$jahr = $eintrag['tm_year'] + 1900;
$stunde = $eintrag['tm_hour'] < 10 ? "0".$eintrag['tm_hour'] : $eintrag['tm_hour'];
$minuten = $eintrag['tm_min'] < 10 ? "0".$eintrag['tm_min'] : $eintrag['tm_min'];
if ($row % 2 == 0)
{
echo '<tr class="grau">';
}
else
{
echo '<tr class="weiss">';
}
echo '<td>';
echo "<b>".mysql_result($result, $row, 'vorname')." ".mysql_result($result, $row, 'name')."</b> schrieb am ".$eintrag['tm_mday'].". ".$monate[$monat]." ".$jahr." um ".$stunde.":".$minuten;
echo '</td>';
echo '</tr>';
if ($row % 2 == 0)
{
echo '<tr class="grau">';
}
else
{
echo '<tr class="weiss">';
}
echo '<td>';
echo mysql_result($result, $row, 'message');
echo '</td>';
echo '</tr>';
}
?>
</table>
</body>
</html>