Location: PHPKode > projects > SQLite PHP Admin > spa/tpl/en/db/dbase.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML %%version_%% Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-Transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<link href="pla.css" rel="stylesheet" type="text/css" />
	<title>SQLite PHP Admin - Database information</title>
	<meta http-equiv="expires" content="0" />
	<meta http-equiv="pragma" content="no-cache" />
	<meta http-equiv="cache-control" content="no-cache" />
	<base target="mainframe" />
</head>
<body class="right">
<h3>SQLite PHP Admin %%version_%%</h3>
<< print_dbinfo() >>
<br />
<table class="dbinfotable">
	<tr><th colspan="2">Database file information</th></tr>
	<tr><th>Size</th><td>%%size%% KB</td></tr>
	<tr><th>Last modification</th><td>%%last_mod%%</td></tr>
<<'%%uname%%'?'
	<tr><th>Owner</th><td>%%uname%%</td></tr>
	<tr><th>Group</th><td>%%group%%</td></tr>':''>>
	<tr><th>Access</th><td>%%rwd%%</td></tr>
</table>
<br />
<h3>%%numtbls%% table(s)</h3>
<<'%%tables%%'?'
<table id="tabletable">
<tr><th>Name</th><th>Rows</th><th>Action</th></tr>
%%tables%%
</table><br />':''>>
<h3>Database operations</h3>
<form action="tbaction.php" method="post">
<table>
<tr><th>Create a new table </th>
<td><input title="Enter new table name" type="text" name="tablename" value="" size="20" /> with
<< select_numbers() >> column(s)
	<input type="submit" name="submit" value="&gt;&gt;" />
</td></tr></table></form>
<form action="dbaction.php" method="post" target="_top">
<table>
	<tr><td colspan="2">
<input type="button" name="schema" value="Show dbase schema" onclick="self.document.location='dbaction.php?action=schema';" />&nbsp;
<input type="button" value="Optimize database" onclick="if(confirm('Vacuum the database %%bname%%?')) self.document.location='dbaction.php?action=vacuum';" />&nbsp;<input type="button" value="Drop database" onclick="if(confirm('Drop the database %%bname%%?')) self.document.location='dbaction.php?action=drop';" />
	</td></tr>
	<tr><td colspan="2">
		<input type="button" name="" value="Export database" onclick="self.document.location='export.php';" />
		<input type="button" name="" value="Import" onclick="self.document.location='import.php';" />
	</td></tr>
<tr><th>Move database to</th><td>
<input title="Enter new database name" type="text" name="mvdbname" value="%%mvdb%%" size="50" />&nbsp;<input type="submit" value="&gt;&gt;" onclick="this.name='move'" /></td></tr>
<tr><th>Copy database to</th><td>
<input title="Enter new database name" type="text" name="cpdbname" value="%%cpdb%%" size="50" />&nbsp;<input type="submit" value="&gt;&gt;" onclick="this.name='copy'" /></td></tr>
</table></form>
</body>
</html>
Return current item: SQLite PHP Admin