Updating text fields from dynamic SQL select box?

Trent_Hatred

Hi folks,

Ok, here's what I'd like to try and do.

I have a select box which pulls it's values from a MySQL database for shipping information as follows:

<?
	$query = "SELECT * FROM shipto_bchydro ORDER BY id DESC";
	$result = mysql_query($query) or die("Select Failed!");
	if (mysql_num_rows($result) > 0) {
	  echo "<select name=\"shipid\" class=\"form\">";  

	  echo "<option value=\"\">Choose Shipto</option>";
	  while ($hasil = mysql_fetch_array($result)) {				  	
	    echo "<option value=\"".$hasil['id']."\">".$hasil['address']."</option>";
	  }
	  echo "</select>";
	}
?>

So, the query will pull "division", "address", "city" and "postalcode" values.

I've created the select box just fine, and what I would like to do is have a function that will change 4 text fields when the user chooses (onchange) a different option from the select box.

So, below that select box will be 4 form fields. User selects "1341 Greenway Ave", and it updates the four text fields to the division/address/city/postalcode of the "1341 Greenway Ave" address.

Is this possible?

P.S. Sorry if this is more of a javascript question. I figured it would fit better here due to the select and data being in PHP.

Cheers,
B

YappyDog

If your onChange action submits your form and rebuilds your page, it can be done in php. Otherwise you need to do it using JavaScript.

Trent_Hatred

Hi Yappy,

The onchange function, I was hoping, would update the text fields dynamically rather than submit the form.

Any idea how I would go about building this? It's a strange one because it first queries the database and populates a dropdown box, then, when the selection changes, it updates text fields...

Very confusing to me.

Would it be something like this?

example

EDIT - Better yet, here's an example of what I'm looking to do, but ... how do I incorporate my SQL query into it?

<html>
<head>
<title>untitled</title>
</head>
<body>
<form>
<select name="prod_serial_no" 
onchange="prod_name.value=this.selectedIndex?this[this.selectedIndex].text:''">
<option value="">choose</option>
<option value="12345">Product 1</option>
<option value="23451">Product 2</option>
<option value="34512">Product 3</option>
<option value="45123">Product 4</option>
<option value="51234">Product 5</option>
</select><br>
Product chosen: <input name="prod_name" type="text" readonly="readonly" 
onfocus="if(this.readOnly==null)this.blur()"><br>
</form>
</body>
</html>

Cheers
B

Trent_Hatred

Ok, here's the solution that I came up with. Might not be the best way to do it, but it works.

<html>
<head>

<script language="JavaScript">
function Choice()
{
var1 = form1.d1.value
var2 = var1.split("!")

for (var i=0; i < var2.length; i++) {
}
form1.textField0.value = var2[0];
form1.textField1.value = var2[1];
form1.textField2.value = var2[2];
form1.textField3.value = var2[3];
}
</script>
</head>
<body>

<form name=form1>
<select name="d1" onChange="Javascript:Choice();">
<?
	$query = "SELECT * FROM shipto_bchydro ORDER BY id DESC";
	$result = mysql_query($query) or die("Select Failed!");
	if (mysql_num_rows($result) > 0) {
	  echo "<option value=\"\">Choose Shipto</option>";
	  while ($hasil = mysql_fetch_array($result)) {				  	
	    echo "<option value=\"".$hasil['division']."!".$hasil['address']."!".$hasil['cityProvPostal']."!".$hasil['attn']."\">".$hasil['address']."</option>";
	  }
	  echo "</select>";
	}
	echo "$hasil[id]";
?>
<input type="text" name=textField0 Disabled....>
<input type="text" name=textField1 Disabled....>
<input type="text" name=textField2 Disabled....>
<input type="text" name=textField3 Disabled....>
</form>
</body>
</html>

Essentially what I did was in the option value for each option, I included multiple values from the database (division/address/attn/cityProvPostal) seperated by a "!".

Then, onchange it passes to the javascript function which splits the string and then dumps the values into the text fields.

😉

Cheers,
B