Changeset 261 for trunk/npemap.org.uk
- Timestamp:
- Nov 1, 2006, 10:45:09 AM (14 years ago)
- Location:
- trunk/npemap.org.uk
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/cgi/submit.fcgi
r251 r261 134 134 } 135 135 136 $sth = $dbh->prepare('INSERT INTO postcodes (outward, inward, raw_postcode_outward, raw_postcode_inward, easting, northing, ip, source ) VALUES (?, ?, ?, ?, ?, ?, ?, 0)');137 if ($sth->execute($outward, $inward, $cgi->param('postcode1'), $cgi->param('postcode2'), $easting, $northing, $ENV{'REMOTE_ADDR'} )) {136 $sth = $dbh->prepare('INSERT INTO postcodes (outward, inward, raw_postcode_outward, raw_postcode_inward, easting, northing, ip, source, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?, 0, ?)'); 137 if ($sth->execute($outward, $inward, $cgi->param('postcode1'), $cgi->param('postcode2'), $easting, $northing, $ENV{'REMOTE_ADDR'}, $ENV{'HTTP_USER_AGENT'})) { 138 138 print "Content-type: text/html\n\n"; 139 139 print "<html><head><title>Thank you</title></head>\n"; -
trunk/npemap.org.uk/schema_postgres.sql
r260 r261 31 31 source integer NOT NULL, 32 32 deleted boolean NOT NULL default 'f', 33 delete_reason integer 33 delete_reason integer, 34 user_agent character varying 34 35 35 36 CONSTRAINT pk_postcode PRIMARY KEY (id),
Note: See TracChangeset
for help on using the changeset viewer.