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

echo "Derby from PHP (JDBC, bridge)\r\n";
$db = new PJBridge('localhost', 4446); // proxy DB server
$con = $db->connect('jdbc:derby://192.168.0.10/test', 'sa', 'hemmeligt'); // real DB server
$rs = $db->exec('SELECT f1,f2 FROM t1');
while($row = $db->fetch_array($rs)){
    $f1 = $row['F1'];
    $f2 = $row['F2'];
    echo "$f1 $f2\r\n";
}
$db->free_result($rs);
?>