#include <lt2001.style>
#include "phptools.inc"

<page title="Search" subtitle=Search>

<?
  if(!$key) die("no search string");

  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	       or die("Unable to connect to SQL server");
  pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
  
  $query = sprintf ("SELECT comments.oid,project.oid,date,who,email,body,project FROM comments,project "
       . "WHERE comments.project = project.name AND body ~* '%s' ORDER BY date", $key);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
  
  
  if (pg_NumRows ($sth) > 0) {
    echo("<h3>Comments</h3>");
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
	$row = pg_fetch_array ($sth, $nr);

	$date = explode (" ", $row['date']);
	$date = explode ("-", $date[0]);
	$date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);

	printf ("<hr><h3><a href=\"edit_comment.php3?oid=%d\">%s, %s &lt;%s&gt;</a></h3>"
	       ."<strong>Project</strong>: <a href=\"show.php3?oid=%d\">%s</a> <br> %s<p>",
	  $row[0], $date, $row['who'], $row['email'], $row[1], $row['project'], $row['body']);
    }
  }
  
  $query = sprintf ("SELECT project.oid,person.oid,person.name,email,project,person.comment FROM person,project WHERE person.project = project.name AND (person.name ~* '%s' OR person.comment ~* '%s') ORDER BY person.name",$key,$key );
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
  
  if (pg_NumRows ($sth) > 0) {
    echo ("<h3>People</h3>");
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
        $row = pg_fetch_array ($sth, $nr);
	
	if ($row['comment'] != "") {
	  printf ("Name: <a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt; <br>"."Project: <a href=\"show.php3?oid=%d\">%s</a> <br> Comment: %s <br> <p>",
	  $row[1], $row['name'], $row['email'], $row[0], $row['project'], $row['comment']); 
	} else {
	  printf ("Name: <a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt; <br>"."Project: <a href=\"show.php3?oid=%d\">%s</a> <br> <p>",
	  $row[1], $row['name'], $row['email'], $row[0], $row['project']);
	}
    }
  } 
?>

</page>

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