<?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;
echo <<<EOJ
<div class="head">
	<div class="fieldbox left">
		<input type="text" name="country" placeholder="Country Name" class="grey lighten-2" onkeypress="return (event.keyCode!=13)" />
		<button type="submit" class="waves-effect btn-flat green right" style="margin:0 8px" onclick="sOPT('addcountry', '')">add new</button>
	</div>
	<button type="submit" class="waves-effect btn-flat blue accent-3 h" onclick="sOPT('savechanges', '')">save changes</button>
	<button type="submit" class="waves-effect btn-flat h" onclick="sOPT('delete', 'Do you really want to delete?')"><i class="material-icons">delete</i></button>
	{$pagination->get($total_rows, $page_number, $item_per_page)}
</div>
<table border="0" cellpadding="0" cellspacing="0" class="table">
	<thead>
	<tr>
	<th class="xs center-align"><input type="checkbox" name="checkall" id="checkall" value="" /></th>
	<th class="xs center-align">s. no.</th>
	<th class="sm center-align">iso</th>
	<th>name</th>
	<th>nicename</th>
	<th class="sm center-align">iso 3</th>
	<th class="sm center-align">num code</th>
	<th class="sm center-align">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 class="center-align"><input type="checkbox" name="dataid[]" value="{$id}" class="checkbox" /></td>
			<td class="center-align">{$snum}</td>
			<td class="center-align">{$iso}</td>
			<td>{$name}</td>
			<td><input type="text" name="nicename[$id]" value="{$nicename}" /></td>
			<td class="center-align">{$iso3}</td>
			<td class="center-align">{$numcode}</td>
			<td class="center-align">{$phonecode}</td>
			</tr>
EOJ;
		endwhile;
	else:
		echo '<tr><td colspan="8">'.$emptyrows.'</td></tr>';
	endif;
	$stmt->close();
echo '</tbody>';
echo '</table>';
?>