Advertisement
Guest User

Untitled

a guest
Jun 29th, 2013
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.62 KB | None | 0 0
  1. <?php
  2. require_once("config.php");
  3. $vorname = mysql_real_escape_string($_POST['vorname']);
  4. $nachname = mysql_real_escape_string($_POST['nachname']);
  5. $personalnr = mysql_real_escape_string($_POST['personalnr']);
  6. $adresse = mysql_real_escape_string($_POST['adresse']);
  7. $plz = mysql_real_escape_string($_POST['plz']);
  8. $tel1 = mysql_real_escape_string($_POST['tel1']);
  9. $tel2 = mysql_real_escape_string($_POST['tel2']);
  10. $aktiv = mysql_real_escape_string($_POST['aktiv']);
  11. $kategorie = mysql_real_escape_string($_POST['kategorie']);
  12. $email = mysql_real_escape_string($_POST['email']);
  13. $rkmail = mysql_real_escape_string($_POST['rkmail']);
  14. $funktion = mysql_real_escape_string($_POST['funktion']);
  15. $info = mysql_real_escape_string($_POST['info']);
  16.  
  17. if(isset($_POST['submit']))
  18. {
  19. if($vorname != "" && $nachname != "" && $personalnr != "" && $adresse != "" && $plz != "" && $tel1 != "" && $tel2 != "" && $email != "" && $rkmail != "" && $funktion != "" && $info != "")
  20. {
  21. $insertData = mysql_query("INSERT INTO gesamt VALUES('','$vorname','$nachname','$personalnr','$adresse','$adresse','$plz','$tel1','$tel2','$aktiv','$kategorie','$email','$rkmail','$funktion','$info')");
  22. $insertData = mysql_query("INSERT INTO $kategorie VALUES('','$vorname','$nachname','$personalnr','$adresse','$adresse','$plz','$tel1','$tel2','$aktiv','$kategorie','$email','$rkmail','$funktion','$info')");
  23. echo "Eintrag erfolgreich!";
  24. }
  25. else
  26. {
  27. $output = "F&uumlle; alle Felder aus!";
  28. }
  29. }
  30. ?>
  31.  
  32. <!DOCTYPE>
  33. <html>
  34. <head>
  35. <title>Mitarbeiter &Uuml;bersicht Rotes Kreuz</title>
  36. <link href="style/style.css" type="text/css" rel="stylesheet">
  37. </head>
  38. <body>
  39. <center>
  40. <div id="header">
  41. <div class = "logo"></div></div>
  42.  
  43. <div id="contaier"> <!-- width auf 800 setzen und Posi auf absu -->
  44. <div id ="Navi">
  45. <a href ="home.php">Gesamte Mannschaft</a> | <a href ="fahrer.php">Fahrer</a> | <a href ="Sanitater.php">Sanit&auml;ter</a> | <a href ="jugend.php">Jugend</a> | <a href ="praktikant.php">Praktikant</a> | <a href="eintragen.php">Mitarbeiter eintragen</a>
  46. </div>
  47. <div id ="mitarbeiter">
  48. <form action = "eintragen.php" method = "post">
  49. <table>
  50. <tr><td>Vorname:</td><td> <input type = "text" name= "vorname"></td></tr>
  51. <tr><td>Nachname:</td><td> <input type = "text" name= "nachname"></td></tr>
  52. <tr><td>Personalnr:</td><td> <input type = "text" name= "personalnr"></td></tr>
  53. <tr><td>Adresse:</td><td> <input type = "text" name= "adresse"></td></tr>
  54. <tr><td>PLZ:</td><td> <input type = "text" name= "plz"></td></tr>
  55. <tr><td>Tel.1:</td><td> <input type = "text" name= "tel1"></td></tr>
  56. <tr><td>Tel.2:</td><td> <input type = "text" name= "tel2"></td></tr>
  57. <tr><td>Aktiv:</td><td> <select name = "aktiv">
  58. <option>Ja</option>
  59. <option>Nein</option>
  60. </select><br>
  61. <tr><td>Kategorie:</td><td> <select name = "kategorie">
  62. <option>Fahrer</option>
  63. <option>Sanit&auml;ter</option>
  64. <option>Jugend</option>
  65. <option>Praktikant</option>
  66. </select><br>
  67.  
  68. <tr><td>email:</td><td> <input type = "text" name= "email"></td></tr>
  69. <tr><td>rkmail:</td><td> <input type = "text" name= "rkmail"></td></tr>
  70. <tr><td>Funktion/Dienstgrad:</td><td> <input type = "text" name= "funktion"></td></tr>
  71. <tr><td>Infos:</td><td> <input type = "text" name= "info"></td></tr>
  72. <tr><td> </td><td><input type="submit" value="Eintragen"></table>
  73. </form>
  74. <?php echo $output; ?>
  75. </div>
  76. </div>
  77. </center>
  78. </body>
  79. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement