Solved

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

Posted on 2006-10-23
3
226 Views
Last Modified: 2013-12-25
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
0
Comment
Question by:jcprasad
3 Comments
 
LVL 8

Accepted Solution

by:
Perl_Diver earned 500 total points
ID: 17793160
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

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction:   Welcome to my first article ever. To begin with, the reason I write this article.  I participated in a question on Experts Exchange about the start command in Windows and there were some discussion about the usage. The discussio…
It is a general practice to get rid of old user profiles on a computer  in a LAN environment. As I have been working with a company in a LAN environment where users move from one place to some other place at times. This will make many user profil…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question