#include <infocon.style>

<page func="Information & Consulting" title="Logbook">

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

    pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

  if ($_GET['id'] > 0) {
    $query = sprintf ("SELECT oid,* FROM logbook WHERE id = '%s'", $_GET['id']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage! ".$query);

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);

      $date = explode (" ", $row['created']);
      $time = explode (":", $date[1]);
      $date = explode ("-", $date[0]);
      $date = sprintf ("%d.%d.%d %02d:%02d", $date[2], $date[1], $date[0], $time[0], $time[1]);
    }
  } else {
    $row['category'] = 'misc';
  }
?>

<form method=post action="update.php">
<input type=hidden name=oid value="<? echo $row['oid']; ?>">
<b>Category:</b> <select name=category><?
  $sth = pg_exec ($dbh, "SELECT DISTINCT category FROM logbook ORDER BY category") or die("Datenbank-Abfrage!");
  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
    $srow = pg_fetch_array ($sth, $nr);
    printf ("<option value=\"%s\"%s>%s\n", $srow['category'],
        $row['category'] == $srow['category']?" selected":¨, $srow['category']);
  }
?></select><br>
<b>Teaser:</b> <input name=teaser size=60 maxlength=120 value="<? echo $row['teaser']; ?>"><br>
<b>Text:</b> <br><textarea name=body rows=16 cols=79><? echo str_replace ("&", "&amp;", $row['body']); ?></textarea><p>
<b>Public:</b> <input name=public type=checkbox value="1" <? if ($row['public']==1) { echo "checked";} ?>><br>

<? if ($_GET['id'] > 0) { ?>
<b>Created:</b> <? echo $date; ?><br>
<? } ?>

<p><center><input type=submit class=button value="<? echo $_GET['id']>0?"Update":"Insert"; ?>">\
&nbsp;&nbsp;&nbsp;&nbsp;
<input type=reset class=button value="Reset"></center><p>
</form>

</page>

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