52 lines
1.8 KiB
PHP
52 lines
1.8 KiB
PHP
<?php
|
|
|
|
include("functions.php");
|
|
require_db_auth();
|
|
|
|
if ($_SERVER["REQUEST_METHOD"] == "POST") {
|
|
$conn = connectDb();
|
|
$columns = [];
|
|
$values = [];
|
|
|
|
echo "<h2>Received POST Data:</h2><ul>";
|
|
foreach ($_POST as $key => $value) {
|
|
$escaped_key = "`" . $conn->real_escape_string($key) . "`";
|
|
if ($key === 'eta' || $key === 'etd') {
|
|
// Convert London time to UTC
|
|
$datetime = new DateTime($value, new DateTimeZone('Europe/London'));
|
|
$datetime->setTimezone(new DateTimeZone('UTC'));
|
|
$escaped_value = "'" . $datetime->format('Y-m-d H:i:s') . "'";
|
|
} else {
|
|
$escaped_value = ($value === '' || $value === null) ? "NULL" : (is_numeric($value) ? $value : "'" . $conn->real_escape_string($value) . "'");
|
|
}
|
|
$columns[] = $escaped_key;
|
|
$values[] = $escaped_value;
|
|
echo "<li><strong>" . htmlspecialchars($key) . ":</strong> " . htmlspecialchars($value) . "</li>";
|
|
}
|
|
echo "</ul>";
|
|
|
|
if (!empty($columns)) {
|
|
$sql = "INSERT INTO submitted (created_by, " . implode(",", $columns) . ") VALUES ('" . $_SERVER['PHP_AUTH_USER'] . "'," . implode(",", $values) . ")";
|
|
echo $sql;
|
|
|
|
if ($conn->query($sql) === TRUE) {
|
|
$lastId = $conn->insert_id;
|
|
echo "<p>Data successfully inserted into database with id = " . $lastId . "</p>";
|
|
if (!empty($_POST['email'])) {
|
|
echo "Email is set to " . $_POST['email'];
|
|
generatePprEmail($lastId, $_POST['email'], $_POST['ac_reg']);
|
|
} else {
|
|
echo "Email is not set.";
|
|
}
|
|
echo '<script>window.close();</script>';
|
|
} else {
|
|
echo "<p>Error inserting data: " . $conn->error . "</p>";
|
|
}
|
|
}
|
|
} else {
|
|
echo "<h2>No POST data received.</h2>";
|
|
}
|
|
|
|
?>
|
|
|