html/db.php: use $this

1 files changed, 7 insertions, 7 deletions

diff --git a/html/db.php b/html/db.php
index cca6d74..7af33f9 100644
--- a/html/db.php
+++ b/html/db.php
@@ -26,16 +26,16 @@ class MyDB extends SQLite3 {
     return $result;
   }
   function add_key() {
-    $stm = prepare('INSERT INTO keys (key) VALUES (:key)');
+    $stm = $this -> prepare('INSERT INTO keys (key) VALUES (:key)');
     $stm -> bindValue('key', bin2hex(random_bytes(64)));
     $stm -> execute();
-    $key_id = $db -> lastInsertRowID();
+    $key_id = $this -> lastInsertRowID();
     $stm -> close();
     return $key_id;
   }
   function get_value_id_of($machine, $state) {
     if (is_int($machine) && is_int($state)) {
-      $stm = $db -> prepare(
+      $stm = $this -> prepare(
         'SELECT "values".id as value_id FROM "values"' .
         ' WHERE "values".state_id = :state_id' .
         ' AND "values".machine_id = :machine_id'
@@ -43,7 +43,7 @@ class MyDB extends SQLite3 {
       $stm -> bindValue('state_id', $state);
       $stm -> bindValue('machine_id', $machine);
     } else {
-      $stm = $db -> prepare(
+      $stm = $this -> prepare(
         'SELECT "values".id as value_id FROM "values"' .
         ' JOIN states ON states.id = "values".state_id' .
         ' JOIN machines ON machines.id = "values".machine_id' .
@@ -63,9 +63,9 @@ class MyDB extends SQLite3 {
     return $result['value_id'];
   }
   function add_key_for($machine, $state) {
-    $key_id = add_key();
-    $value_id = get_value_id_of($machine, $state);
-    $stm = $db -> prepare(
+    $key_id = $this -> add_key();
+    $value_id = $this -> get_value_id_of($machine, $state);
+    $stm = $this -> prepare(
       'INSERT INTO permissions (key_id, value_id) VALUES (:key,:value)');
     $stm -> bindValue('value', $value_id);
     $stm -> bindValue('key', $key_id);