function drawTableTopSQL($table, $oldwhere = '', $tablename = '')
{
$keylist = array('' => '');
foreach ($table as $key => $data) {
if ($key[0] != '_') {
$keylist[$key] = $data['longname'];
}
}
echo '<form action="view.php" method="POST" class="title">';
echo hiddeninput('table', $tablename);
echo html_form_label('orderbycol', 'Sort:');
echo selectinput('orderbycol', $keylist);
echo html_form_label('wherecol', 'Search:');
echo selectinput('wherecol', $keylist);
$searchtypes = array('substring' => 'Substring', 'sqlregex' => 'SQL Regex', 'gnuregex' => 'GNU Regex');
echo selectinput('wherefunc', $searchtypes);
echo textinput('wheredata', '', 16);
echo hiddeninput('wherecurrent', $oldwhere);
echo submitinput('refresh', 'Refresh');
echo '</form>';
}
function undobox($name)
{
return submitinput('undo_' . $name, 'U');
}
if ($editData === $MySQL_singleton_abort) {
die("Data abort! Query: {$query}\n");
}
echo hiddeninput(fieldName($tableName, $tableData[$tableName]['_idkey']), $idEdit);
}
echo hiddeninput('table', $tableName);
echo hiddeninput('perm', $perm);
echo "\n";
?>
<table class="dataform">
<?php
$data = NULL;
if ($editData !== NULL) {
$data = $editData;
}
foreach ($tableData[$tableName]['_view_cols'] as $itemkey) {
formelement($tableName, $tableData, $itemkey, $data);
}
?>
</table>
<?php
echo submitinput('submit', 'Submit') . "\n";
?>
</form>
<?php
//TODO
} else {
echo __FILE__ . ' permission denied';
}
include './footer.inc.php';
/* vim: set ft=php expandtab shiftwidth=4 softtabstop=4 tabstop=4: */
</td>
<td>
<?php
echo passwordinput('password', '', 32);
?>
</td>
</tr>
<tr>
<td>
<label for="mode">Mode</label>
</td>
<td>
<?php
echo selectinput('mode', array('normal' => 'Normal', 'kiosk' => 'Kiosk'), 'normal');
?>
</td>
</tr>
<tr>
<td colspan="2">
<?php
echo submitinput('login', 'Login');
?>
</td>
</tr>
</table>
</form>
<?php
/* vim: set ft=php expandtab shiftwidth=4 softtabstop=4 tabstop=4: */