Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re: Problem with mysql query using DBI::Mysql

by arc_of_descent (Hermit)
on May 25, 2009 at 10:48 UTC ( #766009=note: print w/replies, xml ) Need Help??

in reply to Problem with mysql query using DBI::Mysql

My suggestion would be to first NOT use MySQL at all, and check if your code can properly get the form data and print it out. This way you know what data the user is entering without the need to debug any mysql related problems.

I also suggest you use the CGI methods to get the form data. You should be selective about what form data you need from the user. For example, to get the the value of a text input field named first_name, in your CGI script, you should do this:

my $first_name = param('first_name');

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://766009]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2017-11-20 08:15 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (286 votes). Check out past polls.