Advertisement
Guest User

Untitled

a guest
Jul 12th, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. <form action="insert.php" method="post">
  2. <p>
  3. <label for="jmeno">Jméno:</label>
  4. <input type="text" name="jmeno" id="jmeno">
  5. </p>
  6. <p>
  7. <label for="prijmeni">Příjmení:</label>
  8. <input type="text" name="prijmeno" id="prijmeni">
  9. </p>
  10. <p>
  11. <label for="email">Email:</label>
  12. <input type="text" name="email" id="email">
  13. </p>
  14. <p>
  15. <label for="cislo">Telefoní číslo:</label>
  16. <input type="text" name="cislo" id="cislo">
  17. </p>
  18. <p>
  19. <label for="adresa">Adresa:</label>
  20. <input type="text" name="adresa" id="adresa">
  21. </p>
  22. <input type="submit" value="Submit">
  23. </form>
  24.  
  25.  
  26. insert.php:
  27.  
  28. <?php
  29. $server = "localhost";
  30. $user = "username";
  31. $password = "password";
  32. $dbname = "DB";
  33. $conn = new mysqli($server, $user, $password, $dbname);
  34. if ($conn->connect_error) {
  35. die("Connection failed: " . $conn->connect_error);
  36. }
  37. $jmeno = mysqli_real_escape_string($link, $_POST['jmeno']);
  38. $prijmeni = mysqli_real_escape_string($link, $_POST['prijmeni']);
  39. $email = mysqli_real_escape_string($link, $_POST['email']);
  40. $cislo = mysqli_real_escape_string($link, $_POST['cislo']);
  41. $adresa = mysqli_real_escape_string($link, $_POST['adresa']);
  42.  
  43. $sql = "INSERT INTO sberdat (tel_cislo, jmeno, prijmeni, email, adresa)
  44. VALUES ($cislo, $jmeno, $prijmeni, $email, $adresa)";
  45. if ($conn->query($sql) === TRUE) {
  46. echo "Přidáno";
  47. } else {
  48. echo "Chyba: " . $sql . "<br>" . $conn->error;
  49. }
  50. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement