Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://766009]
help
Chatterbox?
[Corion]: :-D
Corion discovers a new shiny toy to try out over the (longish) weekend. Since I've done some more with websockets, maybe I'll try writing a webserver that implements hot-reloading of HTML(+CSS, +Javascript) in the browser. Edit the local file and ...
[Corion]: ... the browser(s) get a ping to a) refresh the page or b) reload "just" the changed parts, keeping the scroll position etc.
[Corion]: But I also have to look at how I can make WWW::Mechanize:: RemoteBrowser a reality, and how to make it safe from malicious content ;)

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (8)
As of 2018-04-26 10:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?