how to get dynamic value by ajax function call

Question

on my web page i have text area like this enter image description here

and i suppose to get data in textarea when i alternate the value of select box( or onChange event), so i used ajax function

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
        <script>                          
                function myCall() {
                    var request = $.ajax({
                        url: "ajax.php",
                        type: "GET",            
                        dataType: "html"
                    });

                    request.done(function(msg) {
                        $("#mybox").html(msg);          
                    });

                    request.fail(function(jqXHR, textStatus) {
                        alert( "Request failed: " + textStatus );
                    });
                }

        </script>

and this is my select box code,

<select name="txtname" id="txtname" onChange="myCall()" >
    <option value="0">Select Age:</option>
    <option value="100083">100083</option>
    <option value="22-26">22-26</option>
    <option value="26-30">26-30</option>
    <option value="30-34">30-34</option>

    </select>

actualy i want to fetch record on the basis of select box value, this function working fine for static value but i am puzzled how to get data from data base.. and my ajax page coding is here..

<?php



$con=mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("hmc", $con);


$sql="SELECT * FROM news WHERE name = '22-26'";

$result = mysql_query($sql);
?>


                       <?php
  while($row=mysql_fetch_array($result))
{
?>
        <tr>
<td>
<?php echo $row['news1'];?></h3></td>

</tr><br /><hr /><br />

<?php
}
?>




</div>

any idea will be appreciated...

i want to fetch record in textarea by onchange

Dinesh
– Dinesh

2013-04-18 12:03:25 +00:00
Commented Apr 18, 2013 at 12:03 — Dinesh
– Dinesh, Commented Apr 18, 2013 at 12:03

chandresh_cool · Accepted Answer · 2013-04-18 12:03:10Z

1

Your ajax call is not proper, you need to pass your select box value to the php side, like this

$.ajax({
                    url: "ajax.php",
                    type: "GET",            
                    dataType: "html",
                    data:"value="+$("#txtname").val();
                });

then use this value on php side using $_GET['value']

answered Apr 18, 2013 at 12:03

chandresh_cool

11.9k3 gold badges32 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dinesh Over a year ago

i paste all relevent data regarding ajax call...can you tell me how to get "value" on ajax.php page, i tried like this $q=$_GET['value'];

Dinesh Over a year ago

but on my original page its showing request failed: error...??

Collectives™ on Stack Overflow

how to get dynamic value by ajax function call

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related