Advertisement
Guest User

Untitled

a guest
May 31st, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. <!Doctype HTML>
  2.  
  3. <html>
  4.  
  5. <title>Neues Projekt</title>
  6. <link rel="stylesheet" type="text/css" href="style.css">
  7. <meta charset="UTF-8">
  8.  
  9. <head>
  10. <h1>Neues Projekt anlegen</h1>
  11. </head>
  12.  
  13. <body>
  14. <form action="php_skript.php" method="post">
  15. <p>Name des Projekts:</p>
  16. <input type="text" name="name">
  17. <p>Ort des Projekts:</p>
  18. <input type="text" name="ort">
  19. <p>Straße des Projekts:</p>
  20. <input type="text" name="strasse">
  21. <p>Projektleiter:</p>
  22. <input type="text" name="projektleiter">
  23. <br>
  24. <input type="submit" value="Submit">
  25. </form>
  26. Bilder hinzufügen:
  27. <form method="post" enctype="multipart/form-data">
  28. <input type="file" name="image_data" multiple>
  29. </form>
  30.  
  31.  
  32. </form>
  33.  
  34. </body>
  35.  
  36.  
  37. </html>
  38.  
  39. <?php
  40. $user = 'root';
  41. $password = 'root';
  42. $db = 'projekte_db';
  43. $host = 'localhost';
  44. $port = 3306;
  45.  
  46. $name=mysqli_real_escape_string($mysqli, $_POST['name']);
  47. $ort=mysqli_real_escape_string($mysqli, $_POST['ort']);
  48. $strasse=mysqli_real_escape_string($mysqli, $_POST['strasse']);
  49. $projektleiter=mysqli_real_escape_string($mysqli, $_POST['projektleiter']);
  50.  
  51. $mysqli=new mysqli($host, $user, $password, $db);
  52.  
  53.  
  54. if ($mysqli->connect_errno) {
  55. printf("Connect failed: %sn", $mysqli->connect_error);
  56. exit();
  57. }
  58.  
  59. $mysqli->query("INSERT INTO Projekt (name,ort,straße,projektleiter) VALUES ('$name','$ort','$strasse','$projektleiter')");
  60.  
  61. $mysqli->close();
  62. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement