{% extends theme/search-results.html %}

{% block title %} {{ $query }} - Search Results {% endblock %}

{% block navigation %}
<ul class="navbar-nav">
	<li class="nav-item">
		<a href="{{ $basehost }}" class="nav-link {% if(!$currentCategory) { %}active{% } %}">
			Home
		</a>
	</li>
	{%
		$categoriesQuery = $db->query("SELECT * FROM `categories` ORDER BY `order` ASC");
		while($category = $categoriesQuery -> fetchArray(SQLITE3_ASSOC)){
	%}
	<li class="nav-item">
		<a href="{{ $basehost }}/{{ $category['slug'] }}/" class="nav-link {% if($currentCategory == $category['slug']) { %}active{% } %}">
			{{ $category['name'] }}
		</a>
	</li>
	{%
		}
	%}
</ul>
{% endblock %}

{% block content %}
{%

	if(strlen($query) > 3) {
	$searchResultsQuery = $db->query("select articles.id, articles.category_id, articles.slug as slug, articles.title as title, articles.excerpt as excerpt, articles.image as image, articles.created as created, authors.name as authorname, authors.linkedin as linkedin, authors.slug as authorslug, categories.name as category_name, categories.slug as category_slug from articles, authors, categories where articles.author_id = authors.id and articles.category_id = categories.id and (articles.html LIKE '%" . $query . "%' OR articles.title LIKE '%" . $query . "%') ORDER BY articles.created DESC");

	$searchCheckQuery = $db->query("select count(articles.id) as count, articles.id, articles.category_id, articles.slug as slug, articles.title as title, articles.excerpt as excerpt, articles.image as image, articles.created as created, authors.name as authorname, authors.linkedin as linkedin, authors.slug as authorslug, categories.name as category_name, categories.slug as category_slug from articles, authors, categories where articles.author_id = authors.id and articles.category_id = categories.id and (articles.html LIKE '%" . $query . "%' OR articles.title LIKE '%" . $query . "%') ORDER BY articles.created DESC");
	$numRowsArray = $searchCheckQuery->fetchArray();
	$numRows = $numRowsArray['count'];

	if($numRows > 0) {
		while($searchResults = $searchResultsQuery -> fetchArray(SQLITE3_ASSOC)){
%}
<div class="single-overview-news">
	<div class="row align-items-center">
		<div class="col-lg-4">
			<div class="overview-news-image">
				<a href="{{ $basehost }}/{{ $searchResults['category_slug'] }}/{{ $searchResults['slug'] }}.html">
					<img src="{{ $basehost }}/data/images/thumb-610-{{ $searchResults["image"] }}" alt="image">
				</a>
			</div>
		</div>

		<div class="col-lg-8">
			<div class="overview-news-content mt-0">
				<span>{{ $searchResults['category_name'] }}</span>
				<h3>
					<a href="{{ $basehost }}/{{ $searchResults['category_slug'] }}/{{ $searchResults['slug'] }}.html">{{ $searchResults['title'] }}</a>
				</h3>
				<p>{{ $searchResults['excerpt'] }}</p>
				<p>{{ date("d F, Y", strtotime($searchResults['created'])) }}</p>
			</div>
		</div>
	</div>
</div>
{%
	}
} else {	
%}
<p>No articles matching your criteria found</p>
{%
	}
	
	} else {
%}
<p>Query is too short</p>
{%
	}
%}
{% endblock %}