📄 rta_view.php
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN"><html><head><title>Table View</title></head><body><?php $tbl = htmlentities($_GET['table']); $offset = htmlentities($_GET['offset']); $nrows = htmlentities($_GET['nrows']); $port = htmlentities($_GET['port']); print("<h3><center>$tbl</center></h3>\n"); // Suppress Postgres error messages error_reporting(error_reporting() & 0xFFFD); // connect to the database $connection = pg_connect("localhost", "$port", "bsmith"); if ($connection == "") { printf("$s%s%s", "Unable to connect to application.<br>", "Please verify that the application is running and ", "listening on port $port.<br>"); exit(); } // print each row in a table print("<center><table border=3 cellpadding=4>\n"); // Get and print column names $command = "SELECT name, flags FROM rta_columns WHERE table = $tbl"; $result = pg_exec($connection, $command); if ($result == "") { print("<p><font color=\"red\" size=+1>SQL Command failed!</p>"); print("<p>Command: $command</p>\n"); exit(); } // A flag to say there's at least one editable column. $readonly = 2; // "2" indicates a read-only column. See rta.h print("<tr>\n"); for($row = 0; $row < pg_NumRows($result); $row++) { $colname = pg_result($result, $row, 0); $colflags = pg_result($result, $row, 1); print("<th>$colname</th>"); $readonly = $readonly & $colflags; } if ($readonly == 0) print("<th> </th>\n"); print("</tr>\n"); pg_freeresult($result); // execute query $command = "SELECT * FROM $tbl LIMIT 20 OFFSET $offset"; $result = pg_exec($connection, $command); if ($result == "") { print("<p><font color=\"red\" size=+1>SQL Command failed!</p>"); print("<p>Command: $command</p>\n"); exit(); } for($row = 0; $row < pg_NumRows($result); $row++) { print("<tr>\n"); for($field = 0; $field < pg_numfields($result); $field++) { print("<td>"); print(pg_result($result, $row, $field)); print("</td>\n"); } // Add link to edit the row if editable. if ($readonly == 0) { print("<td><a href=rta_edit.php?table=$tbl"); print("&row=$row&port=$port>(edit)</a></td>"); } print("</tr>\n"); } print("</table></center>\n"); // Add link to next set of rows if needed if ($offset + 20 < $nrows) { $offset = $offset + 20; $nextcount = $nrows - $offset; if ($nrows - $offset > 20) $nextcount = 20; print("<p align=right><a href=rta_view.php?table=$tbl&offset=$offset"); print("&nrows=$nrows&port=$port>Next $nextcount rows ></a></p>\n"); } // free the result and close the connection pg_freeresult($result); pg_close($connection);?></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -