<?php $db = new sqlite_db(":memory:"); $db->query("CREATE TABLE foobar (misc CHAR(10))"); $db->query("INSERT INTO foobar (misc) VALUES('Tall')"); $db->query("\n\tINSERT INTO foobar (misc) VALUES('Wez');\n\tINSERT INTO foobar (misc) VALUES('Marcus');\n\tINSERT INTO foobar (misc) VALUES('Ilia');\n\tUPDATE foobar SET misc='Tal' WHERE misc='Tall';\n"); /* When chained queries are used rows changed returns the * cumulative of all rows affected by executed queries. */ echo $db->changes() . "rows affected by chained query.";
<?php $db = new sqlite_db(":memory:"); $db->query("CREATE TABLE foobar (misc CHAR(10))"); $db->query("INSERT INTO foobar (misc) VALUES('Tall')"); $db->query("\n\t\tINSERT INTO foobar (misc) VALUES('Wez');\n\t\tINSERT INTO foobar (misc) VALUES('Marcus');\n\t\tINSERT INTO foobar (misc) VALUES('Ilia');\n\t\tUPDATE foobar SET misc='Tal' WHERE misc='Tall';\n\t"); /* 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";