mirror of
https://github.com/php/presentations.git
synced 2026-03-25 16:12:07 +01:00
15 lines
492 B
PHP
15 lines
492 B
PHP
<?php
|
|
$db = new sqlite_db(":memory:");
|
|
$db->query("CREATE TABLE foobar (id INTEGER PRIMARY KEY, misc CHAR(10))");
|
|
$db->query("INSERT INTO foobar (misc) VALUES('Marcus');
|
|
INSERT INTO foobar (misc) VALUES('Ilia')");
|
|
|
|
/* When performing multiple inserts within a single query
|
|
* only the id of very last insert is returned */
|
|
echo "Last id: " . $db->last_insert_rowid() . "<br />\n";
|
|
|
|
echo '<pre>';
|
|
print_r($db->array_query("SELECT * FROM foobar", SQLITE_ASSOC));
|
|
echo '</pre>';
|
|
?>
|