Solved

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

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
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 …

746 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now