Search:

Thanks guys. Cheers.

If I didn't use the ?s would I simply omit them?

ie.


$dbh->do ( qq ( INSERT INTO contact ( fname, lname, address, city, state, zip, phone, email ) values( , , , , , , , ) ), $fname, $lname,...

Thanks for pointing that out. I did some quick reading about interpolating perl variables into SQL statements @ http://search.cpan.org/~markstos/SQL-Interpolate-0.40/lib/SQL/Interpolate.pm and put...

Thank you for your response.

I've made some modifications. Successful input is supposed to be sent to the mysql database using the process_form subroutine. Do you see an issue there?

FILE:...

Sorry about that. New to the forum and didn't know the etiquette.

db_register.sql



CREATE DATABASE db_register;

USE db_register;

Does the sub process_form need to exist before it's being called upon?

I think I already caught one minor error. In the sub "validate_form" I'm using a variable named $query but below when I create a new CGI object I named it $q. These need to match.

I was given a project to create a simple HTML registration form in which the data is validated using Javascript. It is then validated on the server side using Perl before being sent to a mySQL...