예제 #1
0
<?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.";
예제 #2
0
<?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";