Changing Field Value + PHP

[obrienkev]

Hi all,

I want to populate a field with a database tables data based on a users selection.

The user selects an investment type from a select menu.
The select menu is populated by database table.

			
<select name="investment_type" id="investment_type">
<option value="0">Select Investment Type</option>
<?php
while($row = mssql_fetch_array($result))
{
echo '<optionvalue="'.$row['inv_ID'].'">'.$row['inv_type'].'</option>';
}
 ?>
</select>

Then based on the users selection another field should be populated with relevant data from the same table...

    <p>
      <label for="note">Note</label>
      <textarea cols="" rows="" name="note" id="note"></textarea>
    </p>

Any ideas how this is done?

Tried something like below involving javascript...

	<select name="inv_type" onchange="change();">
		<option value="<?php echo $test ?>">Test</option>
		<option value="two">Two</option>
	</select>

The JS:

	function change() {
		document.getElementById('note').innerHTML = document.frm_name.inv_type.value;
	}

That seems to work ok but I need to use inv_ID in the option value and have inv_note data appear in other field.

Thanks.

[esukf]

Is the following what you're after? It's basically a javascript onchange function which fills the textarea with the inv_note text from your db. All the notes are stored in a javascript array and will be visible in the html source.

If you don't want the notes to be visible in the html source, then you'll be better off using a onchange submit function to pull the note text from your db.

<?php

mysql_connect("localhost", "user", "password");
mysql_select_db("your_db");

$sql="select inv_ID, inv_type, inv_note from investment_table";

$type_array = array();
$id_array = array();

$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result))
{
 //option string
 $option .= '<option value="'.$row['inv_ID'].'">'.$row['inv_type'].'</option>';

 //arrays to build javascript array string
 $type_array[] = addslashes($row['inv_note']); //addslashes for javascript escape
 $id_array[] = $row['inv_ID'];
}

//create string for javascript assoc array format. "key1:value1", "key2:value2", ........
for($i=0; $i < sizeof($id_array); $i++){
  $javascript_array[$i] = '"'.$id_array[$i].'":"'.$type_array[$i].'"';  

}

?>
<script language="JavaScript">
<?php
	//echo javascript array var notes = {"key1:value1", "key2:value2", ...}
	echo 'var notes = {'.implode(',',$javascript_array).'};';
?>

function change(id) {
	document.getElementById('note').innerHTML = notes[id];
}

</script>
<form name="form1">
<select name="investment_type" id="investment_type" onChange="change(this.options[selectedIndex].value);">
<option value="0">Select Investment Type</option>
<?php
	echo $option;
?>
</select>
<p>
  <label for="note">Note</label>
  <textarea cols="30" rows="5" name="note" id="note"></textarea>
</p>
</form>

[obrienkev]

Thanks! That's it.

Any idea why the below doesnt work properly? The code field values dont appear in the textfield...
Below on same page as above code.

  <?php

// 2) Get all Country Codes
$query2 = "SELECT country_ID, country_name, code ".
		 "FROM issue_country";
$result2 = mssql_query($query2) or die('Select Error');

$type_array2 = array();
$id_array2 = array();

while($row2 = mssql_fetch_assoc($result2))
{
	// option string
       $option2 .= '<option value="'.$row2['country_ID'].'">'.$row2['country_name'].'</option>';

   // arrays to build javascript array string
   $type_array2[] = addslashes($row2['code']); //addslashes for javascript escape
   $id_array2[] = $row2['country_ID'];
}// end while

//create string for javascript assoc array format. "key1:value1", "key2:value2", ........
for($i=0; $i < sizeof($id_array2); $i++)
{
 $javascript_array2[$i] = '"'.$id_array2[$i].'":"'.$type_array2[$i].'"';  

}
?>

<script language="JavaScript">
<?php
    //echo javascript array var notes = {"key1:value1", "key2:value2", ...}
    echo 'var codes = {'.implode(',',$javascript_array2).'};';
?>

function change2(id) 
{
    document.getElementById('issue_country_code').innerHTML = codes[id];
}
</script>

<p>
<label for="issue_country">Issue Country</label>
<select name="issue_country" id="issue_country" onchange="change2(this.options[selectedIndex].value);">
<option value="0">Select Issue Country</option>
<?php
	echo $option2;
?>
</select>
</p>

<p>
 <label for="issue_country_code">Issue Country Code</label>
<input type="text" name="issue_country_code" id="issue_country_code" value="" />
</p>

[obrienkev]

Sorry to bump this but can anyone spot where the code is wrong.
When the user selects from a select menu a related field is to be populated with the relevant data.
The same is to happen with another form field. However only one field works properly.

Any ideas please?

Thanks.