<?php
require_once "include/config.php";
// Create a database connection
$conn = new mysqli($host, $username, $password, $database);
// Check the connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// Retrieve JSON data from the form submission
$jsonAnswers = $_POST["jsonAnswers"];
$hashValue = $_POST["hash"];
echo $jsonAnswers;
echo $hashValue;
// exit();
// Insert the JSON data into your MySQL table
$sql = "UPDATE assessment_by_assessor SET status =2, data=? WHERE hash = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ss", $jsonAnswers, $hashValue);
if ($stmt->execute()) {
$stmt->close();
$conn->close();
header("Location: " . $_SERVER["HTTP_REFERER"]);
exit; // Make sure to exit the script after redirection
} else {
echo "Error: " . $stmt->error;
$stmt->close();
$conn->close();
}
}
?>