Double Posting-->One Form

[d-woo]

I have an html form that takes in variables (user entered) and
sends them to a Perl script.

<Form Method="Post" Action="myperlscript.pl">
name
address
phone
e-mail
<form submitted>

I have now begun using MySQL and PHP and love the combination.
What I would like to do is to store this information in a MySQL database
using PHP.

Solution #1

One solution would be to just have the Perl send the info to the MySQL.
I can simply add the code in the Perl to do this.

Although I do not know Perl, I could still store the information in the MySQL database
without a problem (MySQL is MySQL).

Seeking a Broader Solution

Because I have more than one html form (similar to the above) and more than one
Perl script a simpler alternative (from my perspective as a newbie) to editing each Perl script would be to
post the information to the Perl and to a PHP script at the same time if possible.

Solution #2 - Double Posting from one HTML form

I do not know if a double-post is possible. Is it?
e.g. <Form Method="Post" action="myPerlScript" and "myPHPscript">

Solution #3 - Passing the variables from HTM to PHP then to Perl

In essence this would be an intermediate step between HTML--->Perl
a. HTML--->PHP

b. PHP--->Perl

The "a" part I can do. It's the "b" part where I need help.

Specifically:
part a. - HTML--->PHP
<Form Method="Post" Action="myPHPscript.php">
name
address
phone
e-mail
<form submitted>

b. PHP--->Perl

Now that "myPHPscript" knows the values of the variables (name, address, email, phone)
I will send these on to the MySQL database, yada yada yada

The Real Question

How can I pass these along to "myPerlScript.pl" without having the user input anymore information.

If they have to press another button (e.g. press here to confirm your entry) that would be fine.

Ideally the scripts would handle all the data after the user pressed the submit button in step "a".

Thanks in advance for your help.

[Anon]

I'd use solution #3 (just because of my personal taste).

html form:
<form action=dbwrite.php ...>

PHP does its job without any output (!) and passes everything along to perl using:

header("Location: dbwrite.cgi?field1=$field1&field2...");

the perl script can now do everything as usual, you don't even need to change it.

matto

[[deleted]]

Except that this will not work if the original form uses the POST method.

My choices:
1. Add the MySQL functions to the PERL scripts.

2. Port the PERL scripts to PHP.

3. Post the form data to perl, and then pas them to php.

[d-woo]

What if I used the GET method on the original form. I'm obviously avoiding the Perl Script editing. Some of my Perl scripts are on other servers to which I have no access.

[[deleted]]

If you used GET in the original, you can use GET in the rest too, no problem.

[d-woo]

Vincent,

On option #3. Post to Perl then to PHP.

Once an HTML form has posted to Perl,

what needs to be done to send this information (variables) to PHP?

That is the solution to my problem.

[[deleted]]

What needs to be done is that the PERL script needs to send the data to PHP.

How this is done is entirely up to you.
If you are in full control of the server I reccomend making the PERL script call the PHP script as an executable, and pass the parameters through the commandline or stdin.

Another solution could be to let the PERL script generate an HTTP header and literally POST the data to the PHP script through the webserver.
Examples of generating POST headers are all over this forum.