#include <infodrom.style>
#include <phptools.inc>

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

<sql_prepare>
<?

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

<:
    for $i (('subject','package','description','donemsg')) {
      printf "  \$o_%s = \$_POST[%s];\n", $i, $i;
      printf "  \$%s=sql_prepare (\$_POST[%s]);\n", $i, $i;
    }
:>

  if ($_POST[id] > 0) {
    if ($_POST[delete] > 0) {
      $query = "DELETE FROM todo WHERE oid = $_POST[id]";
    } else {
      if ($_POST[done] > 0) {
	$query = "UPDATE todo SET "
	  . "subject='$subject',"
	  . "package='$package',"
	  . "done='now',"
	  . "description='$description',"
	  . "donemsg='$donemsg'"
	  . " WHERE oid = $_POST[id]";
      } else {
	$query = "UPDATE todo SET "
	  . "subject='$subject',"
	  . "package='$package',"
	  . "description='$description'"
	  . " WHERE oid = $_POST[id]";
      }
    }
  } else {
    #$date = date ("Y-m-j H:i");

    $query = "INSERT INTO todo "
      . "(subject,package,description,submitted,done) VALUES ("
      . "'$subject',"
      . "'$package',"
      . "'$description',"
      . "'now',"
      . "NULL"
      . ")";

  }
  //printf ("<pre>\n%s\n</pre>\n", $query);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

?>

<p>Entry added.</p>

<h3><? echo $o_subject; ?></h3>

<h5><? echo $o_package; ?></h5>

<p><b><? echo $o_description; ?></b></p>

<?
  if ($o_donemsg) {
    printf ("<p><b>Done with: </b> %s</p>\n", $o_donemsg);
  }
?>

</page>

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