Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>Add Record Form
- </title>
- </head>
- <body>
- <form action="../php/keithphp/address_submit.php" method="post">
- <p>
- <label for="address_street">Street</label>
- <input type="text" name="address_street" id="address_street">
- </p>
- <p>
- <label for="address_street2">Street 2</label>
- <input type="text" name="address_street2" id="address_street2">
- </p>
- <p>
- <label for="address_city">City</label>
- <input type="text" name="address_city" id="address_city">
- </p>
- <p>
- <label for="address_county">County</label>
- <input type="text" name="address_county" id="address_county">
- </p>
- <p>
- <label for="eircode">Eircode</label>
- <input type="text" name="eircode" id="eircode">
- </p>
- <!-- <p>
- <label for="address_geo_latitude">Latitude</label>
- <input type="float" name="address_geo_latitude" id="address_geo_latitude">
- </p>
- <p>
- <label for="address_geo_longtitude">Longitude</label>
- <input type="float" name="address_geo_longtitude" id="address_geo_longtitude">
- </p> -->
- <input type="submit" value="Submit">
- </form>
- </body>
- </html>
- *****************
- <?php
- $servername = getenv('IP');
- $username = getenv('C9_USER');
- $password = "";
- $database = "c9";
- $dbport = 3306;
- // Create connection
- $db = new mysqli($servername, $username, $password, $database, $dbport);
- // Check connection
- if ($db->connect_error) {
- die("Connection failed: " . $db->connect_error);
- }
- /*$address_id = $_POST['address_id'];*/
- $address_street = $_POST['address_street'];
- $address_street2 = $_POST['address_street2'];
- $address_city = $_POST['address_city'];
- $address_county = $_POST['address_county'];
- $address_eircode = $_POST['address_eircode'];
- /*$address_geo_latitude = $_POST['address_geo_latitude'];
- $address_geo_longtitude = $_POST['address_geo_longtitude'];*/
- $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')";
- $success = $db->query($sql);
- if (!$sucess){
- die("Could not enter data: ".$db->error);
- }
- echo "Thank you. Address submitted!"
- /*my$db->close();*/
- ?>
Add Comment
Please, Sign In to add comment