<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<?php
$mysqlhost="localhost"; // MySQL-Host angeben
$mysqluser="m4terial"; // MySQL-User angeben
$mysqlpwd="dexter123"; // Passwort angeben
$mysqldb="m4terial"; // Gewuenschte Datenbank angeben
$connection=mysql_connect($mysqlhost, $mysqluser, $mysqlpwd) or die("Verbindungsversuch fehlgeschlagen");
mysql_select_db($mysqldb, $connection) or die("Konnte die Datenbank nicht waehlen.");
?>
<head>
<title>Kontakt</title>
<meta charset="utf-8">
<link rel="stylesheet" href="css/layout.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style.css" type="text/css" media="all">
<link rel="stylesheet" href="css/custom-login.css" type="text/css" media="all">
</head>
<form action="WAS MUSS HIER REIN ?!" method="post"><br />
<label for="email">E-Mail:</label>
<input type="text" name="email" id="email" placeholder="m.mustermann@hotmail.de" class="text" /><br /><br />
<label for="vorname">Vorname:</label>
<input type="name" name="vorname" placeholder="Max Mustermann"id="name " class="text" /><br /><br />
<textarea cols="48" rows="10" name="anliegen" id="textarea" placeholder="Ihr Anliegen"></textarea><br /><br />
<input type="submit" id="input" value="Senden" class="submit" /><br /><br />
</form><br />
<table border="1">
<tr>
<?php
$abfrage = mysql_query("SELECT id, vorname , nachname , email FROM Kontakte") or die(mysql_error());
$dbanz = mysql_num_rows($abfrage);
for ($i=0; $i < $dbanz; $i++)
{
$id = mysql_result($abfrage,$i,"id");
$vorname = mysql_result($abfrage,$i,"vorname");
$vorname = UTF8_encode($vorname);
$nachname = mysql_result($abfrage,$i,"nachname");
$nachname = UTF8_encode($nachname);
$email = mysql_result($abfrage,$i,"email");
$email = UTF8_encode($email);
echo"<tr>";
echo"<td>";
echo"<td>$id</td>";
echo"<td>$vorname</td>";
echo"<td>$nachname</td>";
echo"<td>$email</td>";
}
?>
</tr>
</table>
</p>
</article>
<article class="col1">
</body>
</html>
...
Zitieren
