connect_error) {
die("Errore di connessione: " . $conn->connect_error);
}
// Controlla se l'ID della condivisione รจ fornito
$idsharing = isset($_GET['idsharing']) ? (int)$_GET['idsharing'] : 0;
if ($idsharing === 0) {
die("ID condivisione non valido.");
}
// Recupera i dettagli della condivisione con JOIN per ruolo e tipo di condivisione
$query = "
SELECT
hs.idsharing,
hs.idhome,
hs.shared_email,
hs.sharing_type,
hs.shared_sections,
hs.expiration_date,
sr.role_name,
hs.role_id
FROM home_Sharing hs
LEFT JOIN sharing_roles sr ON hs.role_id = sr.idrole
WHERE hs.idsharing = ?
";
$stmt = $conn->prepare($query);
$stmt->bind_param('i', $idsharing);
$stmt->execute();
$result = $stmt->get_result();
$sharing = $result->fetch_assoc();
if (!$sharing) {
die("Condivisione non trovata.");
}
// Recupera i ruoli di condivisione
$rolesQuery = $conn->query("SELECT idrole, role_name FROM sharing_roles ORDER BY role_name ASC");
$roles = $rolesQuery->fetch_all(MYSQLI_ASSOC);
// Recupera le sezioni dalla tabella 'sections'
$sectionsQuery = $conn->query("SELECT idsections, section_name FROM sections ORDER BY section_name ASC");
$sections = $sectionsQuery->fetch_all(MYSQLI_ASSOC);
// Decode delle sezioni condivise salvate nel database
$shared_sections = json_decode($sharing['shared_sections'], true) ?: [];
?>
Modifica Condivisione