database connection and documentation API

1 files changed, 36 insertions, 0 deletions

diff --git a/html/app/models/cms/Media_model.php b/html/app/models/cms/Media_model.php
index e69de29..6a4a681 100644
--- a/html/app/models/cms/Media_model.php
+++ b/html/app/models/cms/Media_model.php
@@ -0,0 +1,36 @@
+<?php
+
+namespace app\models\cms;
+
+use \Registry;
+
+
+class Media_model
+{
+    public static function serve($type, $id, $ticket)
+    {
+
+        // get media data
+        // [ type =>, rights =>, path =>  ]
+
+        // validate ticket
+        // ValidateAccess::for($ticket)
+
+        // serve
+        // header("Content-type: type");
+        // passthru('cat $media_path');
+
+
+        return Registry::use('database')->query(
+            "SELECT * FROM pages
+                WHERE FullFriendlyUrl = :url AND IsActive = 1",
+            [ ':url' => $url ]
+        )->getFirst();
+    }
+
+}
+
+
+
+// check:
+// https://stackoverflow.com/questions/1353850/serve-image-with-php-script-vs-direct-loading-an-image
\ No newline at end of file