passing javascript variable to php

[Anon]

Hi there,

I'm developing a webpage that uses Javascript for its user interface and php to communicate with the database.

How is it that one pass a variable from javascript function to php function.

Let's say
<form name="TheForm">
<select name="choice" onChange="Do_Stuff(this.form);">
<option value="1">Choice 1
<option value="2">Choice 2
</select>
</form>

<script language="javascript">

function Do_Stuff(form) {
var SQL; //TO BE PASSED TO PHP
selectedOption = this.form.choice.value
Switch (selectedOption) {
Case 1:
/SQL= "select Field01 from table01 where Field01 Like 'Y%'";
pass over to Php to process and be displayed on the page/
Case 2:
/differs from Case 1's sql statement, but the idea is the same /
default:
break;
}
}

</script>

<?php

function Take_From_DB() {
@include('adodb/adodb.inc.php'); // load code common to ADODB
ADOLoadCode('access'); // load Access code
$con = &ADONewConnection(); // create a connection
$con->Connect('CD'); // connect to MS-Access using DSN name
/ACCEPTS VAR SQL; FROM JSCRIPT AND STORE INTO $SQL/
$recordSet = &$con->Execute($SQL);

/*echo "
	<form name = \"CW\">
    <select name=\"theBOX\" size=\"15\" multiple >";*/
echo "<TABLE><TR><TD><form name=\"CW\" method=\"GET\" Action=\"\">
  <Select name=\"theBOX\" size=\"15\" multiple >";

while(!$recordSet->EOF) {
    $num = $recordSet->fields[0].' '.@$recordSet->fields[1];
    echo "<option value>$num";
    $recordSet->MoveNext();
}

echo "</Select></TD><TD Valign=\"center\"><table><tr>
  <input type=\"button\" value=\">> \" onClick=\"Run(this.form);\"></tr> 
  <tr align=\"center\"><input type=\"button\" value=\"  > \"></tr> 
  <tr align=\"center\">
  <input type=\"button\" value=\" <  \"></tr>
  <tr>
  <input type=\"button\" value=\" <<\"></tr>
  </table>
  </TD>
  </TR>
  </TABLE>
  </form>";

}
?>

[Anon]

You should just set the HTML up as a form to submit to the same page with a hidden value like so:

<form name="TheForm" action="thisForm.asp" method="post">
<input type="hidden" name="type" value="resubmitted">
<select name="choice" onChange="TheForm.submit();">
<option value="1">Choice 1
<option value="2">Choice 2
</select>
</form>

then in your php parse the SQL queries

if($type=="resubmitted")
{
...yada yada
}
else
{
...yada yada
}