Viewing file:  namechange.phtml (1.23 KB) -rwxrwxr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php ob_start("ob_gzhandler"); ?>
<h1>Name change log search</h1>
<?php
pg_connect("dbname=ax");
function do_search_query($namefragment) {
return pg_exec("select * from namechange where oldname~*'".addslashes($namefragment)."' or newname~*'".addslashes($namefragment)."' order by date desc;");
}
function display_dialog() {
?>
<form method=get>
Name fragment to search for (search is case insensitive): <input type=text name=namefragment size=40 value="<?= htmlspecialchars($_REQUEST['namefragment']); ?>"> <input type=submit name=submit value="Search">
</form>
<?php
}
function tablelist($result) {
if (pg_num_rows($result)==0) {
echo "<p><b>No such records found.</b></p>";
return;
}
echo "<table border>";
echo "<tr>";
for ($column=0;$column<pg_num_fields($result);$column++) {
echo "<th>".htmlspecialchars(pg_field_name($result,$column))."</th>";
}
echo "</tr>";
for ($row=0;$row<pg_num_rows($result);$row++) {
$obj=pg_fetch_array($result,$row,PGSQL_NUM);
echo "<tr>";
foreach($obj as $value) {
echo "<td>".htmlspecialchars($value)."</td>";
}
echo "</tr>";
}
echo "</table>";
}
display_dialog();
if (isset($_REQUEST['namefragment'])) {
tablelist(do_search_query($_REQUEST['namefragment']));
display_dialog();
}
?>
|