Jquery :: Populate A List From A PHP Loop That Writes HTML Options From A Db?
Jul 5, 2011
The following PHP code populates a dropdown list of Projects. I would like to be able to click on a Project Name in the list and have its corresponding list of Characters appear beside it. How can I tie jquery into this as it's running? All the jquery examples I see are for hard coded HTML data instead of a PHP loop grabbing from a database.
Code:
//creates the Project dropdown list
while ($proj = mysql_fetch_array($project)){
$id_proj = $proj['projid'];
$name_proj = htmlspecialchars($proj['projectName']);
[Code]....
I don't care if it's a clickable list of anchors instead of a dropdown. Also, I don't care whether people have javascript enabled as this is for my personal use.
View 6 Replies
ADVERTISEMENT
May 21, 2009
I have two select lists, the first one has three options in it, What I need to have happen is once a option is selected in the first drop down, the second drop down will be populated with the remaining two options.
View 2 Replies
View Related
Aug 14, 2011
I want to use arrays to populate an HTML list. I can populate the main list items but I can't seem to get the sub list items to work.
<HTML>
<Body>
<ul>
<script>
var pages = ["page1", "page2","page3"];
var subPages = ["sub1","sub2"];
for(var i = 0; i < pages.length; i++){
var page = pages[i];
document.write('<li>' + page + '</li>');
if (page == "page2"){
document.write('<ul>');
for(var i = 0; i < subPages.length; i++){
var subPage = subPages[i];
document.write('<li>' + subPage + '</li>');
} document.write('</ul'>);
}}
</script>
</ul>
</body>
</HTML>
View 29 Replies
View Related
Jun 16, 2010
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..
View 2 Replies
View Related
Jan 16, 2011
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.
View 2 Replies
View Related
Jan 23, 2010
Actually this is the same like the pop-up calendar but the only difference is I don't want numbers, I need a list of options so user can choose and when they select, it will transfer to the textbox right away like the calendar. I have a form and trying to use a pop-up window to select an option then transfer the option selected to show on the textbox. I have 10 textboxes and all of them has a "Select" button to pop-up the option list. BTW, the "SELECT" button will populate the same option list.
Here is my html code:
<select id="droplist" name="droplist" size="1" >
<option>Click to select...</option>
<?php foreach ($designation_list as $descode => $prompt) : ?>
<option <?php echo helper_selected($prompt == $form['droplist']); ?> value="<?php echo $prompt; ?>" style="width:500"><?php safeEcho($prompt); ?> </option>
<?php endforeach; ?>
</select>
Below is array:
<?php
$designation_list = array(
"00111" =>"Aloha of the Pacific/Transfer Assistance Program for High Income Students",
"71122" =>"Aloha",
"71231" =>"Free Housing Information",
"71232" => "Drama Queen and King",
"98765" => "Aloha Boy Home of the Land",
"12345" => "Aloha Home",
);
I wanted to use the option list over and over again for the 10 textboxes. Is that possible?
Below is my sample code but didn't work.
//javascript
var testpopup5 = new PopupWindow("testdiv5");
testpopup5.offsetX=-20;
testpopup5.offsetY=20;
testpopup5.autoHide();
var testpopup5input=null; .....
I get this code from somewhere else but it doesn't work on me.
View 1 Replies
View Related
Mar 7, 2011
I have 3 ASP list boxes. I would like to populate the second list box based on the selection in the first list box and based on the selection in the second list box, populate the third. I would like to do this using AJAX. How can I do it? Can someone please give me the code snippet as I am a complete noob when it comes to AJAX and I kinda am running outta time to finish implementing it. Additionally, should I use ASP boxes or HTML <select> tag?
View 4 Replies
View Related
Apr 3, 2011
I have a page that runs a lot of calculations.The math is computed on the fly using java scriptwhen all the calcs are in, prior to form submission the user needs to evaluate which numbers they prefer, and from there, once they select them, the form, based on those choices, will perform one last calclets say we have 3 result fields
r1 = 2000
r2 = 3000
r3 = 4000
what i want to do is have a select field be able to display those values at the bottom of the page;for example
<select name="s1">
<option value=[field contents of r1 above]>[field contents of r1 above]</option>
<option value=[field contents of r2 above]>[field contents of r2 above]</option>
[code]....
View 10 Replies
View Related
Oct 7, 2010
I need to populate a drop down list from sql server via jquery.I'm unfortunately unable to use any server-side type coding
View 1 Replies
View Related
Feb 6, 2009
I'm looking for a tutorial type of help on using JQuery to create/populate a selection list. I've looked at their site (and searched on their site/google) and although there is tons of stuff there, I can't find what I need.
View 5 Replies
View Related
Sep 29, 2007
I have several lists each of several hundred selectable items. I send
all lists to the client along with the javascript. When the user types
the first letter of the item in a text box, I know which list to
present- it is likely the user will wish to view several of the lists
concurrently (I am not concerned at the extra load time of a few
thousand items sent via javascript). However, I am trying to do
everything client side- (even if I use ajax to call the list from the
server, there is delay at the client side as the listbox is populated
with appropriate items) - can anyone think of a manner of presenting a
long list dynamically, based on the first letter typed, client side
and with the absolute minimum of delay? (These items then need to be
selectable)
View 1 Replies
View Related
Mar 27, 2009
I know that this is very basic to most of you JS Guru's out there, but I am stumped. I have found dozens of tuts on this, but can't seem to find a VERY simple basic version of it. This is what I want, actually my client wants. I want to have a select list that gives the options of countries. Then upon selection this changes the drop down list of the states/provinces listed. So when I click on Europe it shows the different sections of Europe, and US it shows the states (I'm sorry I don't know what Europe calls their equivalent of a state), etc.
View 6 Replies
View Related
Sep 13, 2004
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?
View 3 Replies
View Related
Nov 28, 2011
I am facing the above problem for a chatroom app that I am making. People will enter and exit the room any time they want, so i need a member list that updates itself to reflect this on the screen of all users that are in the chatroom. What i have thought of, is to have JS call a PHP function on specific intervals, and that PHP function will retrieve user data from a database and pass it to JS to display on the list. Is this method advisable? Are there any more suitable ways of doing this? I am thinking of applying the same theory for displaying and retrieving chat messages, but i get the feeling that something's missing for this, or maybe this method is not right for displaying messages.
View 1 Replies
View Related
Aug 15, 2010
I am using Javascript & PHP to populate a select list. The Ajax is working perfectly as I have tested it. However, as you can see from the below code, I have a button which adds more rows (which includes 2 select lists and file input) to a table.
When I click Add Row, the row is added perfectly and both select boxes along with the file field are shown as expected. The problem occurs when I select a value from the "room_name[]" box - there are no values returned inside the "album_title[]" select box. It doesn't seem to be triggering the onChange event.
code JavaScript:
function addRow(tableID) {
var table = document.getElementById(tableID);
[code]...
View 2 Replies
View Related
May 13, 2003
I was wondering if anyone can point me to an example where:
You select an option from a drop down list Based on what you select, if writes information to 1 or more text fields.
View 3 Replies
View Related
May 1, 2009
how to create a somewhat simple form. The form will have text fields for 'Name', 'Phone', etc. What I want is to have a drop down list, which has different insurances to choose from (i.e. Medical Insurance, Dental Insurance, Senior products), and say when I choose 'Senior Products', new text fields pop up within the form to add their 'Address' and click a checkbox that states they authorize to be contacted. These new fields aren't visible unless they choose 'Senior Products' from the drop down list.
View 6 Replies
View Related
Oct 1, 2010
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.
<table class="exemption" border="0" cellpadding="2"
cellspacing="5" bgcolor="#eeeeee">
<th colspan="2" align="center">Security Exemption Request</th>
[code]....
View 1 Replies
View Related
Jun 1, 2011
I am developing a web application in java (jsp's and servlets). For the project I am working on I will need to develop an html data entry screen and the code to load data into the screen, and then save the data back to the back-end database.
How to do the following:
Read the data out of the database (JDBC, no problem) in a servlet.
Put the data into the appropriate form for returning to the data entry screen, which will be a jsp. (Is JSON the right choice for passing the data from the servlet to the jsp?)
In the jsp, parse the returned data and populate the HTML form elements (text fields and combo boxes). When a button is clicked, pull the data out of the form elements and return to a servlet for saving back in the database.
View 4 Replies
View Related
Aug 4, 2006
I have a multiple select list that is created dynamically based on a previous selection on an asp page. The first thing I do is to clear the curent option list by
document.form1.itemcross.length = 0;
The only problem is that it leaves the optgroups. How do I also get rid of the optgroups?
View 16 Replies
View Related
Jan 21, 2010
I have 2 lists and function to clean them
function del_sel(option){
if (option == "1"){
document.forms[0].list1.innerHTML = '';
}if (option == "2"){
document.forms[0].list2.innerHTML = '';
}}
How to make this function shorter & without options? Something like that:
function del_sel(option){
document.forms[0].option.innerHTML = '';
}
The problem is that this code returns mistake:
function del_sel(option){
document.forms[0].option.innerHTML = '';
}
...
<input type='button' value='Delete onclick='del_sel(form.list1);>
View 2 Replies
View Related
Feb 5, 2010
Code JavaScript:
var listItems = "";
$.each(msg.d, function(index, value) {
listItems += "<li><a href='#' class='" + value.Availability + "' title='" + value.Time + "' >" + value.Time + " - " + value.Availability + "</a></li>"
});
var teeTimeLinks = $(listItems + 'li');
$.each(teeTimeLinks, function() {
var link = $(this).find('a');
link.bind('click', function(event) {
event.preventDefault(); //stop the link from going to href
TeeTimeSelected(this);
});
});
The above code works. BUT, msg.d returns 80 objects. We then loop through it and make our list items. AND then we loop through it again and apply the click event. How can this be optimized into one loop?
View 18 Replies
View Related
Jun 29, 2010
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.
View 1 Replies
View Related
Dec 3, 2009
I have set up my website quite some time ago that has served its purpose very well, however I will now be adding an order form functionality. So far, by reading books and traversing forums, I have been able to develop a page where the user
1.Enters data into the required fields, that is then submitted to a MYSQL database via PHP,
2.Can retrieve orders that are stored in the database,
3.Delete orders that are stored in the database.
I have wamp installed on my computer as the webserver. I have also incorporated two drop down lists that both retrieve their values from tables within the database. The first drop down list retrieves the Australian States that I have stored in a table, and once the submit button is pressed, it stores the State that is selected to a separate table. This drop down list functions as it should. An extract from "From Place an order.php"
<?php
$dbcnx = @mysql_connect('localhost', 'root', 'tingling');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');
} .....
The second drop down list retrieves product names from a table that contains products and their prices. What I would like to happen, is that when the product is selected from this drop down list, a text box is automatically filled with its corresponding price. I had this drop down list working as per the "States" drop down list, but could not get it to auto populate the text field. I got some assistance from a friend and was able to get the text box to auto populate with its corresponding price, however when the page was submitted to the database, the "id" number of the product name from the drop down list was stored, and not the product name.
<select name="productSelection" onchange = "getProductDetails(this)">
<option selected value="1product">Select Product</option>
<?php
$products1 = @mysql_query('SELECT * FROM products');
if (!$products1) {
exit('<p>Unable to obtain author list from the database.</p>'); .....
View 9 Replies
View Related
Apr 14, 2009
I have broken this problem down to its most basic element, though my real task is a bit more difficult. My situation is that I have a html page with javascript, and a javascript function that I want to populate an html div tag with (see the example below). What is happening is that the div tag is getting populated and displayed ever so quickly, then erased and replaced with the original html ouput. So, in my example below, I get the first div tag (div1) to display as the page loads (a form with a simple button). When the button is pushed, I populate the 2nd div tag (div2) with a simple text statement. It displays quickly then gets erased and the original display (from div1) is redisplayed by itself. I have zero clue why this is happening and I have tried many variations.
CODE:
View 2 Replies
View Related
Sep 11, 2010
I have a html file that I want to load, loop through the json data and for each json entry I want to add a new block of the html and insert the json data into the matching div/class of the html. json looks like this:
{"Super" : [{"Name" : "John Doe", "Age" : "30"}, {"Name" : "Jane Doe", "Age" : "40"}]};
html looks like this:
<div class="Name"></div><div class="Age"></div>
So for each json entry of name/age, I want to insert that into the html, and then add another row, until all json data has been fetched. After this I want to insert all of this into #box, which is just a divthat should contain that html. Looping like this obviously does not work, since I just keep replacing the same html through the loop.
var jsonData = {"Super" : [{"Name" : "John Doe", "Age" : "30"}, {"Name" : "Jane Doe", "Age" : "40"}]};
$.each(json.Super, function() {
$('#box .Name').html(this.Name);
$('#box .Age).html(this.Age);
});
View 3 Replies
View Related
