<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php
echo "HSQLDB from PHP (PDO, ODBC)\r\n";
$con = new PDO('odbc:DSN=ARNE1_HSQLDB;UID=;PWD=');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$stmt = $con->prepare('SELECT f1,f2 FROM t1');
$stmt->execute(array());
while($row = $stmt->fetch()) {
    $f1 = $row['F1']; // note uppercase field names
    $f2 = $row['F2'];
    echo "$f1 $f2\r\n";
}
?>