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 } elseif (isset($_GET["delete"]) && is_numeric($_GET["delete"])) {
35 $query = sprintf ("UPDATE zeitungen SET deleted = true WHERE oid = %d", $_GET["delete"]);
37 $query = "INSERT INTO zeitungen "
38 . "(name,url,description,city,type,changed) VALUES ("
39 . sprintf ("'%s','%s','%s','%s','%s','now()'",
42 addslashes ($description),
44 addslashes ($_POST[type]))
48 //printf ("<pre>\n%s\n</pre>\n", $query);
49 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
53 Aufgenommen/aktualisiert.<p>