get_machines new

1 files changed, 7 insertions, 0 deletions

diff --git a/html/db.php b/html/db.php
index 4c4fdc7..9830c5b 100644
--- a/html/db.php
+++ b/html/db.php
@@ -57,6 +57,13 @@ class MyDB extends SQLite3 {
     else
       return $result['machine_id'];
   }
+  function get_machines() {
+    $result = $this -> query('SELECT machines.id AS machine_id, machines.name AS machine FROM machines');
+    $return = array();
+    while ($row = $result -> fetchArray())
+      $return[] = $row;
+    return $return;
+  }
   function add_machine($machine) {
     $stm = $this -> prepare('SELECT COUNT(1) FROM machines WHERE machines.name=:name');
     $stm -> bindValue('name', $machine);