#!/usr/bin/perl -Tw
-# $Id: persons.cgi,v 1.6 1999-04-22 05:54:53 ivan Exp $
+# $Id: persons.cgi,v 1.7 1999-04-22 05:58:06 ivan Exp $
# Copyright (c) 1999 Ivan Kohler. All rights reserved.
# This program is free software; you can redistribute it and/or modify it under
# the same terms as perl itself
unless ( $cgi->param('magic') ) { #first time through
- my $sth = $dbh->prepare( "SELECT * FROM PERSONS" )
+ my $sth = $dbh->prepare( "SELECT * FROM $table" )
or die $dbh->errstr;
my $rv = $sth->execute;
die $sth->errstr unless $rv;
$cgi->param( $field, $1);
}
}
- my $statement = 'INSERT INTO PERSONS ( '.
+ my $statement = "INSERT INTO $table ( ".
join(', ', @fields ).
' ) VALUES ( '.
join( ', ', map { $dbh->quote($cgi->param($_)) } @fields ).
#!/usr/bin/perl -Tw
-# $Id: sets.cgi,v 1.2 1999-04-22 05:54:53 ivan Exp $
+# $Id: sets.cgi,v 1.3 1999-04-22 05:58:06 ivan Exp $
# Copyright (c) 1999 Ivan Kohler. All rights reserved.
# This program is free software; you can redistribute it and/or modify it under
# the same terms as perl itself
die $sth->errstr unless $rv;
print $cgi->header( '-expires' => 'now' ),
- $cgi->start_html('Person listing'),
- $cgi->h1('Person listing'),
+ $cgi->start_html('Set listing'),
+ $cgi->h1('Set listing'),
;
unless ( $sth eq '0E0' ) {
}
$cgi->param('magic', 'new_form');
- print '<P><A HREF="', $cgi->self_url, '">Add new person</A>';
+ print '<P><A HREF="', $cgi->self_url, '">Add new set</A>';
print $cgi->end_html;
exit;
} elsif ( $cgi->param('magic') eq 'new_form' ) {
- $cgi->param('PERSON_ID', 0);
+ $cgi->param('SET_ID', 0);
$cgi->param('magic', 'process_form');
- &print_form( $cgi, "Add person" );
+ &print_form( $cgi, "Add set" );
exit;
} elsif ( $cgi->param('magic') eq 'process_form' ) {
$cgi->param( $field, $1);
}
}
- my $statement = 'INSERT INTO PERSONS ( '.
+ my $statement = "INSERT INTO $table ( ".
join(', ', @fields ).
' ) VALUES ( '.
join( ', ', map { $dbh->quote($cgi->param($_)) } @fields ).