source: branches/htmlform/cgi-bin/newcity.cgi@ 449

Last change on this file since 449 was 447, checked in by Kris Deugau, 14 years ago

/branches/htmlform

Switch all scripts to use CGI::Simple for HTML form data munging
instead of legacy CommonWeb.pm sub. Remove parse_post() sub from
CommonWeb.pm. See #15.

  • Property svn:executable set to *
  • Property svn:keywords set to Date Rev Author
File size: 1.8 KB
Line 
1#!/usr/bin/perl
2# ipdb/cgi-bin/newcity.cgi
3# Add new city to database
4###
5# SVN revision info
6# $Date: 2010-07-27 17:15:56 +0000 (Tue, 27 Jul 2010) $
7# SVN revision $Rev: 447 $
8# Last update by $Author: kdeugau $
9###
10# Copyright (C) 2004-2010 - Kris Deugau
11
12use strict;
13use warnings;
14#use CGI::Carp qw(fatalsToBrowser);
15use CGI::Simple;
16use DBI;
17use CommonWeb qw(:ALL);
18#use POSIX qw(ceil);
19use NetAddr::IP;
20
21use Sys::Syslog;
22
23# don't remove! required for GNU/FHS-ish install from tarball
24##uselib##
25
26use MyIPDB;
27
28openlog "IPDB","pid","$IPDB::syslog_facility";
29
30# Collect the username from HTTP auth. If undefined, we're in a test environment.
31my $authuser;
32if (!defined($ENV{'REMOTE_USER'})) {
33 $authuser = '__temptest';
34} else {
35 $authuser = $ENV{'REMOTE_USER'};
36}
37
38# Set up the CGI object...
39my $q = new CGI::Simple;
40# ... and get query-string params as well as POST params if necessary
41$q->parse_query_string;
42
43# Convenience; saves changing all references to %webvar
44##fixme: tweak for handling <select multiple='y' size=3> (list with multiple selection)
45my %webvar = $q->Vars;
46
47my ($dbh,$errstr) = connectDB_My;
48my $sth;
49
50print "Content-type: text/html\n\n";
51
52if ($webvar{pop} eq 'on') {
53 $sth = $dbh->prepare("insert into cities (city,routing) values ('$webvar{city}','y')");
54} else {
55 $sth = $dbh->prepare("insert into cities (city,routing) values ('$webvar{city}','n')");
56}
57$sth->execute;
58
59if ($sth->err) {
60 print "Error adding city to database: ".$sth->errstr;
61 mailNotify($dbh, 'f:nci', "IPDB city add failure",
62 "$authuser could not add city '$webvar{city}' to database: ".$sth->errstr);
63 syslog "err", "$authuser could not add city '$webvar{city}' to database: ".$sth->errstr;
64} else {
65 print "City added. Closing this window should refresh the page.";
66 syslog "notice", "$authuser added city/location '$webvar{pop}'".
67 (($webvar{pop} eq 'on') ? ' as POP location' : '');
68}
69
70finish($dbh);
Note: See TracBrowser for help on using the repository browser.