Location: PHPKode > projects > SQLite PHP Admin > spa/tpl/en/table/tinfo.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: Table info</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 />
<< top_links('%%table%%') >>
<h3>Table '%%table%%' (%%ccolumns%% columns, %%numrows%% rows)</h3>
<table border="1">
<tr><th>&nbsp;</th><th>&nbsp;</th><th>Column</th><th>Type</th><th>Null</th><th>Default value</th></tr>
%%cols%%
</table>
<!-- <h3>Rows in table: %%numrows%%</h3> -->
<h3>Indexes</h3>
<<'%%cidx%%'?'
<table>
	<tr><th>&nbsp;</th><th>Index name</th><th>Unique?</th></tr>
	%%idx%%
</table>
':'
<p><img class="absmid" src="images/newdb.png" alt="empty" />&nbsp;Table has no indexes</p>
'>>
<h3>Table operations</h3>
<form action="tbaction.php" method="get">
<table>
 <tr><td>
 	<button type="button" onclick="self.document.location='tbaction.php?table=%%utable%%&amp;action=schema'">
	<img src="images/query.png" alt="scheme" /> Show table schema</button>&nbsp;
	<button type="button" onclick="if(confirm('Delete all data from table %%table%%?'))self.document.location='dbaction.php?action=empty_table&amp;object=%%utable%%'">
	<img src="images/tb_empty.png" alt="empty" /> Empty table</button>&nbsp;
	<button type="button" onclick="if(confirm('Really DROP table %%table%%?'))top.document.location='dbaction.php?action=drop_table&amp;object=%%utable%%'">
	<img src="images/tb_drop.png" alt="drop" /> Drop table</button>
	<!-- <a href="" target="_top" onclick="return confirm('');"></a>-->
 </td></tr>
 <tr><td>
	Add&nbsp;<< select_numbers() >> column(s)&nbsp;<< put_addfileds('%%columns%%') >>
	<input type="hidden" name="action" value="add_col" />
	<input type="hidden" name="table" value="%%utable%%" />
	&nbsp;<input type="submit" name="submit" value="&gt;&gt;" />
 </td></tr>
 </table>
</form>
<form action="tbaction.php" method="get" target="_top">
<table>
<tr><td>
	<b><big>Rename table to</big></b> <input type="text" size="30" name="newname" />
	&nbsp;<input type="submit" name="rename" value="&gt;&gt;" onclick="return(confirm('Really rename?'));" />
	<input type="hidden" name="table" value="%%utable%%" />
 </td></tr>
 </table>
</form>
<form action="dbaction.php" method="get"><table>
	<tr><th colspan="2">Create new index</th></tr>
	<tr><td colspan="2"><b>Index name</b> <input type="text" name="object" size="20" /><input type="hidden" name="action" value="new_index" /><input type="hidden" name="table" value="%%table%%" />&nbsp;<b>Unique?</b> <input type="checkbox" name="unique" /></td></tr>
	<tr><td width="50%"><b>On column(s)</b></td><td><< select_columns('%%columns%%') >></td></tr>
	<tr align="center"><th colspan="2"><input type="submit" value="Create" /></th></tr>
</table></form>

<br />
<br />
</body>
</html>
Return current item: SQLite PHP Admin