<p>Public Logbook</p>
<?
- $parms = array ("keyword","category","public","teaser");
+ $parms = array ("keyword","category","public","teaser","subject");
$urlbase = "";
foreach ($parms as $arg) {
if (isset($_REQUEST[$arg])) {
if (strlen($urlbase) == 0)
- $urlbase = "find.php";
+ $urlbase = "find.php?";
else
$urlbase .= "&";
- $urlbase .= $_REQUEST[$arg];
+ $urlbase .= $arg . '=' . urlencode($_REQUEST[$arg]);
}
}
$query = "SELECT id,category,teaser,created,public FROM logbook WHERE ";
$where = array();
if (strlen($_REQUEST[keyword])) {
- if (isset($_POST['subject'])) {
+ if (isset($_REQUEST['subject'])) {
$where[] = sprintf ("teaser ~* '%s'",
addslashes ($_REQUEST[keyword]));
} else {
echo ("</table>\n");
- if ($nr >= pg_NumRows ($sth)) {
+ if ($nr >= $limit) {
if (isset($_REQUEST["sort"]))
- $url = sprintf ("%s&sort=%s&offset=%d", $urlbase, $_REQUEST["sort"], $_GET["offset"]+$limit);
+ $url = sprintf ("%s&sort=%s&offset=%d", $urlbase, urlencode($_REQUEST["sort"]), $_GET["offset"]+$limit);
+ else
+ $url = sprintf ("%s&offset=%d", $urlbase, $_GET["offset"]+$limit);
printf ("<p><a href=\"%s\">next</a></p>\n", $url);
}