feat(models): Separate user and webpage out of database

1 files changed, 29 insertions, 0 deletions

diff --git a/models/user.php b/models/user.php
new file mode 100644
index 0000000..72933f9
--- /dev/null
+++ b/models/user.php
@@ -0,0 +1,29 @@
+<?php
+namespace Database;
+use PDO;
+
+class User extends Table {
+    public $UID;
+    public $Username;
+    public $Password;
+    public $Role;
+
+    static function create(string $Username, string $Password, string $Role) : int {
+        return Table::_create(
+            "Users",
+            "(Username, Password, Role)",
+            "(\"$Username\", \"$Password\", \"$Role\")",
+        );
+    }
+
+    function fromDB(string $username) : User {
+        return Table::_fromDB(
+            "SELECT * FROM Users WHERE Username = \"$username\"",
+            "Database\User"
+        );
+    }
+
+    static function get_all() : array {
+        return Table::_get_all("Users", "Database\User");
+    }
+}