Selected value using jQuery, PHP, MySQL

Question

Does anybody know why I cannot specify the default value this way when it is pulling values from MySQL? I am ultimately trying to have it repopulate the dropdown lists with the appropriate $_REQUEST fields, so that editing can be easier.

  $(document).ready(function(){
    $("#region").load('getRecords.php?start=regions');
    });   //jQuery initializations 
...............

<select 
    class    = "region"
    name     = "region"
    onchange = "value = this.value; 
               $('.country').load('getRecords.php?region='+value)
">

    <option>.....Reading database.....</option>
</select>

<script>$('.region').val('Africa');</script> 
...............

This is the kind of info that gets placed

<option value = "">Select One Region-------</option>

<option value="Africa">Africa</option>

<option value="Americas">Americas</option>

<option value="Asia">Asia</option>

<option value="Australasia">Australasia</option>

<option value="Europe">Europe</option>

<option value = "">------or a Sub-Region------</option>

<option value="Alps">Alps</option>

<option value="Amazon">Amazon</option>
//ETC>>>>

I can only get the jQuery .val method to work for very simple setups.

you should really be keeping your JS code separate from your HTML — JohnP
– JohnP, Commented May 18, 2011 at 4:43
I agree. But then I thought the sequence might have been the issue, so I put it right underneath. Hah. — RD Ward
– RD Ward, Commented May 18, 2011 at 4:44
You should look into the optgroup property w3schools.com/tags/tag_optgroup.asp — Stephane Gosselin
– Stephane Gosselin, Commented May 18, 2011 at 5:20
These cascading lists are basically my only option, there are around 4300 provinces, which is the lowest hierarchical level I am aiming for :) — RD Ward
– RD Ward, Commented May 18, 2011 at 5:24
@stefgosselin Alas, read w3fools.com why referencing to w3schools is not advisable. — Alex R.
– Alex R., Commented May 18, 2011 at 7:19

Stephane Gosselin · Accepted Answer · 2011-05-18 05:12:50Z

1

Not quite sure what you are aiming for but maybe something like this will give you a nudge in the right direction (taken from the top of my head), probably has syntax errors.

$("select.region option[selected]").removeAttr("selected");
$("select.region option[value='Africa']").attr("selected", "selected");

answered May 18, 2011 at 5:12

Stephane Gosselin

9,1485 gold badges45 silver badges68 bronze badges

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

Comments

Deepika · Accepted Answer · 2011-05-18 04:51:27Z

0

try this:

document.getElementById("region").selectedIndex=0;//put index of the element which you want as default

and give id="region" in select tag

answered May 18, 2011 at 4:51

Deepika

4743 silver badges11 bronze badges

2 Comments

Alex R. Over a year ago

This will only select the first option. The asker wants to set a default value for the select. In this case, it can be any option in the list, provided that option is defined.

Stephane Gosselin Over a year ago

Op has jquery goodness available, why the document.getElementById() calls when you have Jquery begging to help you?

Luke Sneeringer · Accepted Answer · 2011-05-18 04:55:11Z

0

You need to have a valid <option value="Africa"> first before you can make that value become the default. <select> tags do not have arbitrary value attributes.

answered May 18, 2011 at 4:55

Luke Sneeringer

9,4382 gold badges39 silver badges32 bronze badges

3 Comments

RD Ward Over a year ago

The values are getting populated via MySQL. Is that not valid option? Along with a lot of other regions.

Luke Sneeringer Over a year ago

Where the data is ultimately stored is not the point. The problem is that your markup is wrong. You can get values from MySQL via. an AJAX response or whatever other means you like, but once you have them, you need to create an <option> tag for each, and then select one of those <option> tags to be the default.

RD Ward Over a year ago

I am not sure what you are saying, and I have no idea why you would think I would be pulling options without option tags.

Cyber · Accepted Answer · 2017-07-16 19:33:07Z

0

I recommend like below:

$('#region option[value="' + response_var[0].columnname + '"]').prop('selected', true);

answered Jul 16, 2017 at 19:33

Cyber

2,8244 gold badges25 silver badges43 bronze badges

Collectives™ on Stack Overflow

Selected value using jQuery, PHP, MySQL

4 Answers 4

Comments

2 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related