<?php
$stmt = $mysqli->prepare("SELECT $firstcol, websitename, websiteemail, fromname, fromemail, impactfactor, issn, certificateemail, version, mailer, phones, extensions, signaturestatus, signature FROM $table ORDER BY $firstcol DESC LIMIT 1") or die($mysqli->error);
$stmt->execute();
$stmt->store_result();
$count_rows = $stmt->num_rows();
$stmt->bind_result($id, $websitename, $websiteemail, $fromname, $fromemail, $impactfactor, $issn, $certificateemail, $version, $mailer, $phones, $extensions, $signaturestatus, $signature);
$stmt->fetch();
$stmt->close();
if($count_rows == 0):
	$signaturestatus = 'enabled';$mailer = 'amazon';
endif;
$signaturestatus = ($signaturestatus == 'enabled') ? 'checked' : '';
$amazon = ($mailer == 'amazon') ? 'checked' : '';
$phpmailer = ($mailer == 'phpmailer') ? 'checked' : '';
echo <<<EOJ
<input type="hidden" name="dataid" value="{$id}" readonly="readonly" />
<div class="head">
	<input type="submit" value="submit" class="action b button" onclick="setopt(this, 'edit')" />
	<input type="reset" value="reset" class="action" />
	<div class="fr hf">
		<input type="text" name="row" value="{$item_per_page}" class="field xs digit" onfocus="this.select()" onpaste="return false" onkeypress="return (event.keyCode!=13)" />
		<input type="submit" value="GO" class="action" onclick="setopt(this, 'setrows')" />
	</div>
</div>
<div class="body">
	<div class="row">
		<div class="fl">
			<label class="flbl">Website Name :<span class="fr">*</span></label>
			<input type="text" name="websitename" value="{$websitename}" class="field" />
		</div>
		<div class="fr">
			<label class="flbl">Website Email <small>(Multiple emails should be seperate by comma)</small>:<span class="fr">*</span></label>
			<input type="text" name="websiteemail" value="{$websiteemail}" class="field" />
		</div>
	</div>
	<div class="row">
		<div class="fl">
			<label class="flbl">From Name :<span class="fr">*</span></label>
			<input type="text" name="fromname" value="{$fromname}" class="field" />
		</div>
		<div class="fr">
			<label class="flbl">From Email <small>(Only one email allowed)</small>:<span class="fr">*</span></label>
			<input type="text" name="fromemail" value="{$fromemail}" class="field" />
		</div>
	</div>
	<div class="row">
		<div class="fl">
			<label class="flbl">Impact Factor :</label>
			<input type="text" name="impactfactor" value="{$impactfactor}" class="field" />
		</div>
		<div class="fr">
			<label class="flbl">ISSN :</label>
			<input type="text" name="issn" value="{$issn}" class="field" />
		</div>
	</div>
	<div class="row">
		<div class="fl">
			<label class="flbl">Certificate Email :</label>
			<input type="text" name="certificateemail" value="{$certificateemail}" class="field" />
		</div>
		<div class="fr">
			<label class="flbl">cPanel Version :<span class="fr">*</span></label>
			<input type="text" name="version" value="{$version}" class="field dotdig" onpaste="return false" />
		</div>
	</div>
	<div class="row">
		<div class="fl">
			<label class="flbl">cPanel Login Phones <small>(Multiple phones should be seperate by comma)</small>:<span class="fr">*</span></label>
			<input type="text" name="phones" value="{$phones}" class="field phone" />
		</div>
		<div class="fr">
			<label class="flbl">Extensions <small>(Multiple extensions should be seperate by comma)</small>:</label>
			<input type="text" name="extns" value="{$extensions}" class="field" />
		</div>
	</div>
	<div class="row">
		<div class="fl">
			<label class="flbl">Signature <small>(Appended at the end of all outgoing messages)</small>:<span class="fr">*</span></label>
			<textarea rows="5" cols="5" name="signature" class="field lg">{$signature}</textarea>
		</div>
		<div class="fr">
			<div class="rw">
				<label><input type="checkbox" name="signstatus" value="enabled" {$signaturestatus} />signature status</label>
			</div>
			<div class="rw">
			<label><input type="radio" name="mailer" value="amazon" {$amazon} />amazon</label>
			<label><input type="radio" name="mailer" value="phpmailer" {$phpmailer} />phpmailer</label>
			</div>
		</div>
	</div>
</div>
EOJ;
?>