?> <?php include 'rdf-generator.php'; $submission = []; foreach ($_POST as $key => $item) { echo '<span class="bold-text">' . $key . '</span> : ' . $item . '<br>'; $submission[$key] = $item; } $jsonString = json_encode($submission, JSON_PRETTY_PRINT); echo '<pre>' . $jsonString . '</pre>'; $dbCon = mysqli_connect($database_host, $database_username, $database_password, $database_database); if (!$dbCon) { die('Could not connect: ' . mysql_error()); } $query = "INSERT INTO submissions (data,data_format,rdf_version,date_submitted,user) VALUES ('" . mysqli_real_escape_string($dbCon, $jsonString) . "','json','0.1',NOW(),'" . $_SESSION['user_id'] . "');"; echo $query; $rdf = generateRDF($submission); echo '<pre>' . htmlspecialchars($rdf) . '</pre>'; if (mysqli_query($dbCon, $query)) { echo 'Updated database'; } else { echo "Error: " . $query . "<br>" . mysqli_error($dbCon); } $dbCon->close(); ?> <div><a href="rdf-form.php">Submit a new form</a> </div> <?php } include "footer.php";
?> </h1> </div> <div class="col-xs- text-center submission-tools"> <a href="rdf?id=<?php print $id; ?> &download" class="btn btn-default">Download</a> <a href="edit?id=<?php print $id; ?> " class="btn btn-default">Edit</a> <a href="view?id=<?php print $id; ?> " class="btn btn-default">View</a> </div> </div> <div class="row" style="margin-top: 15px;"> <div class="col-xs-12"> <pre><?php print htmlspecialchars(generateRDF($id)); ?> </pre> </div> </div> </div> <?php require "includes/footer.php";