<?php
    $db = new sqlite_db(":memory:");
    $db->query("CREATE TABLE foobar (misc CHAR(10))");
    $db->query("INSERT INTO foobar (misc) VALUES('Tall')");

    $db->query("
        INSERT INTO foobar (misc) VALUES('Wez');
        INSERT INTO foobar (misc) VALUES('Marcus');
        INSERT INTO foobar (misc) VALUES('Ilia');
        UPDATE foobar SET misc='Tal' WHERE misc='Tall';
    ");

    /* When chained queries are used rows changed returns the cumulative 
     * of all rows affected by executed queries. */
    echo "Number of affected rows: " . $db->changes() . " by chained query.<br />\n";
?>