aboutsummaryrefslogtreecommitdiff
path: root/include/sqlite.php
diff options
context:
space:
mode:
Diffstat (limited to 'include/sqlite.php')
-rw-r--r--include/sqlite.php19
1 files changed, 19 insertions, 0 deletions
diff --git a/include/sqlite.php b/include/sqlite.php
new file mode 100644
index 0000000..6759e36
--- /dev/null
+++ b/include/sqlite.php
@@ -0,0 +1,19 @@
+<?php
+
+$db = new SQLite3("/data/data.db");
+
+function query($q, ...$values) {
+ global $db;
+
+ $stmt = $db->prepare($q);
+ foreach ($values as $key => $value) {
+ $stmt->bindValue(is_int($key) ? $key + 1 : $key, $value);
+ }
+ return $stmt->execute();
+}
+
+function lastRowId() {
+ global $db;
+
+ return $db->lastInsertRowId();
+}