<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Untitled</title>
<link rel="stylesheet" href="settings.css" type="text/css">
<STYLE>
#divContent {position:absolute; top:0; left:0; width:250px; height: 200px}
</STYLE>
<script language="javascript" src="js/scrollbar3.js"></script>
<script language="JavaScript">
function Open_Win(location) {
var winl = (screen.width - 400) / 2;
var wint = (screen.height - 200) / 2;
win = window.open(location, '', 'width=400, height=200, top='+wint+', left='+winl+', scrollbars=yes')
if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
}
function Open_Win2(location) {
var winl = (screen.width - 600) / 2;
var wint = (screen.height - 500) / 2;
win = window.open(location, '', 'width=600, height=500, top='+wint+', left='+winl+', scrollbars=yes')
if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
}
function Open_Win3(location) {
//var winl = (screen.availWidth - 800) / 2;
//var wint = (screen.availHeight - 640) / 2;
var winl = 10;
var wint = 10;
var winW = (screen.availWidth - 50);
var winH = (screen.availHeight - 50);
win = window.open(location, '', 'width='+winW+', height='+winH+', top='+wint+', left='+winl+', scrollbars=yes')
if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
}
</script>
</head>
<body onload="initScroller();">
<div id="divContent">
<?php
include("common.inc");
$dbf->select_db($DB);
$table = $TABLE;
$db = $dbf->db_return($DB);
$query = "SELECT * FROM $TABLE";
$result = $dbf->query($query) or die("ERROR");
$num_rows = $dbf->num_rows($result);
$res = $dbf->list_fields($db,$table);
$num_record = $dbf->num_rows($result);
$fields = sizeof($res);
$i = 0;
print("<font color=#FF0000>$fields</font> fields, <font color=#FF0000>$num_record</font> records in table $TABLE<br><br><center>");
print("<a href=\"javascript: Open_Win3('viewrecord.php?DB=$DB&TABLE=$TABLE');\">View Records<img src=\"images/view.jpg\" border=0 alt=\"View records in table $TABLE\"></a>");
print("<a href=\"javascript: Open_Win2('addrecord.php?DB=$DB&TABLE=$TABLE');\">Add Records<img src=\"images/add.gif\" border=0 alt=\"Add records to table $TABLE\"></a>");
print("</center><br>");
print("<table border=0>");
while ($i < $fields) {
$type = $res[$i]['type'];
$name = $res[$i]['field'];
$len = $res[$i]['size'];
$flags = $res[$i]['flags'];
print("<tr><td valign=top><font color=#000066>$name</font><font color=#000000>($type $len $flags)</font></td>");
print("<td valign=top><a href=\"javascript: Open_Win('editfield.php?Field=$name&DB=$DB&TABLE=$TABLE&type=$type&flags=$flags&len=$len');\"><img src=\"images/edit.gif\" border=0 alt=\"Edit properties of this field\"></a></td><td valign=top><a href=\"javascript: Open_Win('dropfield.php?Field=$name&DB=$DB&TABLE=$TABLE');\"><img src=\"images/del.gif\" border=0 alt=\"Drop this field\"></a></td></tr>");
$i++;
}
?>
</table>
</div>
</body>
</html>
|
Download
