Implemented: A full-text search functionality for posts and pages in the administration area. In addition, some markup within the "/*/index.php" files of the admin template was re-formatted.

9 files changed, 96 insertions, 6 deletions

diff --git a/template/admin/html/home.php b/template/admin/html/home.php
index f8a45c5..7698035 100644
--- a/template/admin/html/home.php
+++ b/template/admin/html/home.php
@@ -2,7 +2,12 @@
 <p><?=$Language->text('overview_dashboard_desc')?></p>
 
 <h2><i class="fa fa-newspaper-o"></i><?=$Language->text('last_post')?></h2>
-<p><strong><?=$Language->text('posts')?>:</strong> <?=$COUNT['POST']?> | <a href="<?=Application::getAdminURL('post/')?>"><?=$Language->text('post_overview')?></a> | <a href="<?=Application::getAdminURL('post/insert.php')?>"><?=$Language->text('insert')?></a></p>
+<p>
+	<strong><?=$Language->text('posts')?>:</strong> <?=$COUNT['POST']?>
+	| <a href="<?=Application::getAdminURL('post/')?>"><?=$Language->text('post_overview')?></a>
+	| <a href="<?=Application::getAdminURL('post/insert.php')?>"><?=$Language->text('insert')?></a>
+	| <a href="<?=Application::getAdminURL('post/search.php')?>"><?=$Language->text('search')?></a>
+</p>
 <?php if(!empty($LAST['POST'])): ?>
 	<div class="item-container post">
 		<?=$LAST['POST']?>
@@ -12,7 +17,12 @@
 <?php endif; ?>
 
 <h2><i class="fa fa-file-text-o"></i><?=$Language->text('last_page')?></h2>
-<p><strong><?=$Language->text('pages')?>:</strong> <?=$COUNT['PAGE']?> | <a href="<?=Application::getAdminURL('page/')?>"><?=$Language->text('page_overview')?></a> | <a href="<?=Application::getAdminURL('page/insert.php')?>"><?=$Language->text('insert')?></a></p>
+<p>
+	<strong><?=$Language->text('pages')?>:</strong> <?=$COUNT['PAGE']?>
+	| <a href="<?=Application::getAdminURL('page/')?>"><?=$Language->text('page_overview')?></a>
+	| <a href="<?=Application::getAdminURL('page/insert.php')?>"><?=$Language->text('insert')?></a>
+	| <a href="<?=Application::getAdminURL('page/search.php')?>"><?=$Language->text('search')?></a>
+</p>
 
 <?php if(!empty($LAST['PAGE'])): ?>
 	<div class="item-container page">
@@ -23,7 +33,11 @@
 <?php endif; ?>
 
 <h2><i class="fa fa-user"></i><?=$Language->text('last_user')?></h2>
-<p><strong><?=$Language->text('users')?>:</strong> <?=$COUNT['USER']?> | <a href="<?=Application::getAdminURL('user/')?>"><?=$Language->text('user_overview')?></a> | <a href="<?=Application::getAdminURL('user/insert.php')?>"><?=$Language->text('insert')?></a></p>
+<p>
+	<strong><?=$Language->text('users')?>:</strong> <?=$COUNT['USER']?>
+	| <a href="<?=Application::getAdminURL('user/')?>"><?=$Language->text('user_overview')?></a>
+	| <a href="<?=Application::getAdminURL('user/insert.php')?>"><?=$Language->text('insert')?></a>
+</p>
 
 <?php if(!empty($LAST['USER'])): ?>
 	<div class="item-container user">
diff --git a/template/admin/html/page/index.php b/template/admin/html/page/index.php
index dbd5144..1027996 100644
--- a/template/admin/html/page/index.php
+++ b/template/admin/html/page/index.php
@@ -1,4 +1,7 @@
-<h1><i class="fa fa-file-text-o"></i><?=$Language->text('page_overview')?><a class="brackets" href="<?=Application::getAdminURL("page/insert.php")?>"><?=$Language->text('insert')?></a></h1>
+<h1>
+	<i class="fa fa-file-text-o"></i><?=$Language->text('page_overview')?>
+	<a class="brackets" href="<?=Application::getAdminURL("page/insert.php")?>"><?=$Language->text('insert')?></a>
+</h1>
 <p><?=$Language->text('overview_page_desc')?></p>
 
 <div class="item-container page">
diff --git a/template/admin/html/page/search.php b/template/admin/html/page/search.php
new file mode 100644
index 0000000..1a43bf7
--- /dev/null
+++ b/template/admin/html/page/search.php
@@ -0,0 +1,20 @@
+<h1>
+	<i class="fa fa-search"></i><?=$Language->text('title_page_search')?>
+	<a class="brackets" href="<?=Application::getAdminURL("page/insert.php")?>"><?=$Language->text('insert')?></a>
+</h1>
+<p><?=$Language->text('search_page_desc')?></p>
+
+<form id="search-form" method="GET">
+	<div class="flex flex-padding background">
+		<input id="search-text" type="search" name="q" placeholder="<?=$Language->text('placeholder_search')?>" value="<?=escapeHTML($QUERY)?>" />
+	</div>
+	<div class="flex flex-padding background">
+		<input id="update-button" type="submit" value="<?=$Language->text('search')?>" />
+	</div>
+</form>
+
+<div class="item-container post">
+	<?php foreach($PAGES as $page): ?>
+		<?php echo $page; ?>
+	<?php endforeach; ?>
+</div>
\ No newline at end of file
diff --git a/template/admin/html/post/index.php b/template/admin/html/post/index.php
index a78076e..1ae8471 100644
--- a/template/admin/html/post/index.php
+++ b/template/admin/html/post/index.php
@@ -1,4 +1,7 @@
-<h1><i class="fa fa-newspaper-o"></i><?=$Language->text('post_overview')?><a class="brackets" href="<?=Application::getAdminURL("post/insert.php")?>"><?=$Language->text('insert')?></a></h1>
+<h1>
+	<i class="fa fa-newspaper-o"></i><?=$Language->text('post_overview')?>
+	<a class="brackets" href="<?=Application::getAdminURL("post/insert.php")?>"><?=$Language->text('insert')?></a>
+</h1>
 <p><?=$Language->text('overview_post_desc')?></p>
 
 <div class="item-container post">
diff --git a/template/admin/html/post/search.php b/template/admin/html/post/search.php
new file mode 100644
index 0000000..ab021b9
--- /dev/null
+++ b/template/admin/html/post/search.php
@@ -0,0 +1,20 @@
+<h1>
+	<i class="fa fa-search"></i><?=$Language->text('title_post_search')?>
+	<a class="brackets" href="<?=Application::getAdminURL("post/insert.php")?>"><?=$Language->text('insert')?></a>
+</h1>
+<p><?=$Language->text('search_post_desc')?></p>
+
+<form id="search-form" method="GET">
+	<div class="flex flex-padding background">
+		<input id="search-text" type="search" name="q" placeholder="<?=$Language->text('placeholder_search')?>" value="<?=escapeHTML($QUERY)?>" />
+	</div>
+	<div class="flex flex-padding background">
+		<input id="update-button" type="submit" value="<?=$Language->text('search')?>" />
+	</div>
+</form>
+
+<div class="item-container post">
+	<?php foreach($POSTS as $post): ?>
+		<?php echo $post; ?>
+	<?php endforeach; ?>
+</div>
\ No newline at end of file
diff --git a/template/admin/html/user/index.php b/template/admin/html/user/index.php
index b1b4463..e1e24ef 100644
--- a/template/admin/html/user/index.php
+++ b/template/admin/html/user/index.php
@@ -1,4 +1,7 @@
-<h1><i class="fa fa-user"></i><?=$Language->text('user_overview')?><a class="brackets" href="<?=Application::getAdminURL("user/insert.php")?>"><?=$Language->text('insert')?></a></h1>
+<h1>
+	<i class="fa fa-user"></i><?=$Language->text('user_overview')?>
+	<a class="brackets" href="<?=Application::getAdminURL("user/insert.php")?>"><?=$Language->text('insert')?></a>
+</h1>
 <p><?=$Language->text('overview_user_desc')?></p>
 
 <div class="item-container user">
diff --git a/template/admin/lang/de.php b/template/admin/lang/de.php
index ec79d0a..7591a8f 100644
--- a/template/admin/lang/de.php
+++ b/template/admin/lang/de.php
@@ -42,6 +42,12 @@ $LANGUAGE['delete_post_desc'] = 'Falls du diesen Beitrag nicht mehr benötigst k
 $LANGUAGE['delete_user_desc'] = 'Falls du diesen Benutzer nicht mehr benötigst kannst du ihn über den folgenden Button permanent löschen.';
 
 #===============================================================================
+# Search item description
+#===============================================================================
+$LANGUAGE['search_page_desc'] = 'Hier kannst du mit der <em>booleschen Volltextsuche</em> eine Seite suchen (siehe <a href="https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html">MySQL-Dokumentation</a>).';
+$LANGUAGE['search_post_desc'] = 'Hier kannst du mit der <em>booleschen Volltextsuche</em> einen Beitrag suchen (siehe <a href="https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html">MySQL-Dokumentation</a>).';
+
+#===============================================================================
 # Item overview description
 #===============================================================================
 $LANGUAGE['overview_page_desc'] = 'Hier siehst du alle vorhandenen Seiten.';
@@ -107,6 +113,11 @@ $LANGUAGE['login'] = 'Einloggen';
 $LANGUAGE['logout'] = 'Ausloggen';
 
 #===============================================================================
+# Placeholders
+#===============================================================================
+$LANGUAGE['placeholder_search'] = 'Suchbegriff eingeben …';
+
+#===============================================================================
 # Labels
 #===============================================================================
 $LANGUAGE['label_slug'] = 'Slug';
diff --git a/template/admin/lang/en.php b/template/admin/lang/en.php
index d5c189a..63a18f5 100644
--- a/template/admin/lang/en.php
+++ b/template/admin/lang/en.php
@@ -42,6 +42,12 @@ $LANGUAGE['delete_post_desc'] = 'If you do not need this post anymore, you can p
 $LANGUAGE['delete_user_desc'] = 'If you do not need this user anymore, you can permanently delete it by clicking the following button.';
 
 #===============================================================================
+# Search item description
+#===============================================================================
+$LANGUAGE['search_page_desc'] = 'Here you can search a page with the <em>boolean full-text search</em> (see <a href="https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html">MySQL documentation</a>).';
+$LANGUAGE['search_post_desc'] = 'Here you can search a post with the <em>boolean full-text search</em> (see <a href="https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html">MySQL documentation</a>).';
+
+#===============================================================================
 # Item overview description
 #===============================================================================
 $LANGUAGE['overview_page_desc'] = 'Here you can see all existing pages.';
@@ -107,6 +113,11 @@ $LANGUAGE['login'] = 'Login';
 $LANGUAGE['logout'] = 'Logout';
 
 #===============================================================================
+# Placeholders
+#===============================================================================
+$LANGUAGE['placeholder_search'] = 'Enter search term …';
+
+#===============================================================================
 # Labels
 #===============================================================================
 $LANGUAGE['label_slug'] = 'Slug';
diff --git a/template/admin/rsrc/main.css b/template/admin/rsrc/main.css
index fb6a882..0086fbc 100644
--- a/template/admin/rsrc/main.css
+++ b/template/admin/rsrc/main.css
@@ -217,6 +217,11 @@ label:after{content:":";}
 #message-list{margin:0;padding:0.5rem;list-style:none;background:#C45C66;color:#EEE;font-size:0.6rem;}
 
 /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
+/* Search form
+/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
+#search-form{margin-bottom:1rem;}
+
+/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
 /* FontAwesome Main
 /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
 .fa{font:normal normal normal 14px/1 FontAwesome;font-size:inherit;speak:none;display:inline-block;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale}