idarktech

JotForm to MySQL Through Webhook

Oct 16th, 2016
8,629
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.98 KB | None | 0 0
  1. <?php
  2. /******************************************************
  3.  
  4. JotForm to MySQL Database Through Webhook - Sample Script
  5. Elton Cris - JotForm Tech Support
  6. www.jotform.com
  7.  
  8. Test form: https://form.jotform.com/62893435003959
  9. Check request here: https://jotthemes.000webhostapp.com/jotform/view.php
  10.  
  11. ******************************************************/
  12.  
  13. //Replace with your DB Details
  14. $servername = "localhost";
  15. $username = "YOUR_USERNAME_HERE";
  16. $password = "YOUR_PASSWORD_HERE";
  17. $dbname = "YOUR_DBNAME_HERE";
  18. $dbtable = "YOUR_DBTABLE_HERE";
  19.  
  20. //Create connection
  21. $mysqli = new mysqli($servername, $username, $password, $dbname);
  22.  
  23. //Check connection
  24. if ($mysqli->connect_error) {
  25.     die("Connection failed: " . $mysqli->connect_error);
  26. }
  27.  
  28. //Get field values from the form
  29. //Get unique submissionID - nothing to change here
  30. $sid = $mysqli->real_escape_string($_REQUEST['submissionID']);
  31.  
  32. //Get form field values and decode - nothing to change here
  33. $fieldvalues = $_REQUEST['rawRequest'];
  34. $obj = json_decode($fieldvalues, true);
  35.  
  36. //Replace the field names from your form here
  37. $fname = $mysqli->real_escape_string($obj['q15_yourName'][first]);
  38. $lname = $mysqli->real_escape_string($obj['q15_yourName'][last]);
  39. $email = $mysqli->real_escape_string($obj['q16_yourEmail16']);
  40. $message = $mysqli->real_escape_string($obj['q17_yourMessage']);
  41.  
  42. $result = $mysqli->query("SELECT * FROM $dbtable WHERE sid = '$sid'");
  43.  
  44. //If submission ID exist, update record
  45. if ($result->num_rows > 0) {
  46.     $result = $mysqli->query("UPDATE $dbtable SET firstname = '$fname', lastname = '$lname', email = '$email', message = '$message' WHERE sid = '$sid'");
  47.     echo "Existing Record Updated!";
  48. }
  49. //If new submission, insert record
  50. else{
  51.     $result = $mysqli->query("INSERT IGNORE INTO $dbtable (sid, firstname, lastname, email, message) VALUES ('$sid', '$fname', '$lname','$email','$message')");
  52.     echo "New Record Added!";
  53.     if ($result === false) {echo "SQL error:".$mysqli->error;}
  54. }
  55.  
  56. $mysqli->close();
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment