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

$query = isset($_GET['q']) ? strip_tags(sanitize(escape($_GET['q']))) : NULL;
if($query):
	$like = "%$query%";
	$stmt = $mysqli->prepare("SELECT archive.archivesid, archive.doi, archive.year, archive.refnumber, archive.volume, archive.issue, archive.part, archive.title, archive.authorname, archive.abstract, archive.file, archive.supplementaryfile, archive.country, archive.pagenumber, archive.views, archive.downloads FROM archives as archive LEFT JOIN archiveauthors as archiveauthor ON archive.archivesid = archiveauthor.archiveid WHERE (archive.refnumber = ? OR STRIP_TAGS(archive.title) LIKE ? OR archive.authorname LIKE ? OR archive.abstract LIKE ? OR archive.keywords LIKE ? OR archive.country LIKE ? OR archive.mobile LIKE ? OR archive.email LIKE ? OR archiveauthor.name LIKE ? OR archiveauthor.email LIKE ? OR archiveauthor.phone LIKE ?) AND (archive.status = 'enabled') GROUP BY archive.archivesid ORDER BY archive.creation DESC") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('sssssssssss', $query, $like, $like, $like, $like, $like, $like, $like, $like, $like, $like);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
else:
	$count_rows = 0;
endif;
if($count_rows > 0):
echo <<<EOJ
	<div class="fluid">Results: <b>{$count_rows}</b>, Query: <b>{$query}</b></div>
	<table border="0" cellpadding="0" cellspacing="0" class="fluid articles">
	<tr>
	<th align="center" valign="middle" class="xs">S. No.</th>
	<th align="left" valign="middle">Title and Authors Name</th>
	<th align="center" valign="middle" class="sm">Country</th>
	</tr>
EOJ;
	$snum = 1;
	$stmt->bind_result($archivesid, $doi, $year, $refnumber, $volume, $issue, $part, $title, $authorname, $abstract, $file, $supplementaryfile, $country, $pagenumber, $views, $downloads);
	while($stmt->fetch()):
		$title = strip_tags($title, '<i><em><sup><sub><img>');
		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):echo '<div class="row" style="font-size:12px"><b>DOI: <a href="https://doi.org/'.$doi.'" target="_blank">'.$doi.'</a></b></div>';endif;
		echo '<div class="row link">';
		if($abstract):
			echo '<a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.strtolower($part).'.'.$archivesid.'">[<b>ABSTRACT</b>]</a>';
		endif;
		if(($file && file_exists($archiveuploadpath.$file))):
			echo '<a href="'.$baseurl.'articles/'.$archivesid.'/'.$file.'" id="'.$archivesid.'" class="download" target="_blank">[<b>DOWNLOAD</b>]</a>';
		endif;
		if(($supplementaryfile && file_exists($archiveuploadpath.$supplementaryfile))):
			echo '<a href="'.$baseurl.'articles/'.$archivesid.'/'.$supplementaryfile.'" id="'.$archivesid.'" class="download" target="_blank">[<b>SUPPLEMENTARY FILE</b>]</a>';
		endif;
		echo '</div>';
		echo '<div class="row foot">';
		echo 'Pages: '.$pagenumber.'&nbsp;&nbsp;|&nbsp;&nbsp;<b>'.$views.'</b> Views&nbsp;&nbsp;<b>'.$downloads.'</b> Downloads<span>&nbsp;&nbsp;|&nbsp;&nbsp;Country: '.$country.'</span>&nbsp;&nbsp;|&nbsp;&nbsp;<b>'.$year.'</b>, Vol. <b>'.$volume.'</b>, Issue <b>'.$issue.'</b>, Part <b>'.$part.'</b>';
		echo '</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');
?>