<?php
echo <<<EOJ
<div class="head">
	<input type="submit" name="submit" value="submit" class="action b" onclick="setopt(this, 'runquery')" />
</div>
<fieldset class="body sql">
	<legend>Run SQL query on database <a href="{$adminurl}u/dashboard">{$dbname}</a></legend>
	<div class="fl">
		<textarea rows="5" cols="5" name="query" autocomplete="off" class="field lg">SELECT * FROM `` WHERE 1</textarea>
	</div>
	<div class="fr tbllist">
EOJ;
		echo '<ul class="fluid">';
		$check_tables = $mysqli->query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{$dbname}'") or die($mysqli->error);
		while($get_tables = $check_tables->fetch_array()):
			echo '<li>' . $get_tables[0] . '</li>';
		endwhile;
		$check_tables->close();
		echo '</ul>';
echo <<<EOJ
	</div>
</fieldset>
<fieldset class="body sql add">
	<legend>Add Column</legend>
	<select name="table_name" class="field f" onchange="dopost('getcolumn', this.value)">
		<option value="" selected="selected">Select Table</option>
EOJ;
			$stmt = $mysqli->prepare("SELECT TABLE_NAME AS table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ?") or die($mysqli->error);
			$stmt->bind_param('s', $dbname);
			$stmt->execute();
			$stmt->bind_result($table);
			while($stmt->fetch()):
				echo '<option value="' . $table . '">' . $table . '</option>';
			endwhile;
			$stmt->close();
echo <<<EOJ
	</select>
	<input type="text" name="num_fields" value="1" maxlength="2" class="field digit" onfocus="this.select()" onpaste="return false" />
	<div class="rw"><label><input type="radio" name="field_where" value="last" checked="checked" />at end of table</label></div>
	<div class="rw"><label><input type="radio" name="field_where" value="first" />at beginning of table</label></div>
	<div class="rw"><label><input type="radio" name="field_where" value="after" />after</label></div>
	<select name="after_field" class="field l collist" onclick="this.form.field_where[2].checked=true" onchange="this.form.field_where[2].checked=true"></select>
	<input type="submit" name="submit" value="go" class="action" onclick="setopt(this, 'addcolumn')" />
</fieldset>
<div class="fluid sql l"></div>
EOJ;
?>