#! c:/progra~1/php/cli/php
<?php

$db = ibase_connect('db', 'usr', 'pw');

function runQuery($query) {
    global $db;

    if (preg_match('/^\s*SELECT/i', $query)) {
        $trans = null;
    } else {
        echo "Initiating a transaction for the following query...\n";
        $trans = ibase_trans();
    }

    echo "$query\n";

    if ( $result = @ibase_query($db, $query) ) {
        if ($trans) {
            /*
             * Using InterBase 7.1 on a Windows 2000 machine.
             *
             * If ibase_commit() uses $db as link in PHP 4.3.4 and
             * php5-win32-200312052330, when get to DROP TABLE...
             *     Warning: ibase_commit(): unsuccessful metadata update
             *     object BAR is in use.
             *
             * But switching to $trans in 4.3.4, works flawlessly.
             *
             * BUT, using $trans in php5-win32-200312052330 leads to errors
             * during INSERT and SELECT statements:
             *     Dynamic SQL Error SQL error code = -204 Table unknown BAR
             *
             * Naturally, ibase_fetch_assoc() later complains about an invalid
             * resource.
             *
             * Funny thing is, the table gets created -- which can be verified
             * by commenting out the DROP TABLE statement.
             */
            echo "... about to commit the transaction.\n\n";
            ibase_commit($trans);
        }
        return $result;
    } else {
        echo ibase_errmsg() . "\n\n";
        return;
    }
}

$q = array(
    "CREATE TABLE BAR(
        cf char(1) default '' NOT NULL,
        nf smallint default 0 NOT NULL,
        df TIMESTAMP NOT NULL)",
    "INSERT INTO BAR VALUES ('a', 1, '1999-01-11 00:00:31')",
    "INSERT INTO BAR VALUES ('b', 2, '1999-02-12 00:00:32')",
    "INSERT INTO BAR VALUES ('c', 3, '1999-03-13 00:00:33')",
);

foreach ($q as $value) {
    runQuery($value);
}

$result = runQuery('SELECT * FROM BAR');

while ( $row = ibase_fetch_assoc($result) ) {
    echo '_' . implode("_\t_", $row) . "_\n";
}
echo "\n";

runQuery('DROP TABLE BAR');

?>