From 68fc9e55e538e03f94509731ab41a0c8cf96710f Mon Sep 17 00:00:00 2001
From: George Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Mon, 17 Apr 2023 12:12:22 +0300
Subject: setup a real server environment (apache DocumentRoot=/var/www/public)

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

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

diff --git a/public/app/models/cms/Page_model.php b/public/app/models/cms/Page_model.php
new file mode 100644
index 0000000..fda5fb1
--- /dev/null
+++ b/public/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