JavaScript variable from PHP dynamic dropdown in MySQL

Question

I can get this popup to return the proper value when I type the actual var choice in to the url that exists in the database.

<script type="text/javascript">
var data = $.get("logbookincludes/sqftpoles.php?choice=Front Range", function(data) {
alert("Data Loaded: " + data);
});
</script>

I want the variable to be set by the actual dropdown selector id. I can't seem to get the syntax correct.

var data = $.get("logbookincludes/sqftpoles.php?choice=" +    $("#item36_select_1").val());

Here's the server side php to fill the selector dropdown.

zones.php

 <?php
  include("dbinfo.php");

$query = "SELECT zonename FROM zone";

$result=mysql_query($query);

while ($row=mysql_fetch_array($result)) {
    echo "<option>" . $row{'zonename'} . "</option>";
}
    ?>

Here's the dropdown code.

Zone
 <select name="zone" id="item36_select_1" required data-hint="">
        <option id="item36_0_option" selected value="Front Range">
          Front Range
        </option>
      <? include('logbookincludes/zones.php');?>
      </select>

Here's the sqftpoles.php

   <?php
   include("dbinfo.php");

$choice = mysql_real_escape_string($_GET['choice']);

$query = "SELECT sqftpoles FROM zone WHERE zonename = '$choice'";

$result=mysql_query($query);

    $result2=mysql_query($query2);
while ($row=mysql_fetch_array($result)) {
echo  $row{'sqftpoles'};
}   
   ?>

I just edited my post to include the server side php and the dropdown code. Makedon's reply returned an empty popup box. I'm only using it for testing. — Progrower
– Progrower, Commented Mar 16, 2013 at 14:26
Your sqftpoles.php file doesn't look like it's syntactically correct. — jithujose
– jithujose, Commented Mar 16, 2013 at 15:03
The sqftpoles.php returns the proper value in the popup in my original post when I type the actual variable into the url. — Progrower
– Progrower, Commented Mar 16, 2013 at 16:30

Progrower · Accepted Answer · 2013-03-17 11:45:27Z

1

It is example code correct:

$.get('http://stackoverflow.com/questions/tagged/' + 'javascript', function(data){
    alert(data);
})

Here's the code you need. Javascript is a client language

$.get('logbookincludes/sqftpoles.php?choice=' + $("#item36_select_1").val(), function(data){
    alert(data);
});



function updatesub(){
  $.get('logbookincludes/sqftpoles.php?choice=' + $("#item36_select_1").val(), function(data){
   var u = $('#item44_number_1').val()-0,
       q = $('#sqftofzone').val()-0,
       n = data-0;
   $('#item49_number_1').val(u*q*n);
   alert(data);
});
}

edited Mar 17, 2013 at 11:45

Progrower

3836 silver badges20 bronze badges

answered Mar 16, 2013 at 12:46

makedon

3311 silver badge10 bronze badges

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

10 Comments

Progrower Over a year ago

Thanks for looking. Now I get an empty Popup.

makedon Over a year ago

Is it correct url logbookincludes/sqftpoles.php?choice=" + $("#item36_select_1").val() ?

makedon Over a year ago

You have to configure your Web server (or 127.0.0.1)? What is the address you type into your browser to see what gives your php code?

Progrower Over a year ago

Yes,this works. $.get("logbookincludes/sqftpoles.php?choice=Front Range", function(data) { alert("Data Loaded: " + data); Front Range is in the database. I just can't get it to pick it up from the selector. Which shows the proper value. I put it in as the default value for testing.

Progrower Over a year ago

Unsure of your question but here's the url to see the value show from direct url typing. ericrohloff.com/pesticide/logbookincludes/…

|

Collectives™ on Stack Overflow

JavaScript variable from PHP dynamic dropdown in MySQL

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related