<?php
require_once('header.php');

$i = 1;
$stmt = $mysqli->prepare("SELECT journal, issn, editorinchief, abbreviation, doi, domain, description, coverpage FROM journals WHERE status = 'enabled'") or die($mysqli->error);
$stmt->execute();
$stmt->store_result();
if($stmt->num_rows() > 0):
	echo '<div class="row journals">';
	$stmt->bind_result($journal, $issn, $editorinchief, $abbreviation, $doi, $domain, $description, $coverpage);
	while($stmt->fetch()):
		$coverpage = $coverpage && file_exists($uploadpath.'journals/'.$coverpage) ? $uploadurl.'journals/'.$coverpage : $imageurl.'avatar.png';
		$issn = $issn ? '<b>'.$issn.'</b><br>' : '';
		$editorinchief = $editorinchief ? '<b>Editor-in-Chief:</b> '.$editorinchief.'<br>' : '';
		$abbreviation = $abbreviation ? '<b>Abbreviation:</b> '.$abbreviation.'<br>' : '';
		$doi = $doi ? '<b>DOI:</b> '.$doi.'<br>' : '';
		$domain = $domain ? '<b>Website:</b> <a href="'.$domain.'" target="_blank" class="blue-text text-darken-4">'.$domain.'</a><br>' : '';
echo <<<EOJ
		<div class="col s12 m12 l6">
			<div class="card">
				<div class="card-content">
					<table>
						<tr>
							<td class="f"><img src="{$coverpage}" alt="{$journal}" class="left" /></td>
							<td class="l">
								<h2>{$journal}</h2>
								{$issn}{$editorinchief}{$abbreviation}{$doi}{$domain}
							</td>
						</tr>
					</table>
				</div>
				<div class="card-action">{$description}</div>
			</div>
		</div>
EOJ;
		$i++;
		if($i % 2):
			echo '</div><div class="row journals">';
		endif;
	endwhile;
	echo '</div>';
endif;
$stmt->close();

require_once('footer.php');
?>