1 #include <infodrom.style>
2 #include <phptools.inc>
3 #include "zeitungen.inc"
5 <page func="Infodrom Oldenburg" title="Zeitungen">
9 $date = date ("Y-m-j H:i");
10 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
11 or die("Unable to connect to SQL server");
14 for $i (('name','description','url','city')) {
15 printf " \$%s=sql_prepare (\$_POST[%s]);\n", $i, $i;
19 if ($_POST[oid] > 0) {
20 if ($_POST[delete] == 1) {
21 $query = sprintf ("UPDATE zeitungen SET deleted = true WHERE oid = %d", $_POST[oid]);
23 $query = "UPDATE zeitungen SET "
24 . sprintf ("name='%s',url='%s',description='%s',city='%s',type='%s'",
27 addslashes ($description),
29 addslashes ($_POST[type]))
30 . " WHERE oid = $_POST[oid]";
32 } elseif (isset($_GET["approve"]) && is_numeric($_GET["approve"])) {
33 $query = sprintf ("UPDATE zeitungen SET deleted = false WHERE oid = %d", $_GET["approve"]);
34 printf ('<p><a href="edit.php?oid=%d">Edit</a></p>', $_GET["approve"]);
35 } elseif (isset($_GET["delete"]) && is_numeric($_GET["delete"])) {
36 $query = sprintf ("UPDATE zeitungen SET deleted = true WHERE oid = %d", $_GET["delete"]);
38 $query = "INSERT INTO zeitungen "
39 . "(name,url,description,city,type,changed) VALUES ("
40 . sprintf ("'%s','%s','%s','%s','%s','now()'",
43 addslashes ($description),
45 addslashes ($_POST[type]))
49 //printf ("<pre>\n%s\n</pre>\n", $query);
50 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
54 <p>Aufgenommen/aktualisiert.</p>