smnhicks

I'm creating an input screen using HTML, PHP and MySQL. The page consists of a series of input fields and a submit button at the bottom to add the record to the database (nothing unusual so far).

Half-way down the form I have a link to another PHP script and I want to pass some of the varaiables which have been entered further up the form to this second PHP script.

The problem I seem to be having is that because the input fields have not been submitted at this point then the variables passed are the values from the record which was last added to the database.

Is it possible to pass variables that currently sit on the input fields to the second script?

Below is an example of the PHP code I am using for the link:

<? echo "<a href = 'calculator.php?currency=".$currency["CurrencyID"]."' TARGET = '_blank'>Price Calculator</A></td>" ?>

Further up the script:
<?
include("misc.php");
@ $db = mysql_pconnect($host,$user,$password);
mysql_select_db($database);
$currency_rs = mysql_query("select CurrencyID, CurrencyName, CurrencySymbol from travel_currency");
for ($h = 0; $h < mysql_num_rows($currency_rs); $h++) {
$currency = mysql_fetch_array($currency_rs);
echo "<option value='".$currency["CurrencyID"]."'>".$currency["CurrencyName"]." (".$currency["CurrencySymbol"].")</option>"; }
?>

Thanks for your help.

Simomn

torrent

Please read the posting rules before posting. All PHP posts go in the PHP forum.

The short answer to your question is "no". Javascript cannot pass values to PHP. You can pass values the other way (i.e. from PHP to Javascript) but not the way you want to without reloading the page. PHP has no knowledge of the HTML and is not event driven by Javascript methods, therefore it does not know you have entered values in those form fields. When you submit a form the values are passed back into the page (or to another page) in the http header.