Файл: MysqlIManager/viewrecord.php
Строк: 55
<!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");
mysql_select_db($DB, $connection);
$query = "SELECT * FROM $TABLE";
$result = mysql_query($query) or die("ERROR while showing records");
$num_record = mysql_num_rows($result);
$num_row = mysql_num_fields($result);
print("<table border=0><tr>");
$i = 0;
while($i < $num_row) {
$column_name = mysql_field_name($result, $i);
$column_type = mysql_field_type($result, $i);
$column_flag = mysql_field_flags($result, $i);
$column_len = mysql_field_len($result, $i);
print("<td valign=top>$column_name<br>$column_type($column_len $column_flag)</td>");
$i = $i + 1;
}
print("</tr>");
while($row = mysql_fetch_row($result)) {
print("<tr>");
for($column_num = 0; $column_num < $num_row; $column_num++) {
print("<td valign=top>$row[$column_num]</td>");
}
print("</tr>");
}
print("</table>");
?>
</center>
</body>
</html>