1 #include <infodrom.style>
3 <page func="Infodrom Oldenburg" title="Todo">
6 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
7 or die("Unable to connect to SQL server");
9 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
11 $query = "SELECT oid,package,subject,submitted FROM todo WHERE done IS NULL ORDER BY package,submitted";
12 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
14 if (pg_NumRows ($sth) > 0) {
15 echo ("<table width=\"100%\" border=\"0\" cellspacing=\"3\" bgcolor=\"#f7ba2e\" summary=\"\">");
16 echo ("<tr><th width=\"10%\"><font face=\"Helvetica,Arial\">Paket</font></th>");
17 echo ("<th width=\"10%\"><font face=\"Helvetica,Arial\">Datum</font></th>");
18 echo ("<th width=\"80%\"><font face=\"Helvetica,Arial\">Subject</font></th></tr>");
21 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
22 $row = pg_fetch_array ($sth, $nr);
23 $date = explode (" ", $row['submitted']);
24 $date = explode ("-", $date[0]);
25 $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
27 printf ("<tr><td align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $row['package']);
28 printf ("<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $date);
29 printf ("<td align=\"left\" width=\"80%%\"><font face=\"Helvetica,Arial\"><a href=\"edit.php3?id=%d\">%s</a></font></th></tr>",
30 $row['oid'], $row['subject']);
32 if (pg_NumRows ($sth) > 0) {