Advertisement
Guest User

Untitled

a guest
Feb 27th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "claseMmedia";
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12. echo "Error de conexion, :(". $conn->connect_error;
  13. }
  14. else
  15. {
  16. echo "Conexion correcta";
  17. }
  18.  
  19. $name = $_GET["name"];
  20. $age = $_GET["age"];
  21. $sex = $_GET["sex"];
  22.  
  23. $sexLetter = "_";
  24.  
  25. if ($sex=="0")
  26. {
  27. $sexLetter = "F";
  28. }
  29. else
  30. {
  31. $sexLetter = "M";
  32. }
  33.  
  34. $sql = "INSERT INTO formulario (id, name, age, sex, fechaRegistro, sexLetter)
  35. VALUES (NULL, '$name', '$age', '$sex', NULL, '$sexLetter')";
  36.  
  37. $conn->query($sql);
  38. /*
  39. if ($conn->query($sql) === TRUE) {
  40. echo "New record created successfully";
  41. } else {
  42. echo "Error: " . $sql . "<br>" . $conn->error;
  43. }
  44. */
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement