1 #include <infocon.style>
2 #include <phptools.inc>
4 <page func="Information & Consulting" title="Logbook">
9 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
10 or die("Unable to connect to SQL server");
13 for $i (('teaser','body')) {
14 printf " \$o_%s = \$_POST[%s];\n", $i, $i;
15 printf " \$%s = pg_escape_string(\$_POST[%s]);\n", $i, $i;
18 if ($_POST["public"] != 1) {
22 if ($_POST[oid] > 0) {
23 $query = sprintf ("UPDATE logbook SET category='%s',teaser='%s',public=%d,body='%s' "
31 $date = date ("Y-m-d H:i");
34 $query = sprintf ("INSERT INTO logbook (id,category,teaser,body,public,created) VALUES "
35 ."('%s','%s','%s','%s',%d,'%s')",
43 // printf ("<pre>\n%s\n</pre>\n", $query);
44 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
47 <h3><? echo $o_teaser; ?></h3>
50 if (! isset($_POST[oid]) || $_POST[oid] == 0) {
51 $oid = pg_getlastoid ($sth);
56 $query = sprintf ("SELECT id,teaser,public FROM logbook WHERE oid = %d", $oid);
57 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
58 if (pg_NumRows ($sth) > 0) {
59 $row = pg_fetch_array ($sth, 0);
61 printf ('<p><a href="edit.php?id=%d">edit</a>', $row['id']);
62 if ($row['public'] > 0) {
63 printf(' — <a href="http://infocon.infodrom.org/logbook/%s-%d.html">public link</a>',
64 teaserlink($row['teaser']), $row['id']);
70 <? echo str_replace ("\\\n", "", str_replace ("\r", "", $o_body)); ?>