Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /******************************************************
- JotForm to MySQL Database Through Webhook - Sample Script
- Elton Cris - JotForm Tech Support
- www.jotform.com
- Test form: https://form.jotform.com/62893435003959
- Check request here: https://jotthemes.000webhostapp.com/jotform/view.php
- ******************************************************/
- //Replace with your DB Details
- $servername = "localhost";
- $username = "YOUR_USERNAME_HERE";
- $password = "YOUR_PASSWORD_HERE";
- $dbname = "YOUR_DBNAME_HERE";
- $dbtable = "YOUR_DBTABLE_HERE";
- //Create connection
- $mysqli = new mysqli($servername, $username, $password, $dbname);
- //Check connection
- if ($mysqli->connect_error) {
- die("Connection failed: " . $mysqli->connect_error);
- }
- //Get field values from the form
- //Get unique submissionID - nothing to change here
- $sid = $mysqli->real_escape_string($_REQUEST['submissionID']);
- //Get form field values and decode - nothing to change here
- $fieldvalues = $_REQUEST['rawRequest'];
- $obj = json_decode($fieldvalues, true);
- //Replace the field names from your form here
- $fname = $mysqli->real_escape_string($obj['q15_yourName'][first]);
- $lname = $mysqli->real_escape_string($obj['q15_yourName'][last]);
- $email = $mysqli->real_escape_string($obj['q16_yourEmail16']);
- $message = $mysqli->real_escape_string($obj['q17_yourMessage']);
- $result = $mysqli->query("SELECT * FROM $dbtable WHERE sid = '$sid'");
- //If submission ID exist, update record
- if ($result->num_rows > 0) {
- $result = $mysqli->query("UPDATE $dbtable SET firstname = '$fname', lastname = '$lname', email = '$email', message = '$message' WHERE sid = '$sid'");
- echo "Existing Record Updated!";
- }
- //If new submission, insert record
- else{
- $result = $mysqli->query("INSERT IGNORE INTO $dbtable (sid, firstname, lastname, email, message) VALUES ('$sid', '$fname', '$lname','$email','$message')");
- echo "New Record Added!";
- if ($result === false) {echo "SQL error:".$mysqli->error;}
- }
- $mysqli->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment