prepare("SELECT * FROM property_owners WHERE owner_id = ? AND user_id = ?"); $query->bind_param("ii", $owner_id, $iduserlogin); $query->execute(); $result = $query->get_result(); $ownerData = $result->fetch_assoc(); // Assegna i valori esistenti ai campi $first_name = $ownerData['first_name']; $last_name = $ownerData['last_name']; $company_name = $ownerData['company_name']; $tax_code = $ownerData['tax_code']; $email = $ownerData['email']; $phone = $ownerData['phone']; $address = $ownerData['address']; $postal_code = $ownerData['postal_code']; $city = $ownerData['city']; $province = $ownerData['province']; $country = $ownerData['country']; // ID della tabella auth_countries $owner_type = $ownerData['owner_type']; $role = $ownerData['role']; } else { // Inizializza i campi vuoti per un nuovo proprietario $first_name = $last_name = $company_name = $tax_code = $email = $phone = $address = $postal_code = $city = $province = $country = $role = ''; $owner_type = 'individual'; } // Recupera la lista dei paesi dalla tabella auth_countries $countriesQuery = $conn->prepare("SELECT id, name FROM auth_countries ORDER BY name ASC"); $countriesQuery->execute(); $countriesResult = $countriesQuery->get_result(); ?> <?php echo $isNew ? "Aggiungi Proprietario" : "Modifica Proprietario"; ?>
  1. CasaDoc