MySQL front end using Perl/CGI/DBI: How to implement multiple scripts after authentication page?

Hi all,

I am not a complete newbie but relatively new to CGI and databases, I just know Perl well. I am implementing the front and back ends of a MySQL database using Perl/CGI. What I would like to ask is how to create the following setup.

A front/first page which asks username, password and whether I want to search, add or modify the database. Depending on the userid and the choice made, the second page (which I guess will be a second cgi script) loads. The second page will be the mysql front end (search/modify/add). The second page could call a third script depending on certain choices. I don't yet know how to pass parameters well. I know somewhat how to pass parameters that appear in the URL (like search.cgi?param1=xyz&param2=abc).

I have searched and seen recommendations to use Session cookies and MD5 but I haven't still figured how to and am in a time crunch. If somebody can provide me with sample scripts that I can use and learn from, that would be great. A sample cgi script that uses the parameters passed to it (visible and hidden) will also be of help. Pointers to specific resources welcome. I am assigning 500 points.

Thanks a lot,
JCP
jcprasadAsked:
Who is Participating?
 
Perl_DiverConnect With a Mentor Commented:
If the main question is how to parse the data passed to your perl script, the CGI module is sort of the defacto module to use for that purpose:

http://perldoc.perl.org/CGI.html

search on CPAN for CGI and you will see there are many modules for working with CGI data:

http://search.cpan.org/search?query=CGI&mode=all

you will find this of interest too most likely:

http://search.cpan.org/~sherzodr/CGI-Session-3.95/Session/CookBook.pm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.