dropdown field selction

Question

0.00/5 (No votes)

See more:

hi frnds,

in below code if i select fresh milk in another field it should display its price of it automatically plz help

HTML

<html>
<head>
<title>My Page</title>
</head>
<body>
<form name="myform" action="" method="POST">
<div align="center">
<select name="mydropdown">
<option value="Milk">Fresh Milk</option>
<option value="Cheese">Old Cheese</option>
<option value="Bread">Hot Bread</option>
</select>
</div>
</form>
</body>
</html>

Posted 27-Nov-13 19:33pm

Arun-23

Updated 27-Nov-13 19:55pm

walterhevedeich

v2

Add a Solution

Comments

Jain Nishant 28-Nov-13 1:37am

Hi..plz let me know from where you would like to fetch the prices??

Arun-23 28-Nov-13 1:47am

Mysql db phpmyadmin

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Debopam Pal · Answer 1 · 2013-11-27T20:06:00

Solution 1

Use AJAX calls in the select event of the dropdown list in JQuery. And at the same time display the price fetched by that AJAX calls.

Posted 27-Nov-13 20:06pm

Debopam Pal

Jenno Richi · Answer 2 · 2013-11-27T20:26:00

Its very simple - you can just use a ajax call and write it on change like this

XML

<select class="selectbox" name="mydropdown">
<option value="Milk">Fresh Milk</option>
<option value="Cheese">Old Cheese</option>
<option value="Bread">Hot Bread</option>
</select>

<script>
$(document).ready(function(){
    $(".selectbox").change(function(){
    var itemId = $(this).val();
    $.post( "ajax/getprice.php",{id : itemId }, function( data ) {
      $( "#anotherfieldId" ).val( data );
});
});
});
</script>

You can write your query to process and get the value in "ajax/getprice.php"
"data" is what you get in return