connect_error) {
die("Errore di connessione: " . $conn->connect_error);
}
// Recupera l'id utente loggato
$iduserlogin = $_SESSION['iduserlogin'];
// Calcolo del numero di immobili
$queryHomes = $conn->prepare("SELECT COUNT(*) AS total_homes FROM home WHERE iduser = ?");
$queryHomes->bind_param('i', $iduserlogin);
$queryHomes->execute();
$resultHomes = $queryHomes->get_result();
$totalHomes = $resultHomes->fetch_assoc()['total_homes'];
// Calcolo del numero di persone
$queryOwners = $conn->prepare("SELECT COUNT(*) AS total_owners FROM property_owners WHERE user_id = ?");
$queryOwners->bind_param('i', $iduserlogin);
$queryOwners->execute();
$resultOwners = $queryOwners->get_result();
$totalOwners = $resultOwners->fetch_assoc()['total_owners'];
// Numero di documenti (placeholder per ora)
// Calcolo del numero di documenti
$queryDocuments = $conn->prepare("
SELECT COUNT(*) AS total_documents
FROM doc_storage
LEFT JOIN home ON doc_storage.idhome = home.idhome
WHERE home.iduser = ?
");
$queryDocuments->bind_param('i', $iduserlogin);
$queryDocuments->execute();
$resultDocuments = $queryDocuments->get_result();
$totalDocuments = $resultDocuments->fetch_assoc()['total_documents'];
?>