1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35: 
36: 
37: 
38: 
39: 
40: 
41: 
42: 
43: 
44: 
45: 
46: 
47: 
48: 
49: 
50: 
51: 
52: 
53: 
54: 
55: 
56: 
57: 
58: 
59: 
60: 
61: 
62: 
63: 
64: 
65: 
66: 
67: 
68: 
69: 
70: 
71: 
72: 
73: 
74: 
75: 
76:

<?PHP

$dp = @mysql_connect("localhost", "user", "pass") or die("keine Verbindung zu MYSQL");
@mysql_select_db("datenbank", $dp) or die("keine Verbindung zur Datenbank");
if (isset ($_POST['submit'])) {
   $sql = "INSERT INTO termine (datum, name, ort, beschreibung) VALUES ('$_POST[datum]', '$_POST[name]', '$_POST[ort]', '$_POST[beschreibung]')";

$result = mysql_query($sql);
if ($result) {
   echo "Dateneingabe erfolgreich";
   } else {
   echo "GOTTVERFLUCHTE STINKENDE DRECKSCHEISSE!!!";
   }
   }
?>

 <form action="<?PHP echo $_SERVER['PHP_SELF'] ?>" method="post">

 <h2 style="margin-left: 50px"><u>Markttermine eintragen</u></h2>
 <table>
<tr>
 <td>Datum (YYYY-MM-DD)</td>
 <td>Name des Marktes</td>
 <td>Ort</td>
 <td>Beschreibung</td>
</tr>
<tr>
 <td><input type="text" name="datum" size="20" value="<?PHP echo $POST[datum] ?>"/></td>
 <td><input type="text" name="name" size="20" value="<?PHP echo $POST[name] ?>"/></td>
 <td><input type="text" name="ort" size="20" value="<?PHP echo $POST[ort] ?>"/></td>
 <td><input type="text" name="beschreibung" size="20" value="<?PHP echo $POST[beschreibung] ?>"/></td>
</tr>
<tr>
 <td><input type="submit" name="submit" value="Termin eintragen"/></td>
 <td></td>
 <td></td>
 <td></td>
</tr>
</table>
</form>
<hr noshade/>

<?PHP
$sql2 = "SELECT * FROM termine";
$result = mysql_query($sql2);
$felder = mysql_num_fields($result);
$daten = mysql_num_rows($result);
?>
<h2 style="margin-left: 50px"><u>Termin Übersicht (<?PHP echo "<b>$daten</b>" ?>&nbsp;Termine)</u></h2>
<table>
<tr>
<?PHP
for ($i = 0;$i < $felder;$i++) {
    $feldname = mysql_field_name($result, $i);
    echo "<th><b>$feldname</b></th>";
    }
?>
</tr>
<?PHP

//$id = $_GET['id'];

while ($row = mysql_fetch_assoc($result)) {
      echo "<tr>";
      foreach ($row as $key => $value) {
      echo "<td style='border: 1px solid black; padding: 5px'>$value</td>";
      }
      echo '<td> <a href="?del='.$row['id'].'">Löschen</a></td>';
      echo "</tr>";
      }
if (isset ($_GET['del'])) {
   //mysql_select_db("datenbank", $dp);
   $query_delete = ("DELETE FROM termine WHERE id = '".$_GET['del']."'");
   $delete = mysql_query($query_delete);
}
?>

1: 
2: 
3: 
4:

if (isset ($_POST['loeschen'])) {
   mysql_select_db("datenbank", $dp);
   $query_delete = ("DELETE FROM termine WHERE id = '$id'");
   $delete = mysql_query($query_delete, $dp);

1: 
2: 
3:

	
$id = $_GET['id']