nlafferty has asked for the wisdom of the Perl Monks concerning the following question:
I have a question that will help me and perhaps others. When you write a CGI script. You include -w and use strict;. The code works fine, but how do I find bugs that might not appear until down the road. Or an exploit of some sort that a malicious person could take advantage of.
Of course, use taint; would help. But I'm talking perfect code (as far as we know). What are some common mistakes in CGI scripts that could "break".
More specifically, in my case a program of multiple scripts that use an SQL database for storing form data. Thanks.