Login   Register  
PHP Classes
elePHPant
Icontem

File: viewrecord.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Marius  >  dbFile  >  viewrecord.php  >  Download  
File: viewrecord.php
Role: Application script
Content type: text/plain
Description: viewrecord.php
Class: dbFile
file based web database and Administrator
Author: By
Last change:
Date: 2004-04-19 04:53
Size: 1,532 bytes
 

Contents

Class file image Download
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
    <title>Record overview for table <?php print("$TABLE"); ?></title>
            <link rel="stylesheet" href="settings.css" type="text/css">
</head>

<body>
<center>
Record overview for table <font color=#FF0000><?php print("$TABLE"); ?></font><br><br>
<?php

include("common.inc");
$dbf->select_db($DB);
$query = "SELECT * FROM $TABLE";
$result = $dbf->query($query) or die("ERROR while showing records");
$num_fields = $dbf->num_fields($result);
$res = $dbf->list_fields($DB,$TABLE);
$fields = sizeof($res);

print("<table width=\"100%\" border=0 nowrap><tr bgcolor=\"#000080\">");
$i = 0;
while ($i < $fields) {
    $type  = $res[$i]['type'];
    $name  = $res[$i]['field'];
    $len   = $res[$i]['size'];
    $flags = $res[$i]['flags'];
//        print("<td valign=top>$name<br><font color=\"#ffff00\">$type($len $flags)</font></td>");
        print("<td width=\"$len\" valign=top><font color=\"#ffffff\">$name</font></td>");
$i = $i + 1;
}
print("</tr>");

$query = "SELECT * FROM $TABLE";
$result = $dbf->query($query) or die("ERROR while showing records");
$num_row = $dbf->num_rows($result);

while($row = $dbf->fetch_array($result)) {
    print("<tr bgcolor=\"#e7e7e7\">");
        $ar = array_values($row);
        for($column_num = 0; $column_num < $fields; $column_num++) {
            print("<td valign=top><font color=\"#000000\">$ar[$column_num]</font></td>");
        }
    print("</tr>");
}
print("</table>");
?>
</center>

</body>
</html>