Obtaining Values from combo box at run-time into text box

You could make use of jQuery for detecting change events on the combo boxes and then obtaining their values:

http://api.jquery.com/category/events/

http://elegantcode.com/2009/07/01/jquery-playing-with-select-dropdownlistcombobox/


Then make use of the jQuery AJAX method to send the values to your PHP/SQL script where it can be utilised and a value returned back to your textbox:

http://api.jquery.com/jQuery.ajax/


That is obviously assuming you wish to perform this asynchronously.

<form method="post">
<label>Select Critarea</label>
<select name="critarea" id="critarea" onChange="this.form.submit();">
<option value="0">select critarea</option>
<option value="1">critearea_1</option>
<option value="2">critearea_2</option>
<option value="3">critearea_3</option>
</select>
<br/>
<label>Price</label>
<input type="text" name="price" value="<?php echo $result['price'];?>" >

</form>
<?php

$sql="select price from pricetable where priceid=".$_POST['critarea']."";
$result=mysql_query($sql);



?>

Ok

So I can use $("#ComboBox option:selected").text() to find the text from my combo boxes

and I can use $("#ComboBox").change(function() { /* do something here */ });

the do something part to add my query which checks the values from the 3 combo boxes and returns the equivalent price in my price text box.

Do I need to have this function in all three combo boxes?

Can you just give a short example of how the code will look, just dummy code for getting the results from the 3 combo boxes

So lets say you get A, B, and C from the combo box. I look in my table X, with query SELECT Price from table X where ColA= combo box1 value and Colb = combo box2 value and ColC = combo box 3 value

Can I use SQL with the dummy query typed above in the do something part. I can set a variable = query, and use the variable as value of my text box...

Mehul,

I have 3 different combo boxes, and the price will change when I change either of the values in the combo box,

also I save all the information into my database once the customer clicks submit

So I want the customer to be able to see the prices as he changes the 3 criteria, and once selected, then I add to my database

I have all the code except the part to find the rate.

I have the query to find the rate on my next form which outputs the receipt, but I want the customer to be able to choose which rate he wants based on the 3 criteria.

Thanks for your help!

I cannot provide a guarantee that the following code works (been a while since I worked with jQuery honestly) however it provides an example of the principle.  A quick google / browse of the jQuery docs would show you where I may have gone wrong.

The principle of the code though is that the .change() function of jQuery is applied to all elements of the page that have a CSS class 'ComboBox' (. (period) denotes classes whilst # (hash) denotes IDs) meaning any ComboBox elements you desire to have the event applied to should be set accordingly (or change the CSS class attribute value etc).  If a change event is detected on said elements then the ajax function is called into play which sends the values of the three ComboBoxes to a PHP page via POST, the returned message is then added to a TextBox with the specified ID attribute value.

Poop, forgot to add the code to the previous post.  I blame having been awake all night.

<script type="text/javascript">
$(document).ready(function() {
	$(".ComboBox").change(function() {
		$.ajax({
			type: "POST",
			url: 'ajax/perform-sql.php',
			data: "?comboBox1=" + $("#comboBox1").val() + "&comboBox2=" + $("#comboBox2").val() + "&comboBox3=" + $("#comboBox3").val();
			success: function(msg) {
				$("#resultTextBox").Text(msg);
			}
		});
	});
});
</script>

Select allOpen in new window

Can I input my SQL query in data?

That way I can output the result in my text box...

>>  Can I input my SQL query in data?

You could place your SQL query in the data property however due to the script running on the client, people could view your source code and therefore view the whole SQL statement.  This is obviously a security risk and therefore not advisable.  Unless I have misunderstood your meaning on this matter?

>>  That way I can output the result in my text box...

When the data is sent to the PHP file, the returned message is then processed by the success function:

success: function(msg) {
      $("#resultTextBox").Text(msg);
}

The above captures the returned message from the PHP file and sets the value of the TextBox to that of the returned message.

1) ComboBox change event detected
2) Values from all three ComboBoxes are captured and placed within the "data" property of the jQuery ajax function and sent to the PHP file
3) If the PHP file returns a message the "success" function captures the message and performs what ever action is stipulated

I don't need to worry about any security breaches as it is only a demo...

I basically check the origin, the destination, and the time frame the customer selects for the package

based on those 3 i provide the price

the 3 criteria mentioned above are in 3 different combo boxes

I have attached my code for the combo boxes, rate text box, and mySQL Query

<TR>

            <TD ALIGN="right" class="TrackMediumBlue">Time Warranty :</TD>
            <TD>&nbsp;</TD>
            <TD><select name="TimeWarranty" id="TimeWarranty">
                <option value="24Hours">24Hours</option>
                <option value="2Days">2Days</option>
                <option value="3Days">3Days</option>
                <option value="7Days">7Days</option>
                <option value="14Days">14Days</option>
            </select></TD>

<TR>
            <TD ALIGN="right" class="TrackNormalBlue">Origin : </TD>
            <TD>&nbsp;</TD>
            <TD><INPUT NAME="Origin" TYPE=TEXT id="Origin" maxlength="50" SIZE=40>
                <span class="REDLink">*</span> </TD>
          </TR>
          <TR>

            <TD ALIGN="right" class="TrackNormalBlue">Destination :</TD>
            <TD>&nbsp;</TD>
            <TD><INPUT NAME="Destination" TYPE=TEXT id="Destination" maxlength="50" SIZE=40>
                <span class="REDLink">*</span> </TD>
          </TR>

<TR>
            <TD ALIGN="right" class="TrackNormalBlue">Rate : </TD>
            <TD>&nbsp;</TD>
            <TD><INPUT NAME="Rate" TYPE=TEXT id="Rate" maxlength="50" SIZE=40>
                <span class="REDLink"></span> </TD>
          </TR>

If ($TimeWarranty == "24Hours") {
$query4 = "SELECT `24hrs` FROM `Rate` WHERE `Origin` = '$Origin' AND Destination = '$Destination' AND Type = '$Packagetype' ";
$result3 = mysql_query($query4) or die("Could not perform select query - " . mysql_error());
($row = mysql_fetch_array($result3, MYSQLI_ASSOC));
$x = "24hrs";
}
else if ($TimeWarranty == "2Days") {
$query5 = "SELECT `2days` from `Rate` WHERE `Origin` = '$Origin' AND  `Destination` = '$Destination' AND `Type` = '$Packagetype' ";
$result3 = mysql_query($query5) or die("Could not perform select query - " . mysql_error());
($row = mysql_fetch_array($result3, MYSQLI_ASSOC));
$x = "2days";
    }
else if ($TimeWarranty == "3Days") {
$query6 = "SELECT `3days` from `Rate` WHERE `Origin` = '$Origin' AND `Destination` = '$Destination' AND `Type` = '$Packagetype'";
$result3 = mysql_query($query6) or die("Could not perform select query - " . mysql_error());
($row = mysql_fetch_array($result3, MYSQLI_ASSOC));
$x = "3days";
    }
else if ($TimeWarranty == "7Days") {
$query7 = "SELECT `7days` from `Rate` WHERE `Origin` = '$Origin' AND `Destination` = '$Destination' AND `Type` = '$Packagetype'";
$result3 = mysql_query($query7) or die("Could not perform select query - " . mysql_error());
($row = mysql_fetch_array($result3, MYSQLI_ASSOC));
$x = "7days";
    }
else if ($TimeWarranty == "14Days") {
$query8 = "SELECT `14days` from `Rate` WHERE `Origin` = '$Origin' AND `Destination` = '$Destination' AND `Type` = '$Packagetype'";
$result3 = mysql_query($query8) or die("Could not perform select query - " . mysql_error());
($row = mysql_fetch_array($result3, MYSQLI_ASSOC));
$x = "14days";
    }
    else {
        echo ("Time Warranty not found");
    }

Rate: <?php echo $row[$x] ?> <BR>

Select allOpen in new window

Sorry, I left a copy & paste error on line 97;

>>  $destination = $_POST['packageType'];

Should be

$packageType = $_POST['packageType'];

I'll check out the code tomorrow and accept the solution.

Thanks for all your help!