new Database and external database issue

[KarlvonKarton]

I have a function in a custom class that works.
But now I'm trying to connect to an external database, but this gives an error on this line (second version hereunder):

$rs->setFetchMode(\PDO::FETCH_ASSOC);

I'm a bit stuck...

public function getFrontpagePropertiesList(){
        
$sql = "SELECT * FROM max_properties WHERE (client_var_368='1') ORDER BY max_properties.wijziging_datum DESC ";
        
$rs = wire('database')->prepare($sql);
        
$rs->setFetchMode(\PDO::FETCH_ASSOC);
$rs->execute();
    
return $rs->fetchAll();
    
}

public function getFrontpagePropertiesList(){
        
$dbm = new Database('localhost', 'user', 'PASS', 'db');
        
$sql = "SELECT * FROM max_properties WHERE (client_var_368='1') ORDER BY max_properties.wijziging_datum DESC ";
                
$rs = $dbm->prepare($sql);
        
$rs->setFetchMode(\PDO::FETCH_ASSOC);  // THIS gives error
$rs->execute();
    
return $rs->fetchAll();    
}

 

[BitPoet]

The Database class inherits from mysqli. You want to use WireDatabasePDO instead.