<?php
$keyword = "%$keyword%";
if($opt1 === 'search'):
	$stmt = $mysqli->prepare("SELECT * FROM $table WHERE (email LIKE ? OR title LIKE ?)") or die($mysqli->error);
	$stmt->bind_param('ss', $keyword, $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);

function status($status){
	$status_list = array('Pending', 'Under Review', 'Accepted', 'Dues Completed', 'Proof Send', 'Published');
	$lists = '';
	foreach($status_list as $list):
		$selected = ($status == $list) ? 'selected="selected"' : NULL;
		$lists .= '<option value="' . $list . '" ' . $selected .'>' . $list . '</option>';
	endforeach;
	return $lists;
}
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="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="left" valign="middle" class="lg">email</th>
	<th align="left" valign="middle">title</th>
	<th align="center" valign="middle" class="md">status</th>
	<th align="right" valign="middle" class="md">creation</th>
	</tr>
	</thead>
	<tbody>
EOJ;
	if($opt1 === 'search'):
		$stmt = $mysqli->prepare("SELECT $firstcol, email, title, status, creation FROM $table WHERE (email LIKE ? OR title LIKE ?) ORDER BY $firstcol DESC") or die($mysqli->error);
		$stmt->bind_param('ss', $keyword, $keyword);
	else:
		$stmt = $mysqli->prepare("SELECT $firstcol, email, title, status, creation FROM $table ORDER BY $firstcol DESC 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, $email, $title, $status, $creation);
		while($stmt->fetch()):
			$snum = ($page_number == 1) ? $snum + 1 : $page_position++ + 1;
			$status = status($status);
			$creation = dateformat($creation);
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="left" valign="middle">{$email}</td>
			<td align="left" valign="middle">{$title}</td>
			<td align="center" valign="middle">
				<select name="status[$id]" class="field" onchange="checkbox(this)">
					<option value="" selected="selected">Select Status</option>
					{$status}
				</select>
			</td>
			<td align="right" valign="middle">{$creation}</td>
			</tr>
EOJ;
		endwhile;
		$stmt->close();
	else:
		echo '<tr><td align="center" valign="middle" colspan="6">' . $emptyrows . '</td></tr>';
	endif;
echo '</tbody>';
echo '</table>';
?>