From 7076343338ae3439f3c86f01144818abe8c31978 Mon Sep 17 00:00:00 2001
From: George Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Sun, 12 Mar 2023 07:16:23 +0200
Subject: add container helpers; constuct public directory-tree

---
 html/app/models/cms/Page_model.php | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 html/app/models/cms/Page_model.php

(limited to 'html/app/models/cms/Page_model.php')

diff --git a/html/app/models/cms/Page_model.php b/html/app/models/cms/Page_model.php
new file mode 100644
index 0000000..fda5fb1
--- /dev/null
+++ b/html/app/models/cms/Page_model.php
@@ -0,0 +1,18 @@
+<?php
+
+namespace app\models\cms;
+
+use \Registry;
+
+class Page_model
+{
+    public static function fromUrl($url)
+    {
+        return Registry::use('database')->query(
+            "SELECT * FROM pages
+                WHERE FullFriendlyUrl = :url AND IsActive = 1",
+            [ ':url' => $url ]
+        )->getFirst();
+    }
+
+}
\ No newline at end of file
-- 
cgit v1.2.3