You've actually answered your own question; You have saved the results in an array refererence. And you've shown how to iterate through it with your foreach() loop. Excusing typos

# $dbh has already been ->connect()ed
my $sth = $dbh->prepare( "SELECT name, adres, woonplaats FROM personen
+" );

$sth ->execute();

# Get all the results rows and store the array reference
my $array_ref = $sth->fetchall_arrayref();

# For each row in the result set, print it out.
foreach my $row(@$array_ref)
{
   my( $name, $adres, $woonplaats) = @$row;
   print "$name t $adres t $woonplaats";
}
[download]

Personally, I'm not a fan of fetchall(), and would do it more like:

# $dbh has already been ->connect()ed
my $sth = $dbh->prepare( "SELECT name, adres, woonplaats FROM personen
+" );

$sth ->execute();

# For each row in the result set, print it out.
while( my( $name, $adres, $woonplaats ) = $sth->fetchrow_array )
{
   print "$name t $adres t $woonplaats";
}
[download]

Caveat: This won't hold on to the data if you want to iterate over each row more than once