diff options
Diffstat (limited to 'html/db.php')
-rw-r--r-- | html/db.php | 11 |
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))); |