From 677a1b1593d46c39b54e14f78f33b95512155602 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 28 Jul 2022 11:25:46 +0200
Subject: get_machines new

---
 html/db.php | 7 +++++++
 1 file changed, 7 insertions(+)

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);
-- 
cgit v1.2.3-54-g00ecf