Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Aufgabe3</title>
- </head>
- <body>
- <h1>Kontaktaufnahme</h1>
- <table border = '1'>
- <?php
- $tabellenname = "neu_2quartal2016";
- if(isset($_GET['ID'])) {
- $sql = "DELETE FROM $tabellenname where ID=".$_GET['ID'];
- $db_host = "localhost";
- $db_user = "root";
- $db_pass = "";
- $db_name = "casting";
- $link = mysql_connect($db_host,$db_user,$db_pass);
- mysql_select_db($db_name,$link);
- $result = mysql_query($sql,$link);
- }
- $sql = "SELECT * FROM $tabellenname";
- $db_host = "localhost";
- $db_user = "root";
- $db_pass = "";
- $db_name = "casting";
- $link = mysql_connect($db_host,$db_user,$db_pass);
- mysql_select_db($db_name,$link);
- $result = mysql_query($sql,$link);
- for ($i = 0; $i < mysql_num_rows($result); $i++)
- {
- $ergebnis[$i] = mysql_fetch_array($result);
- echo "<tr>";
- echo "<td>".$ergebnis[$i]['Vorname']."</td>";
- echo "<td>".$ergebnis[$i]['Nachname']."</td>";
- echo "<td>".$ergebnis[$i]['Alter']."</td>";
- echo "<td>".$ergebnis[$i]['Groesse']."</td>";
- echo "<td>".$ergebnis[$i]['Geschlecht']."</td>";
- echo "<td>".$ergebnis[$i]['Gewicht']."</td>";
- echo "<td>".$ergebnis[$i]['Erfahrung']."</td>";
- echo "<td>".$ergebnis[$i]['Datum']."</td>";
- echo "<td>".$ergebnis[$i]['Email']."</td>";
- echo "<td><a href ='".$_SERVER['PHP_SELF']."?ID=".$ergebnis[$i]['ID']."'>Loeschen</a></td>";
- echo "<td><a href ='SQLBearbeiten.php?ID=".$ergebnis[$i]['ID']."'>Bearbeiten</a></td>";
- echo "</tr>";
- }
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement