#include <infodrom.style>

<page func="Infodrom Oldenburg" title="Linx">

<h3>Lookup of <?
  if (isset($_POST[keywords]) && strlen($_POST[keywords])) { echo ("»".$_POST[keywords]."«"); }
?></h3>

<?
  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
               or die("Unable to connect to SQL server");

  $query = "SELECT oid,subject,category FROM links ";

  if (isset($_POST[keywords]) && strlen($_POST[keywords])) {
    $query .= "WHERE ";
    $keys = explode (" ", $_POST[keywords]);

    # Process all AND-keywords
    #
    for ($i=0; $i < count ($keys); $i++) {
      if ($i > 0) {
        $query .= "AND ";
      }
      $query .= sprintf ("( category ~* '%s' OR keywords ~* '%s' OR subject ~* '%s' OR url ~* '%s' ) ",
			$keys[$i], $keys[$i], $keys[$i], $keys[$i]);
    }
  }

  $query .= "ORDER BY category,subject";
  # printf ("<pre>\n%s\n</pre>", $query);
  $sth = pg_exec ($dbh, $query);

  $category = "";
  if (pg_NumRows ($sth) > 0) {
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row = pg_fetch_array ($sth, $nr);

      if ($category != $row['category']) {
	if ($nr > 0) {
	  echo ("</ul>");
	}
	# printf ("<b><a href=\"lookup.php?category=%s\">%s</a></b><br><ul>", $row['category'], $row['category']);
	printf ("<b>%s</b><br><ul>", $row['category']);
        $category = $row['category'];
      }      
      printf ("<li><a href=\"edit.php?oid=%d\">%s</a></li>", $row['oid'], $row['subject']);
    }
    echo ("</ul>");
  }
?>

</page>

# Local variables:
# mode: text
# mode: auto-fill
# mode: iso-accents
# end: