mirror of
https://github.com/php/presentations.git
synced 2026-03-24 15:42:33 +01:00
17 lines
521 B
PHP
17 lines
521 B
PHP
<?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 $db->changes() . "rows affected by chained query.";
|
|
?>
|