connect_error) { die("Errore di connessione: " . $conn->connect_error); } // Recupera l'id immobile (idhome) passato tramite GET $idhome = isset($_GET['idhome']) ? intval($_GET['idhome']) : 0; if ($_SERVER['REQUEST_METHOD'] === 'POST') { // Recupera i dati dal form $shared_email = $conn->real_escape_string($_POST['shared_email']); $sharing_type = $conn->real_escape_string($_POST['sharing_type']); $shared_sections = json_encode($_POST['shared_sections']); // Converti le sezioni in JSON $expiration_date = !empty($_POST['expiration_date']) ? $_POST['expiration_date'] : null; // Inserimento nel database $query = $conn->prepare(" INSERT INTO home_sharing (idhome, shared_email, sharing_type, shared_sections, expiration_date, created_at) VALUES (?, ?, ?, ?, ?, NOW()) "); $query->bind_param('issss', $idhome, $shared_email, $sharing_type, $shared_sections, $expiration_date); if ($query->execute()) { // Reindirizza a share-home.php con l'idhome header("Location: share-home.php?idhome=$idhome&success=1"); exit; } else { $error = "Errore nell'inserimento della condivisione. Riprova."; } $query->close(); } ?>