PHP Drop Down List Selection Populates Second Dropdown List Or Text Box?
Jul 13, 2011
I have been struggling on a bit of code for a while now. I need to populate a second drop down list (Region) based upon the selection of the first (County).I have found a piece of code that works on its own and have adapted to suit my needs - see below. However, when I drop it into my main page the javascript is not working. It's because of the formObject but I just don't know enough to resolve this! Furthermore, I need the textboxes the user has already completed in the form to retain their value once the javascript kicks in as the completed form will submit to a database.This piece of code is working well . . . .
<?php
$link = mysql_connect('myhost', 'myusername', 'mypassword') or die('Could not connect: ' . mysql_error());
mysql_select_db('mydatabase') or die('Could not select database');[code]......
View 2 Replies
ADVERTISEMENT
Apr 20, 2011
I have two dropdown lists with the second one being dependent on the selection in the first.
Options in list 1: 1,3 or 4
List two should be enabled when 3 or 4 is selected in list 1.
So far so good, managed to get it to work with only one set of lists, but I actually have 18 of those sets in this form:
<select name="fw[$i]" id="fw[$i]">
<option value="1">FWH</option>
<option value="3">links</option>
<option value="4">rechts</option>
[Code]....
I'm not that adept in javascript programming, more like a trial and error guy, how has hit the wall with this problem.
View 20 Replies
View Related
Aug 16, 2010
i am writing a script that will update a dropdown list based on the selection of a previous list. the script is run by a PHP script, so instead of posting the PHP, i will post an example client-side script. the hierachy is: category, sub category, brand (but sometimes there exists no sub category and the PHP script queries and adds brands instead) everything works correctly, except for one major issue: you can not change the selection of the third (brand) box this could be an easy fix for some coders, but i am not experienced in javascript and could really use some help. here is an example script, sorry it is so long
[Code]...
View 4 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
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
Feb 28, 2004
Here is what I'm trying to accomplish: I've got a dropdown list that is populated via a php script. Whenever the user selects a value from the list, they have to click on the 'submit' button in order to retrieve the values. I don't want this .... I don't want them to click on the button, rather, retrieve the values from the DB immediately upon selection of a list item. Its like ... I select a value from the dropdown list and it automatically uses its value to retrieve relevant details from the DB, no need to click on any button or anything. How do I do this with js ? Can I accomplish the same with php as well....
View 3 Replies
View Related
Jan 11, 2007
I am creating a dropdown menu for my site because I have run out of space for a nav bar, what I would love to do is create a dropdown list that when an option is selected will jump to a specific URL.
View 2 Replies
View Related
Oct 27, 2010
Here is my dropdown menu:
<select name="peeps">
<option value="Frank Tompson">Frank Tompson</option>
<option value="Henry Wilson">Henry Wilson</option>
<option value="Bill Kent">Bill Kent</option>
<option value="Jessi McDonald"> Jessi McDonald</option>
<option value="John Hays">John Hays</option>
How can I make it so if I click on John Hays a JavaScript pop up will say Hello John Hays, and if I click on Bill Kent a popup will say hello Bill Kent and if I click on any other name nothing happens?
View 3 Replies
View Related
Nov 17, 2010
My goal is to get the value in the array from selection drop down list.Basically, I create an Array in Javascript and a selection drop down list in the body.
Code:
<script type="text/javascript">
var even = new Array(2, 4, 6);
[code]....
View 1 Replies
View Related
Nov 14, 2009
How can I open a selection from this drop down list in a new window?
<html>
<!-- Stop Underline script available from http://www.themssforum.com/FontpageProgramming/Hyperlink-underline/ -->
[code]....
View 6 Replies
View Related
Feb 9, 2010
I have a drop down selection box with several selections and if a person selects "other" from that box I want to show a comment box so they can fill in their comments. Otherwise the comment box will remain hidden.
View 1 Replies
View Related
Jul 28, 2010
I am trying to create a drop down list which depend to the value selected from the previous drop down list. I can add it without problem, but If I change again the value of the first drop down list I would like to remove the previous drop down list generated from the first value. If I try to remove it when I create the element, it even does not create the element, the remove element function seems to work because when you click on the remove link it works.
[Code]...
View 4 Replies
View Related
Apr 27, 2011
rm validation! I want this to be validated upon selection of the drop down list (not when it comes to submit button)I have 2 drop down lists:Starting date (June 5th, 6th 7th)Ending date (June 5th, 6th 7th)I want to write a script that would NOT ALLOW one to choose:- Starting date June 6th and Ending date June 5th- Starting date June 7th and Ending date June 6th- Starting date June 7th and Ending date June 5th
View 6 Replies
View Related
May 1, 2009
I have the following code I picked up which tries to fill in a text field with data depending on a user's menu item selection. I place this code in the header:
Code:
var colors = new Array();
colors["apple"] = "red";
colors["grape"] = "purple";
colors["milk"] = "white";
colors["cheese"] = "yellow";
colors["chicken"] = "white";
colors["beef"] = "red"; .....
var groups = new Array();
groups["apple"] = "fruit";
groups["grape"] = "fruit";
groups["milk"] = "diary";
groups["cheese"] = "diary";
groups["chicken"] = "meat";
groups["beef"] = "meat";
function printColorAndGroup(){
var value = document.getElementByName('food').options[document.getElementByName('food').selectedIndex].value;
document.getElementByName('food_group').value = groups[text];
document.getElementByName('food_color').value = colors[text];
}
I then use the following html in the body:
Code:
Food:
<select name="food" onchange="printColorAndGroup()">
<option>apple</option>
<option>grape</option>
<option>milk</option>
<option>cheese</option>
<option>chicken</option>
<option>beef</option>
</select>
Group:
<input type="text" name="food_group">
Color:
<input type="text" name="food_color">
But when I run this nothing happens...
Here's the page [URL]. None of the code above is colored... looks like I'm using the wrong tags here. Which tags should I use to post this stuff correctly?
View 12 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
Sep 1, 2010
I am trying to construct a Jukebox for my website. I have spent considerable time all over the WEB and at this forum which addressed the issue in a 50 page thread. Please see: [url]
I got a lot of ideas from this thread but still cannot figure a way to do the following within the Jukebox. These are my main two questions for everything below:
1.How can I have the Jukebox cycle through all tunes and then start over from the beginning?
2.How can I allow the user to select a tune from a list but not a drop down list, have the Jukebox start from the users selection and then play all songs to the end. Then as in #1, start over from the beginning?
Per this thread I came away with basically two ways to assemble the jukebox. One uses links in a drop down list which the user can choose from. The other is to use an .m3u playlist. The user can only select a playlist from the drop down.
Below, I have included the code for each Jukebox. To see the Jukeboxes in action please go to my website where I have posted some test pages exhibiting the jukeboxes that I am referring to.
The following is the Jukebox which utilizes an .m3u playlist. If I end up using this idea I would like the tunes in the .m3u playlist to be displayed and allow the user to be able to choose a tune in the list. Then have the list play to the end of all tunes in the list. Then start over from the beginning of the list. After this code is the .m3u playlist.
Go to url removed and click on the link that says:
Jukebox utilizing an .m3u playlist:
Here is the .m3u playlist for the above code:
The following code is for the Jukebox that has a list of links in a dropdown list. If I go with this idea, I would like for the list not to be a dropdown list but just a list of tunes. The user should be able to click on any tune in the list and the player should start from that point, play all the remaining tunes in the list and then start from the beginning.
Go to url removed and click on the link that says:
Another idea I found on the WEB also uses an .m3u playlist. The good thing about it is that it lists all the tunes in the playlist which the user can then select from. This jukebox calls up an entire Windows Media Player. If I was to use this idea I would like to be able to disable the left side of the player where the user has options such as burning to CD, Media Guide, Radio Tuner etc¦
Go to url removed and click on the link that says:
View 1 Replies
View Related
Aug 2, 2011
I have a table that has parts with multiple characteristics. Part Number, Height, Width, Capacity, Price, Etc. I would like to have a drop downs for all of these values, when a user selects one of these values it will filter the results into a list. Ex. user selects a part that has a Height of 6 and width of 10 it will only list those parts. As I said earlier, I have a script that will give me all the parts, however I am not able to make the onchange list parts with multiple values.
View 9 Replies
View Related
Jun 9, 2009
I have a page that displays a list of people playing in a tournament. I need to be able to generate a Leaderboard based on which players are manually selected by the admin. Next to each person there is a drop-down list. An admin can go in and select a "slot" that a player should be in on the leader board from 1 to 8, or leave it blank if none. What I need to figure out how to do is the following, when a change event happens on a drop-down list, and say the value 5 is selected, I need to check to make sure that 5 is not already selected in one of the other players drop-down lists, in other words, that the 5th leaderboard slot is not already full. if it is, display an error message and make them change that one first. how to do that with jQuery? I'm thinking it will have something to do with the each() function, but not sure exactly how the logic should work.
View 4 Replies
View Related
May 10, 2007
I'm looking for have a text field when a user clicks in the text field a drop list of values appears for the user selects from and populates the text box they clicked. Is there anywhere I can find this or something similar?
View 1 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
Apr 6, 2011
I have the following html:[code]I would like to know if there was a solution in JS which would change the occurance of the 'and' in the last option to '&'.Therefore after the JS has kicked in, the html will read:[code]
View 3 Replies
View Related
Nov 25, 2009
I have a form that has a pretty complicated combo box - a user starts typing text, it queries a database for matches, and displays the results to the user. The user can then select the match they desire and it has a value id, which I am currently sending to a hidden field in the form. So, for example: user starts typing in a movie name, Seven - it returns Seven and user selects it. The form submits the id of the movie seven (say 12) to a hidden field.
Where I am stumped: Once a user selects a movie title, I have another drop down select box that is to display the available formats of the movie by querying my database based on the product id (12) and returning the available formats in the list:
DVD
BLUERAY
VHS
I am pretty good at programming, but I cannot figure this out - how to make the select box fire and return results once the value for the textbox has been captured.
View 1 Replies
View Related
Sep 8, 2011
This is to update stock status automatically on a formPlease advisow this is done:When user enters value greater than 0 inside text input field.Status dropdown list selects option: In StockIf value inside text input field is <= 0.
View 5 Replies
View Related
Jun 30, 2009
I've been beating my head against a wall for a few days trying to get this working. I'm trying to create a dynamic menu where a user selects one item and another select list is shown, then another and another (and so on). Here is my JS, it *should* be taking the ID of the div, comparing it to the selected value and then showing another div by settings it's class property to visible:
[Code]...
View 1 Replies
View Related
Oct 25, 2011
I am asking jQuery to tell me which drop down option is selected in a drop down list - like this:
I would like to check if this was successful before I proceed. What are the possible return values for this statement?
If no id exists.
If no option is selected.
If some other problem occurred.
In these cases am I expecting a null return; an undefined return, a false return value?
And, based upon the complete set of return possibilities, what would be the best and most comprehensive tests I could apply to cover every base.
View 4 Replies
View Related
Jul 23, 2005
When I input my email address on this website, it provides a drop down
box with two of my email addresses. The right bottom corner has a few
45 degree lines to indicate the user can change its size. Do you know
how to create it? I could not find the code in the source.
View 7 Replies
View Related
