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

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

<sql_prepare>
<?

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

<:
    for $i (('subject','body')) {
      printf "    \$%s=sql_prepare (\$%s);\n", $i, $i;
    }
:>

  if ($oid > 0) {
    $query = "UPDATE ticker SET "
      . "subject='$subject',"
      . "url='$url',"
      . "body='$body',"
      . "releasedate='$releasedate',"
      . "deleted='$deleted'"
      . " WHERE oid = $oid";
  } else {
    $query = "INSERT INTO ticker "
      . "(subject,url,body,releasedate,deleted) VALUES ("
      . "'$subject',"
      . "'$url',"
      . "'$body',"
      . "'$releasedate',0"
      . ")";

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

?>

Aufgenommen/aktualisiert.<p>

</page>

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