$date = convert_date($_POST[date]);
+ $orig_name = $_POST[name];
<:
- $orig_name = $_POST[name];
for $i (('name','city','country','url','deburl','localurl','comment')) {
printf " \$%s=sql_prepare (\$_POST[%s]);\n", $i, $i;
}
:>
+ $oid = 0;
if ($_POST['id'] > 0) {
if (isset($_POST['delete'])) {
$query = sprintf ("DELETE FROM events WHERE oid = %d", $_POST[id]);
} else {
+ $oid = $_POST['id'];
$query = sprintf ("UPDATE events SET name='%s',start='%s',delta='%s',city='%s',country='%s',"
."conference=%d,exhibition=%d,url='%s',deburl='%s',localurl='%s',comment='%s',cancelled=%d WHERE oid = %d",
$name,
$date, $days, $city, $country, $_POST[conference], $_POST[exhibition], $url, $deburl, $localurl,
$comment,
- $_POST[cancelled],$_POST[id]);
+ $_POST['cancelled'], $_POST['id']);
}
} else {
$query = sprintf ("INSERT INTO events "
//printf ("<pre>\n%s\n</pre>\n", $query);
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
-?>
+ if ($oid == 0 && empty($_POST['id'])) {
+ $oid = pg_last_oid($sth);
+ if ($oid === false)
+ die("INSERT failed");
+ }
-<h3><? echo $orig_name; ?></h3>
+ if ($oid > 0) {
+ printf('<h3><a href="show.php?id=%d">%s</a></h3>', $oid, $orig_name);
+ } else
+ printf("<h3>%s</h3>", $orig_name);
+
+?>
<?
if ($_POST['id'] > 0) {
echo "<p>inserted.</p>";
?>
-<p>updated/inserted.
-
</page>
# Local variables: