Guest User

Untitled

a guest
Nov 21st, 2017
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.79 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>Add Record Form
  6. </title>
  7. </head>
  8. <body>
  9. <form action="../php/keithphp/address_submit.php" method="post">
  10. <p>
  11. <label for="address_street">Street</label>
  12. <input type="text" name="address_street" id="address_street">
  13. </p>
  14. <p>
  15. <label for="address_street2">Street 2</label>
  16. <input type="text" name="address_street2" id="address_street2">
  17. </p>
  18. <p>
  19. <label for="address_city">City</label>
  20. <input type="text" name="address_city" id="address_city">
  21. </p>
  22. <p>
  23. <label for="address_county">County</label>
  24. <input type="text" name="address_county" id="address_county">
  25. </p>
  26. <p>
  27. <label for="eircode">Eircode</label>
  28. <input type="text" name="eircode" id="eircode">
  29. </p>
  30. <!-- <p>
  31. <label for="address_geo_latitude">Latitude</label>
  32. <input type="float" name="address_geo_latitude" id="address_geo_latitude">
  33. </p>
  34. <p>
  35. <label for="address_geo_longtitude">Longitude</label>
  36. <input type="float" name="address_geo_longtitude" id="address_geo_longtitude">
  37. </p> -->
  38. <input type="submit" value="Submit">
  39. </form>
  40. </body>
  41. </html>
  42.  
  43. *****************
  44.  
  45. <?php
  46. $servername = getenv('IP');
  47. $username = getenv('C9_USER');
  48. $password = "";
  49. $database = "c9";
  50. $dbport = 3306;
  51.  
  52. // Create connection
  53. $db = new mysqli($servername, $username, $password, $database, $dbport);
  54. // Check connection
  55. if ($db->connect_error) {
  56. die("Connection failed: " . $db->connect_error);
  57. }
  58.  
  59. /*$address_id = $_POST['address_id'];*/
  60. $address_street = $_POST['address_street'];
  61. $address_street2 = $_POST['address_street2'];
  62. $address_city = $_POST['address_city'];
  63. $address_county = $_POST['address_county'];
  64. $address_eircode = $_POST['address_eircode'];
  65. /*$address_geo_latitude = $_POST['address_geo_latitude'];
  66. $address_geo_longtitude = $_POST['address_geo_longtitude'];*/
  67.  
  68. $sql = "INSERT INTO Address(address_id, address_street, address_street2, address_city, address_county, address_eircode, address_geo_latitude, address_geo_longtitude) VALUES ('$address_id', '$address_street', '$address_street2', '$address_city', '$address_county', '$address_eircode', '$address_geo_latitude', '$address_geo_longtitude')";
  69.  
  70. $success = $db->query($sql);
  71.  
  72. if (!$sucess){
  73. die("Could not enter data: ".$db->error);
  74. }
  75.  
  76. echo "Thank you. Address submitted!"
  77.  
  78. /*my$db->close();*/
  79. ?>
Add Comment
Please, Sign In to add comment