HTML form to PHP to Perl question

[d-woo]

Please assist.

I have an HTML form that posts to a Perl script
such as <form method="post" action="../cgi-bin/signup.pl>

I do not know Perl and therefore do not want to tamper with this script.

Is there a way for me to :

1st - POST the data (variables) from this HTML form
to a PHP script such as <form method="post" action="passalong.php3">
so that I may:

2nd - Store the information in a MySQL database and then:

3rd - Pass the required variables on to the Perl script
without tampering with the Perl? (maybe from within "passalong.php3")?

{basically, I just want to store the data then submit it to Perl}

[Anon]

In order to repost everything you have to create a new HTML form. That's kind of a pain, so why don't you just do the perl. It's better to just post things once.

The perl code is easy. Just put the phrase [ use DBI; ] at the top and here's the code you need to use to make an insert into a mysql database:

my $host = "dbi:mysql:host=your.host.com;database=the_db_name";
my $user = "username";
my $pass = "password";
my $dbh = DBI->connect($host,$user,$pass);
my $sth = $dbh->prepare("insert statement");
$sth->execute();
$dbh->disconnect();

[d-woo]

Thanks, I will insert into the Perl script.

For example, if I'm inserting name, email, and phone number
into the MySQL database from the Perl script how will the
insert statement look?

Will a Perl INSERT statement syntax be identical to a
PHP INSERT statement?

e.g.:
"INSERT INTO $tablename (sender_name, sender_email, sender_phone)
VALUES('$sender_name','$sender_email','$sender_phone')";