PHP Classes

File: viewrecord.php

Recommend this page to a friend!
  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: 18 years ago
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>

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