1 #include <infodrom.style>
4 <page title="Infodrom News">
7 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
8 or die("Unable to connect to SQL server");
10 pg_exec ($dbh, "SET DateStyle = 'ISO'"); // ignore or die("Datenbank-Abfrage!");
13 $query = "SELECT * FROM news WHERE id = '$id'";
14 $sth = pg_exec ($dbh, $query);
16 if (pg_NumRows ($sth) > 0) {
17 $row = pg_fetch_array ($sth, 0);
18 if ($row['deleted'] == 0) {
19 $date = explode (" ", $row['releasedate']);
20 $date = explode ("-", $date[0]);
21 $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
23 printf ("<h3>%s</h3>", $row['subject']);
24 printf ("<h5>Von <a href=\"mailto:%s\">%s</a>, %s</h5>", $row['email'], $row['author'], $date);
25 printf ("<b>%s</b><p>", $row['teaser']);
26 echo ereg_replace ("<newline>", "
27 ", ereg_replace ("<newline><newline>","<p>", ereg_replace ("
28 ", "<newline>", $row['body'])));
31 echo "<p><a href=\"shownews.php3\">Ältere Nachrichten</a><p>";
33 $query = "SELECT id,subject,author,releasedate,teaser,body FROM news "
34 . "WHERE deleted = 0 AND releasedate < now() AND teaser <> '' "
35 . "ORDER BY releasedate DESC,insertd DESC";
36 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
38 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
39 $row = pg_fetch_array ($sth, $nr);
40 $date = explode (" ", $row['releasedate']);
41 $date = explode ("-", $date[0]);
42 $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
43 printf ("<b>%s</b><br>%s", $row['subject'], $row['teaser']);
44 if (strlen ($row['body']) > 0) {
45 printf (" <a href=\"shownews.php3?id=%d\"><phpmehr></a>", $row['id']);
47 printf ("<br>(<font size=\"-1\">%s, %s</font>)<p>", $row['author'], $date);