JQuery :: Generic Function To Populate A Dropdown Using JSon?
Jan 5, 2012
I have quite a few calls on my page at different points to populate dropdowns using jSon responses from the server. It is all working fine now apart from one issue. The name of the field that sets the value and text of the new Option(s) being put into the dropdown.
The code works fine. When I call the post, I get the categoryid as a result.Now, I should modify the code above, so I can do:post the ajax call sending the category id. this is done get subcategories for this category, and build the array * json_encode the array and echo * get results back in jQuery ajax call, decode and build the < select > field *The array should be built with each element having a sub-array with id and name, right?
On selecting abc(a) in first dropdown the 'a' must get selected in second dropdown,on selecting cde(b) second dropdown must have 'b' and so on,also the second dropdown value should be disabled(grayed out) for user.Need the code in javascript.
Below is the code I use to populate a textboxes (compaddress) when I select the compname from the dropdown. I would like to be able to populate other textboxes such as the compdescription, compmaincontact and others when I select the compname from the dropdown. I think that I need an array but I really would like some advice on how to do it as all of my attempts have failed so far
I am populating a number of Select boxes on the server-side with a large number of options. I'd like to get the response size down without taxing the client browser too much. What do you think is the most efficient way to approach this problem?
Here are some considerations: The option text/values do not change very often, but could potentially change in the future. The page that holds the select boxes should never be cached, there are other aspects of the page that need to remain fresh. Firebug with YSlow is saying that the primed cache size of the page is 300Kb with all the select dropdowns and options, if I remove the options, the primed cache size of the page is 80Kb. I am considering breaking out the text/value pairs for the select boxes into a separate file that is cache-able calling it "valueTextPairs.js" and referencing it with a query string and some sort of server-generated MD5 hash of the data, so that if any of the values change, the client's cached version will be replaced by the latest version. Like so:[URL]...
Provided I do this, I anticipate that the primed cache size of the page will be reduced down to 80Kb (which I like) -- however, before I take the plunge, I am curious what you all think the performance effect will be?
I know the number of bytes on the wire will be reduced, but will this put a lot of additional pressure on the client's browser because I'd need to traverse the name/value pairs and add the options to the select boxes dynamically on the client end? If it seems reasonable to do this, what jQuery approach would be the most efficient? $('#selectId').html(options) with options = one big string? Adding each child option to the select in a loop? Something else?
Some client end folks are using IE6 so I am trying to tax the browser as little as possible, while also reducing the size of each request, trying to find a happy medium..
I want to write a generic clearForm function to clear the form when the user click CLEAR button.
Here's my attempts, because I want to take care all html controls. I think I need to test if the control is submit button, regular button. But I don't know what I should do on drop down box?
function clearForm() {var i=0; for (i=0; i<InputForm.elements.length-1; i++) {var obj = InputForm.elements[i]; document.write(obj.type); //runtime error: object doesn't support this property or method if (obj.type != "submit" && obj.type != "button") obj.value = ""; }}
I want to learn more about creating functions for element events without having to put onclick event in every tag. For example:
<script> document.getElementsByTagName('input').onclick = function () { alert('hello'); } </script>
Now, I know the above does not work as I have tried it but hopefully the idea of what I am trying to achieve here. Basically for every input tag, when the user triggers the event (click) it will do the same function.
Anyway, I would more so like to learn about this type of scripting where you assign functions to events. However, I dont know what to search for in google and the like. Where could I learn more about this?
I want to populate the right text box with the result of the drop down multiplied by the left text box. I'm able to do this already but with only one set. I want to be able to have multiple rows.
Here is the code I currently am using for the single.
What i want to do is populate a dropdown with data brought from mysql. However there is are two radio buttons i have which i want to choose what data the dropdown i populated with. This is the code i have so far. I don't have no js yet as my skill is php and mysql, not javascript. Code:
I have 2 dropdown list in my html. Is possible for me to populate the option values in the second dropdown list depend on what I select in the first one?
I am creating a site that has to do w/ pets. I want users to be able to select the type of pet they have from the first dropdown and then select from the second dropdown from choices dependant upon what they chose in the first dropdown.
So if they choose 'dog' as a pet type in the first drop down. I want the second drop down to display 'dog breeds'. If the choose 'cat' as a pet type I want the second drop down to display 'cat breeds'. This is what I have thus far.
My data table: Contains PetType(Column 1) and BreedType(Column 2)
My page form calls these two criteria Pet Type and Breed
I want to be able to insert this script into my form's HTML footer. Code:
What I'm trying to do is auto populate the foreign key with help of dropdown box that contains names of clients so if i select a name from dropdown box a textfield above should populate with it's ID(primary key).
Code: <td>Client ID : </td> <td><input type="text" id="cl_id" name="cl_id" value="<? $query = "SELECT * FROM client ";[code]......
I have a product select page that is really slow to use because 6 dropdowns must be populated and the page reloads after selecting each box, to get the options for the next box.
I want to speed it up as follows:
1) User selects one of 50 products from a dropdown list.
2) Page reloads, and all the possible options for the remaining 5 dropdown boxes are now populated (ie. list options all stored client side)
3) User can freely input the remaining 5 dropdowns without the page reloading.
Have a WAMP setup with Apache, PHP and Mysql service and I�m working on a HTML form which will have two drop-down controls where information is extracted from two tables in my DB.The first drop-down list called (name="sel_ControlArea") will decide what information the second drop-down list will have.So far I have managed to populate them when the page is loaded using PHP but run into problem when I make a change on the first drop-down list.Question one: What is the best/correct way to solve this problem?Is it to load all information into PHP arrays and then translate these to Javascript arrays, or should I go for AJAX, or XML or are there any other better ways ?I have tried to solve this using the first method, put data in a PHP array but run into problem with this data not properly loaded.This is first time for me to pose a question so please let me know if I have left out some important information or if I should describe this problem in a different way.
I've looked around and from what I can tell, the code seems right. Basically crating a JS array and passing PHP values to it to use in an onChange to fill a text field. The dropdown gets populated fine but the text field does not autopopulate onChange. I'm not too fluent with JS but have a good analytical mind and from what I can see, the logic seems right.
<?php include('connectdb.php'); $CENTRE = $_SESSION['centreAFB']; $qryFormList = mysql_query("SELECT * FROM tblLogin WHERE ACCT_TYPE = '2' AND loginCENTRE = '$CENTRE' ORDER BY loginNOM"); echo "<script type='text/javascript'> var formCourriel = new Array()"; while($resFormList = mysql_fetch_assoc($qryFormList)) [Code]....
I want to populate a combobox with data pulled from a mysql db . The value of second combobox depends on what's been selected in first combobox. I assume pulling the data completely when loading the combobox and then filtering it locally to populate the second combobox based on the selection in first combobox will suit my needs so that i do not have to query server.What is the best way of doing it?
I am trying to populate data from an xml file when a certain catergory from the dropdown menu is selected. The dropdown menu is also populated from a xml source different from the one where the data is stored that needs to be pulled. so when a category is selected from the dropdown - the selected value will populate the data from the xml source. I am having trouble displaying the data when a category is selected from the drop down menu.
I created two drop downs, where the second one dynamically updates according to first selection. Now I jus have 2 members in first drop down and 20 in second drop down. I hard coded using javascript. But by the end of this year the number increases to 100's, then we cannot hard code it. I use html,javascript,jsp for the webpage. Is there a way to populate the dropdowns with data in a text file where they can update the text file with new members.
I have two drop-down fields that are populated separately from the database. Here is my HTML/PHP code Drop-down field #1 <tr class=bodyTRstyle> <td width="35%"><p align="left">Venue</td> <td class=fieldTDstyle width="269"><p align="left"> <select name="VenueName" class=VenueName><option selected><?php echo $VenueName?></option
<?php $SelectVenueQuery="select * from venue order by VenueName"; $SelectVenueResult=mysql_query($SelectVenueQuery); while ($VenueRow=mysql_fetch_array($SelectVenueResult)){ extract($VenueRow); echo "<option value='$VenueName'>$VenueName";}?> </select></td></tr>
Drop-down Field #2 <tr class=bodyTRstyle> <td width="35%"><p align="left">Results</td> <td class=fieldTDstyle width="269"><p align="left"> <select name="GameResults" class=GameResults><option selected> <?php echo $GameResults?></option <?php $ResultsQuery="select * from result order by ResultDate"; $ResultsQueryResult=mysql_query($ResultsQuery);
While ($ResultsRow=mysql_fetch_array($ResultsQueryResult)){ extract($ResultsRow); echo "<option value='$ResultDate'>$ResultDate";}?> </select></td></tr>
This code works well as long as the two drop-downs are independent of each other. The result table has VenueName as an element, so each venue has a set of result records in the result table. This is how I want to change it: The Venue dropdown will remain as it is. Once the Venue Name is selected I want the result dropdown to populate with ONLY the result records containing a match on VenueName that was selected in the venue dropdown. How do I do that? Is it with a onChange Event? What are the changes that need to be made? How do I communicate to the second drop-down what was selected in the Venue drop-down??
how to populate a dropdown based on Another dropdown selection. This all should be a dynamic. Eg: I have two text boxes one is TechID and other is JOB ID. When I start typing Tech ID it suggests me the list of IDs which start with the input string i have put in Tech textbox. When i select the Tech ID the jobs associated to that Tech ID should be displayed in JOB ID text box as a dropdown list.