I don't use MySql but if you are using CGI you can just do the following:
use CGI;
my $q = new CGI;
my $value1 = $q->param( "first-passed-value" );
my $value2 = $q->param( "second-passed-value" );
my $value3 = $q->param( "third-passed-value" );
Etc.
This can be set in a loop if you don't know how many values
will be passed.
Also if you know how the information will be passed to the script you don't
need to determent the input type: GET or POST.
> ----------
> From: Vontel Girish[SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 7:35 AM
> To: [EMAIL PROTECTED]
> Subject: queryString and CGI.
>
> I have just started to create a sample online store
> with Unix OS, Apache web server, CGI with perl and
> MySQL database.
>
> The perl program given below splits the querystring
> into Name value pairs.
>
> -----------------------------------------------
> #!/usr/local/bin/perl
> if($ENV{'REQUEST_METHOD'}eq 'GET'){
> $form_into = $ENV{'QUERY_STRING'};
> }
> else{
> $input_size = $ENV{'CONTENT_LENGTH'};
> read(STDIN,$form_info,$input_size);
> }
> @input_pairs = split(/[&;]/,$form_info);
> %input=();
> foreach $pair(@input_pairs){
> $pair=~ s/\+/ /g;
> ($name, $value)=split(/=/,$pair);
> $name =~ s/%([A-Fa-f0-9]{2})/pack("c",hex($1))/ge;
> $value=~ s/%([A-Fa-f0-9]{2})/pack("c",hex($1))/ge;
> $input{$name}=$value;
> }
> ---------------------------------------
>
>
> CAN ANYONE TELL ME WHEN I AM WRITING A CGI PROGRAM
> FOR CONNECTING TO MYSQL DATABASE AND DUMPING THE DATA
> INTO THE TABLE, WILL I HAVE TO INCLUDE THE ABOVE PIECE
> OF CODE FOR SPLITTING THE QUERYSTRING INTO NAME VALUE
> PAIRS?????
>
> THANKS.
> VONTEL GIRISH
> THANKS
>
>
> ____________________________________________________________
> Do You Yahoo!?
> For regular News updates go to http://in.news.yahoo.com
>
