Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- # php handler for the course form
- # Prepare string to send
- # $_POST is the variables from the html form.
- $stuff = '<?xml version=\\"1.0\\" encoding=\\"UTF - 8\\" ?>
- <form>
- <FormSubject>PG-kurs</FormSubject>
- <FormRecipient>kurs@something.org</FormRecipient>
- <Navn>' . $_POST["name"] . '</Navn>
- <Fodselsdato>' . $_POST["birth"] . '</Fodselsdato>
- <Hyde>' . $_POST["height"] . '</Hyde>
- <Vekt>' . $_POST["weight"] . '</Vekt>
- <Telefon>' . $_POST["tlf"] . '</Telefon>
- <Epost>' . $_POST["email"] . '</Epost>
- <Adresse>' . $_POST["adress"] . '</Adresse>
- <Annen_informasjon_eller_sprsml_til_oss>' . $_POST["other"] . '</Annen_informasjon_eller_sprsml_til_oss>
- <Page>link til kurs nettside</Page>
- <Referrer>link til activities</Referrer>
- </form>';
- $stringToSend = str_replace( '/', '\/', $stuff);
- # Set up database connection
- $servername = "localhost";
- $username = "";
- $password = "";
- $dbname = "";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "INSERT INTO mydb (form_id, xmldata) VALUES ('00000000000000000002', $stringToSend)";
- echo $sql;
- if ($conn->query($sql) === TRUE) {
- echo "New record created successfully";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement