Viewing file:  namechange.phtml (2.1 KB) -rwxrwxr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text-html; charset=UTF-8" />
<title>AXess - Name change</title>
<link rel="stylesheet" href="axess.css?v1" type="text/css" />
<script type="text/javascript" src="js/jquery-1.2.6.pack.js?v1"></script>
<script type="text/javascript" src="js/jquery.validate.pack?v1"></script>
<script type="text/javascript" src="js/axess.js?v1"></script>
</head>
<body id="axessMain">
<?php
$location = 'posts';
require('axess_header.inc');
?>
<div id="axessMessage">
<div class="innerPadding">
<div id="logout"><a href="logout">Logout</a></div>
<p>
Name Change Log<br />
</p>
</div>
</div>
<?php //ob_start("ob_gzhandler"); ?>
<?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();
}
?>
<body>
|