Solved

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

Posted on 2006-10-23
3
224 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

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…
I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo…
The viewer will learn how to dynamically set the form action using jQuery.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

778 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