PHP Classes

File: showfields.php

Recommend this page to a friend!
  Classes of Marius  >  dbFile  >  showfields.php  >  Download  
File: showfields.php
Role: Application script
Content type: text/plain
Description: showfields.php
Class: dbFile
file based web database and Administrator
Author: By
Last change:
Date: 18 years ago
Size: 3,104 bytes
 

Contents

Class file image Download
<!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>

For more information send a message to info at phpclasses dot org.