save_element.php

<?php
session_start();
require_once __DIR__ . '/includes/Auth.php';
require_once __DIR__ . '/includes/Database.php';

if (!isset($_SESSION['username'])) {
    header('Location: login.php');
    exit;
}

$pdo = Database::connect();

$id_geosite = $_POST['id_geosite'] ?? null;
$type = $_POST['type'] ?? '';
$scale = $_POST['scale'] ?? '';
$name = $_POST['name'] ?? '';
$description = $_POST['description'] ?? '';
$geometry = $_POST['geometry'] ?? null;

// If checkboxes are not specified,m then set them to 0
$abiotic = isset($_POST['abiotic']) ? 1 : 0;
$biotic = isset($_POST['biotic']) ? 1 : 0;
$cultural = isset($_POST['cultural']) ? 1 : 0;

if (!$id_geosite || !$type) {
    die("No required data.");
}

// Add new element
$stmt = $pdo->prepare("INSERT INTO elements (fid, type, scale, name, description, abiotic, biotic, cultural, geojson) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute([$id_geosite, $type, $scale, $name, $description, $abiotic, $biotic, $cultural, $geometry]);

header("Location: geosite.php?fid=" . $id_geosite);
exit;
?>