<?php
$keyword = "%$keyword%";
if($opt1 === 'search'):
	$stmt = $mysqli->prepare("SELECT * FROM $table WHERE nicename LIKE ?") or die($mysqli->error);
	$stmt->bind_param('s', $keyword);
	$stmt->execute();
	$stmt->store_result();
	$total_rows = $stmt->num_rows();
	$stmt->close();
else:
	$stmt = $mysqli->prepare("SELECT * FROM $table") or die($mysqli->error);
	$stmt->execute();
	$stmt->store_result();
	$total_rows = $stmt->num_rows();
	$stmt->close();
endif;

$pagination = pagination($total_rows, $page_number, $item_per_page);
echo <<<EOJ
<div class="head">
	<input type="submit" value="" class="action ico delete hidden" onclick="setopt(this, 'delete', 'Do you really want to delete?')" />
	<input type="submit" value="save changes" class="action b hidden" onclick="setopt(this, 'savechanges')" />
	<div class="fl hf">
		<input type="text" name="country" placeholder="Country Name" class="field lg" onkeypress="return (event.keyCode!=13)" />
		<input type="submit" value="add new" class="action" onclick="setopt(this, 'add')" />
	</div>
	<div class="fr">{$pagination}</div>
</div>
<table border="0" cellpadding="0" cellspacing="0" class="table">
	<thead>
	<tr>
	<th align="center" valign="middle" class="xs"><input type="checkbox" name="select_all" id="select_all" value="" /></th>
	<th align="center" valign="middle" class="xs">s. no.</th>
	<th align="center" valign="middle" class="sm">iso</th>
	<th align="left" valign="middle">name</th>
	<th align="left" valign="middle">nicename</th>
	<th align="center" valign="middle" class="sm">iso 3</th>
	<th align="center" valign="middle" class="sm">num code</th>
	<th align="center" valign="middle" class="sm">phone code</th>
	</tr>
	</thead>
	<tbody>
EOJ;
	if($opt1 === 'search'):
		$stmt = $mysqli->prepare("SELECT $firstcol, iso, name, nicename, iso3, numcode, phonecode FROM $table WHERE nicename LIKE ? ORDER BY nicename ASC LIMIT $page_position, $item_per_page") or die($mysqli->error);
		$stmt->bind_param('s', $keyword);
	else:
		$stmt = $mysqli->prepare("SELECT $firstcol, iso, name, nicename, iso3, numcode, phonecode FROM $table ORDER BY nicename ASC LIMIT $page_position, $item_per_page") or die($mysqli->error);
	endif;
	$stmt->execute();
	$stmt->store_result();
	if($stmt->num_rows() > 0):
		$stmt->bind_result($id, $iso, $name, $nicename, $iso3, $numcode, $phonecode);
		while($stmt->fetch()):
			$snum = ($page_number == 1) ? $snum + 1 : $page_position++ + 1;
echo <<<EOJ
			<tr>
			<td align="center" valign="middle"><input type="checkbox" name="dataid[]" value="{$id}" class="checkbox"  /></td>
			<td align="center" valign="middle">{$snum}</td>
			<td align="center" valign="middle">{$iso}</td>
			<td align="left" valign="middle">{$name}</td>
			<td align="left" valign="middle">
				<input type="text" name="nicename[$id]" value="{$nicename}" class="field noborder" onfocus="checkbox(this)" onkeypress="return (event.keyCode!=13)" />
			</td>
			<td align="center" valign="middle">{$iso3}</td>
			<td align="center" valign="middle">{$numcode}</td>
			<td align="center" valign="middle">{$phonecode}</td>
			</tr>
EOJ;
		endwhile;
		$stmt->close();
	else:
		echo '<tr><td align="center" valign="middle" colspan="8">' . $emptyrows . '</td></tr>';
	endif;
echo '</tbody>';
echo '</table>';
?>