<?php
if($opt1 && ($opt1 === 'add' OR $opt1 === 'edit')):
	if($opt1 === 'edit' && $opt2):
		$stmt = $mysqli->prepare("SELECT $firstcol, category, text, link, rel, target, catsortnumber, sortnumber FROM $table WHERE $firstcol = ? LIMIT 1") or die($mysqli->error);
		$stmt->bind_param('i', $opt2);
		$stmt->execute();
		$stmt->store_result();
		$count_rows = $stmt->num_rows();
		$stmt->bind_result($id, $category, $text, $link, $rel, $target, $catsortnumber, $sortnumber);
		$stmt->fetch();
		$stmt->close();
		if($count_rows !== 1):
			die('Invalid data selection.');
		endif;
	else:
		$id = '';$category = '';$text = '';$link = '';$rel = 'dofollow';$target = '_blank';$catsortnumber = '';$sortnumber = '';
	endif;

	$dofollow = $rel === 'dofollow' ? 'selected' : '';
	$nofollow = $rel === 'nofollow' ? 'selected' : '';
	$blank = $target === '_blank' ? 'selected' : '';
	$self = $target === '_self' ? 'selected' : '';

	function categories(){
		global $mysqli, $table;$html = '';
		$stmt = $mysqli->prepare("SELECT category FROM $table GROUP BY category ORDER BY category ASC") or die($mysqli->error);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($category);
			while($stmt->fetch()):
				$html .= '<option value="'.$category.'">'.$category.'</option>';
			endwhile;
		endif;
		$stmt->close();
		return $html;
	}
	$categories = categories();
echo <<<EOJ
	<input type="hidden" name="dataid" value="{$id}" readonly="readonly" />
	<div class="head">
		{$back}
		<input type="reset" value="reset" class="action" />
		<input type="submit" value="submit" class="action b button" />
	</div>
	<div class="body white">
		<div class="row">
			<label class="flbl">Category<span class="fr">*</span></label>
			<input type="text" name="category" value="{$category}" class="field" list="categorylist" />
			<datalist id="categorylist">{$categories}</datalist>
		</div>
		<div class="row">
			<div class="fl">
				<label class="flbl">Text<span class="fr">*</span></label>
				<input type="text" name="text" value="{$text}" class="field" />
			</div>
			<div class="fr">
				<label class="flbl">Link<span class="fr">*</span></label>
				<input type="text" name="link" value="{$link}" class="field" />
			</div>
		</div>
		<div class="row">
			<div class="fl">
				<label class="flbl">Rel</label>
				<select name="rel" id="rel" class="field">
					<option value="dofollow" {$dofollow}>dofollow</option>
					<option value="nofollow" {$nofollow}>nofollow</option>
				</select>
			</div>
			<div class="fr">
				<label class="flbl">Target</label>
				<select name="target" id="target" class="field">
					<option value="_blank" {$blank}>_blank</option>
					<option value="_self" {$self}>_self</option>
				</select>
			</div>
		</div>
		<div class="row">
			<div class="fl">
				<label class="flbl">Category Sort Number</label>
				<input type="text" name="catsortnumber" value="{$catsortnumber}" class="field" />
			</div>
			<div class="fr">
				<label class="flbl">Sort Number</label>
				<input type="text" name="sortnumber" value="{$sortnumber}" class="field" />
			</div>
		</div>
	</div>
EOJ;
else:
echo <<<EOJ
	<div class="head white">
		<input type="button" value="create new" class="action g" onclick="gourl('add')" />
		<input type="submit" value="" class="action ico delete hidden" onclick="setopt(this, 'delete', 'Do you really want to delete?')" />
		<input type="submit" value="enabled" class="action hidden" onclick="setopt(this, 'enabled')" />
		<input type="submit" value="disabled" class="action hidden" onclick="setopt(this, 'disabled')" />
	</div>
	<table 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>category</th>
		<th>link</th>
		<th>rel</th>
		<th>target</th>
		<th align="center" valign="middle" style="width:100px">c. sort number</th>
		<th align="center" valign="middle" style="width:100px">sort number</th>
		<th align="center" valign="middle" class="md">status</th>
		<th align="right" valign="middle" class="md">creation</th>
		<th align="center" valign="middle" class="sm">action</th>
		</tr>
		</thead>
		<tbody>
EOJ;
		$stmt = $mysqli->prepare("SELECT $firstcol, category, text, link, rel, target, catsortnumber, sortnumber, status, creation FROM $table ORDER BY id DESC") or die($mysqli->error);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($id, $category, $text, $link, $rel, $target, $catsortnumber, $sortnumber, $status, $creation);
			while($stmt->fetch()):
				$snum = $snum + 1;
				$option = $status === 'enabled' ? 'disabled' : 'enabled';
				$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>{$category}</td>
				<td><a href="{$link}" target="_blank">{$text}</a></td>
				<td>{$rel}</td>
				<td>{$target}</td>
				<td align="center" valign="middle">{$catsortnumber}</td>
				<td align="center" valign="middle">{$sortnumber}</td>
				<td align="center" valign="middle"><button type="button" class="{$status}" onclick="dopost('{$option}', '{$id}')">{$status}</button></td>
				<td align="right" valign="middle">{$creation}</td>
				<td align="center" valign="middle"><button type="button" class="blue-text text-accent-3" onclick="cURL('edit/{$id}')">edit</button></td>
				</tr>
EOJ;
			endwhile;
		else:
			echo '<tr><td colspan="11" align="center" valign="middle">'.$emptyrows.'</td></tr>';
		endif;
		$stmt->close();
	echo '</tbody>';
	echo '</table>';
endif;
?>