<?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();
?>