From 944b6b0526032ad8c1b4a2612d6723bec75e0e4c Mon Sep 17 00:00:00 2001
From: Freya Murphy <freya@freyacat.org>
Date: Fri, 29 Mar 2024 22:29:56 -0400
Subject: start database (user and post), and initial barebones home page

---
 web/routes/home/model.php | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 web/routes/home/model.php

(limited to 'web/routes/home/model.php')

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;
+	}
+}
+?>
-- 
cgit v1.2.3-freya