mirror of
https://github.com/php/presentations.git
synced 2026-03-24 15:42:33 +01:00
19 lines
332 B
PHP
19 lines
332 B
PHP
<?php
|
|
$db = sqlite_open(":memory:");
|
|
|
|
sqlite_query("CREATE TABLE foobar (
|
|
id INTEGER PRIMARY KEY,
|
|
misc CHAR(10)
|
|
)", $db);
|
|
|
|
sqlite_query("
|
|
INSERT INTO foobar (misc) VALUES ('Wez');
|
|
INSERT INTO foobar (misc) VALUES ('Ilia');
|
|
", $db);
|
|
|
|
// return the last ID
|
|
echo sqlite_last_insert_rowid($db) . "<br />\n";
|
|
|
|
sqlite_close($db);
|
|
?>
|