<?php
echo <<<EOJ
	<div class="head">
		<input type="submit" value="Download DOI XML" class="action" onclick="setopt(this, 'downloaddoixml')" />
		<input type="submit" value="find non activated dois" class="action" style="background:#f00;color:#fff;" onclick="setopt(this, 'markasactive')" />
	</div>
	<table border="0" cellpadding="0" cellspacing="0" class="table">
		<thead>
			<tr>
				<th align="center" valign="middle" class="xs" nowrap>s. no.</th>
				<th nowrap>Vol. Issue</th>
				<th nowrap>Ref. No.</th>
				<th nowrap>DOI</th>
				<th>Title</th>
			</tr>
		</thead>
		<tbody>
EOJ;
		$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, volume, issue, part, title FROM archives WHERE (doi != '' AND doiactive = 'N' AND status = 'enabled')") or die($mysqli->error);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($id, $doi, $refnumber, $volume, $issue, $part, $title);
			while($stmt->fetch()):
				$snum = ($page_number == 1) ? $snum + 1 : $page_position++ + 1;
				$title = html_entity_decode($title);
?>
				<tr>
					<td align="center" valign="middle" nowrap><?php echo $snum;?></td>
					<td nowrap>Vol. <?php echo $volume . ' Issue ' . $issue . ' Part ' . $part;?></td>
					<td nowrap><?php echo $refnumber;?></td>
					<td nowrap>
						<a href="https://doi.org/<?php echo $doi;?>" target="_blank"><?php echo $doi;?></a>
					</td>
					<td><?php echo html_entity_decode($title);?></td>
				</tr>
<?php
		endwhile;
	else:
		echo '<tr><td colspan="5" align="center" valign="middle">MySQL returned an empty result set (i.e. zero rows).</td></tr>';
	endif;
	$stmt->close();
echo '</tbody>';
echo '</table>';