📄 rta_edit.php
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN"><html><head><title>Edit Row</title></head><body><?php // The user has selected a row in a table to edit. // We want to display the name, help, and value of // each field in the row. If the row is editable, // we want to add it to a form which lets them // change the value. $tbl = htmlentities($_GET['table']); $row = htmlentities($_GET['row']); $port = htmlentities($_GET['port']); // Say where we are. print("<center><h3>Edit $tbl, row $row</h3></center>\n"); // Suppress Postgres error messages error_reporting(error_reporting() & 0xFFFD); // connect to the database $c1 = pg_connect("localhost", "$port", "bsmith"); if ($c1 == "") { printf("$s%s%s", "Unable to connect to application.<br>", "Please verify that the application is running and ", "listening on port $port.<br>"); exit(); } // Give URL for form processing print("<form method=\"post\" action=rta_update.php>\n"); print("<td><input type=\"hidden\" name=\"__table\" value=\"$tbl\">\n"); print("<td><input type=\"hidden\" name=\"__row\" value=\"$row\">\n"); print("<td><input type=\"hidden\" name=\"__port\" value=\"$port\">\n"); // print name, help, value of each column print("<center><table border=3 cellpadding=4 width=85%>\n"); // execute query $command = "SELECT name, flags, help, length, type FROM rta_columns WHERE table='$tbl'"; $r1 = pg_exec($c1, $command); if ($r1 == "") { print("<p><font color=\"red\" size=+1>SQL Command failed!</p>"); print("<p>Command: $command</p>\n"); exit(); } print("<tr><th>Column</th><th width=20%>Value</th></tr>\n"); print("</tr>\n"); for($col = 0; $col < pg_NumRows($r1); $col++) { $colname = pg_result($r1, $col, 0); $colflags = pg_result($r1, $col, 1); $colhelp = pg_result($r1, $col, 2); $collength = pg_result($r1, $col, 3); $coltype = pg_result($r1, $col, 4); if (($coltype != 0) && // "0" is the type for strings, See rta.h ($coltype != 4)) // "4" is the type for pointer to string. $collength = 20; // Get column value from table $command = "SELECT \"$colname\" FROM \"$tbl\" LIMIT 1 OFFSET $row"; $r2 = pg_exec($c1, $command); if ($r2 == "") { print("<p><font color=\"red\" size=+1>SQL Command failed!</p>"); print("<p>Command: $command</p>\n"); exit(); } $colvalue = pg_result($r2, 0, 0); pg_freeresult($r2); // Display the column print("<tr><td><b>$colname</b><br>$colhelp</td>"); if ($colflags & 2) // "2" indicates a read-only field. See rta.h { print("<td>$colvalue</td></tr>\n"); } else { print("<td><input type=\"text\" name=\"$colname\" "); print("value=\"$colvalue\" maxlenght=$collength>"); print("</td></tr>\n"); } } print("</table></center>\n"); print("<p align=right><input type=\"submit\"></p>\n"); // free the result and close the connection pg_freeresult($r1); pg_close($c1);?></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -