insert lo-keys by ids

1 files changed, 11 insertions, 0 deletions

diff --git a/html/db.php b/html/db.php
index 3e87fcc..9889c71 100644
--- a/html/db.php
+++ b/html/db.php
@@ -25,6 +25,17 @@ class MyDB extends SQLite3 {
       die();
     return $result;
   }
+  function get_state_id($state) {
+    $stm = $this -> prepare('SELECT states.id AS state_id FROM states WHERE states.name = :state');
+    $stm -> bindValue('state', $state);
+    $result = $stm -> execute();
+    if (! $result)
+      die();
+    $result = $result -> fetchArray();
+    if (! $result)
+      die();
+    return $result['state_id'];
+  }
   function add_key($comment) {
     $stm = $this -> prepare('INSERT INTO keys (key, comment) VALUES (:key, :comment)');
     $stm -> bindValue('key', bin2hex(random_bytes(64)));