<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php
include '/disk2/arne/migr/simple/address.php';

$con = new PDO('sqlite:/disk2/arne/migr/simple/address.db');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$stmt = $con->prepare('SELECT id,name,address FROM address');
$stmt->execute(array());
$res = array();
while($row = $stmt->fetch()) {
   $res[] = new Address($row['id'], $row['name'], $row['address']);
}

foreach($res as $o) {
    echo sprintf('%d|%s|%s', $o->id, $o->name, $o-> address) . "\r\n";
}
?>