how to get value from php select item with java script, or jquery, where select item value is from query mysql

Question

i have autocomplete function in jquery like this

$(document).ready(function(){
    `...`
$("#tag").autocomplete("autocomplete.php?bro="+valBro, {
        selectFirst: true
    });`

i need to get value from selected item from my php code for my valBro variabel, my php code like this:

<select name="region_name" id="region_name"> 
<?php
$regionQuery = mysql_query("SELECT * FROM region ORDER BY id_region");
while($reg=mysql_fetch_array($regionQuery)){
echo "<option value=\"$reg[id_region]\">$reg[region_name]</option>\n";
          }
 ?>
    </select>

I have try to add jquery code in my above function

 var valBro=$("#region_name").val();

but give me nothing I have also try to add

var valBro=document.getElementById("region_name").value;

I have try to set valBro variabel as global variabel, and call change.function like this before function autocomplete

$("#region_name").change(function(){
valBro = $("#region_name").val();

}); And got nothing... Any help?

no there is no error, is it possible to get the value from html objeck where the value from query? — eniac05
– eniac05, Commented Jul 6, 2015 at 2:23

Anik Islam Abhi · Accepted Answer · 2015-07-06 03:26:11Z

2

Your data shouldn't be show because you are not providing any query in this line

$reg=mysql_fetch_array($region)

but your query is in this variable

$regionQuery = mysql_query("SELECT * FROM region ORDER BY id_region");

Try like this

$reg=mysql_fetch_array($regionQuery)

EDIT

Javascript

$(document).ready(function() {

    var tag = $("#tag"),   
    region_name = $("#region_name"),
    options = region_name.find("option");
    var value = options.filter(":selected").attr("value");
    tag.autocomplete({
        source: "autocomplete.php?bro=" + value,
        selectFirst: true
    });

    region_name.on("change", function() {
        value = options.filter(":selected").attr("value");
        tag.autocomplete("option", "source", "autocomplete.php?bro=" + value);
    });


});

edited Jul 6, 2015 at 3:26

answered Jul 6, 2015 at 2:21

Anik Islam Abhi

25.4k8 gold badges61 silver badges82 bronze badges

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

5 Comments

eniac05 Over a year ago

sory, i have misedit my code region from my original code, because the code in my country language, but in my original code i have $reg=mysql_fetch_array($regionQuery), i dont get error console. Any help?

Anik Islam Abhi Over a year ago

Where did you put it var valBro=$("#region_name").val(); ?

eniac05 Over a year ago

in exacly above my autocomplet function

Anik Islam Abhi Over a year ago

$("#region_name").val(); return the selected value of select. it called before the php generate value. add a timeout to get the value

eniac05 Over a year ago

sorry i am new be in php or java script, can you more detail, how i add timeout to get the value?

Collectives™ on Stack Overflow

how to get value from php select item with java script, or jquery, where select item value is from query mysql

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related