<?php
require_once("header.php");
echo $page_content;

$keyword = isset($_GET['keyword']) ? rtrim(strip_tags(sanitize(escape($_GET['keyword']))), '.php') : NULL;
if($keyword):
	$like = "%$keyword%";
	$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, year, volume, issue, part, title, authorname, abstract, file, supplementaryfile, country, pagenumber, views, downloads FROM archives WHERE (doi = ? OR refnumber = ? OR STRIP_TAGS(title) LIKE ? OR authorname LIKE ? OR abstract LIKE ? OR keywords LIKE ? OR country LIKE ? OR mobile LIKE ? OR email LIKE ?) AND (status = ?) ORDER BY creation DESC") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ssssssssss', $keyword, $keyword, $like, $like, $like, $like, $like, $like, $like, $article_status);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
else:
	$count_rows = 0;
endif;
if($count_rows > 0):
	$snum = 0;
	echo '<div class="fluid">Results: <b>' . number_format($count_rows, 0) . '</b>, Query: <b>' . $keyword . '</b></div>';
echo <<<EOJ
	<table border="0" cellpadding="0" cellspacing="0" class="fluid articles">
	<tr>
	<th align="center" valign="middle" class="xs">S. No.</th>
	<th align="center" valign="middle">Title and Authors Name</th>
	<th align="center" valign="middle" class="sm">Country</th>
	</tr>
EOJ;
	$stmt->bind_result($archivesid, $doi, $refnumber, $year, $volume, $issue, $part, $title, $authorname, $abstract, $file, $supplementaryfile, $country, $pagenumber, $views, $downloads);
	while($stmt->fetch()):
		$snum = $snum + 1;
		$title = html_entity_decode($title);
		$title = strip_tags($title, '<i><em><sup><sub><img>');
		$title = preg_replace("/($keyword)/i", "<mark>$1</mark>", $title);
		$authorname = preg_replace("/($keyword)/i", "<mark>$1</mark>", $authorname);
		$country = preg_replace("/($keyword)/i", "<mark>$1</mark>", $country);
		echo "<tr>";
		echo "<td align=\"center\" valign=\"top\" class=\"xs\">{$snum}</td>";
		echo "<td align=\"left\" valign=\"top\">";
		echo "<div class=\"row\"><b>{$title}</b></div>";
		echo "<div class=\"row\">{$authorname}</div>";
		if($doi):
			$doi = preg_replace("/($keyword)/i", "<mark>$1</mark>", $doi);
			echo "<div class=\"row\">";
			echo "<b>DOI:</b>&nbsp;";
			echo "<a href=\"https://doi.org/{$doi}\" target=\"_blank\">https://doi.org/{$doi}</a>";
			echo "</div>";
		endif;
		echo "<div class=\"row link\">";
		if($abstract):
			echo "<a href=\"{$baseurl}archives/{$year}/vol{$volume}issue{$issue}/{$part}/{$refnumber}\">abstract</a>&nbsp;&nbsp;";
		endif;
		$filepath = $archiveuploadpath . $year . '/vol' . $volume . 'issue' . $issue . '/' . $part . '/';
		if(($file && file_exists($filepath . $file))):
			echo "<a href=\"{$baseurl}download/{$archivesid}/{$file}\" target=\"_blank\">download</a>";
		endif;
		if(($supplementaryfile && file_exists($filepath . $supplementaryfile))):
			echo "&nbsp;&nbsp;<a href=\"{$baseurl}download/{$archivesid}/{$supplementaryfile}\" target=\"_blank\">supplementary file</a>";
		endif;
		echo "</div>";
		echo "<div class=\"row\">";
		echo "Pages: <b>{$pagenumber}</b>&nbsp;&nbsp;-&nbsp;&nbsp;Viewed: <b>{$views}</b>";
		echo "&nbsp;&nbsp;-&nbsp;&nbsp;Downloaded: <b>{$downloads}</b>&nbsp;&nbsp;-&nbsp;&nbsp;<b>{$year}</b>, Vol. <b>{$volume}</b>, Issue. <b>{$issue}</b>, Part. <b>{$part}</b>";
		echo "</div>";
		echo "<div class=\"row l\">Country: <b>{$country}</b></div>";
		echo "</td>";
		echo "<td align=\"center\" valign=\"middle\" class=\"sm\">{$country}</td>";
		echo "</tr>";
	endwhile;
	$stmt->close();
	echo "</table>";
else:
	echo "Sorry, nothing matched your search terms. Please try again with different keywords.";
endif;
require_once("footer.php");
?>