start database (user and post), and initial barebones home page

1 files changed, 19 insertions, 0 deletions

diff --git a/web/routes/home/model.php b/web/routes/home/model.php
new file mode 100644
index 0000000..44a8549
--- /dev/null
+++ b/web/routes/home/model.php
@@ -0,0 +1,19 @@
+<?php /* Copyright (c) 2024 Freya Murphy */
+class HomeModel extends Model {
+
+	private function get_posts() {
+		return $this->db
+			->select('*')
+			->from('admin.post')
+			->limit(20)
+			->rows();
+	}
+
+	public function get_data() {
+		$data = parent::get_data();
+		$data['title'] = lang('title');
+		$data['posts'] = $this->get_posts();
+		return $data;
+	}
+}
+?>