Auto Populate Textfield Via Dropdown Box?
Feb 11, 2009
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]......
View 7 Replies
ADVERTISEMENT
Oct 5, 2005
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:
View 1 Replies
View Related
Feb 22, 2011
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]....
View 7 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 9, 2009
I have a recipients input textfield called 'recipient', which takes usernames separated by a comma. Next to this field I have a list of usernames wrapped in span tags with a title attribute holding the username. I'm using the following code to set the value of the textfield. However it only takes one username instead of adding to it. I also don't know how to add a comma automatically when a username gets clicked.
Code:
$(document).ready(function() {
$('span.contact').click(function() {
var title = $(this).attr('title');
[code]....
View 12 Replies
View Related
Nov 2, 2011
I'd like to pre populate a hidden textfield with todays date: 02/11/11 so far, I have:
today = new Date()
today.getDate()+"/"+today.getMonth() + 1 +"/"today.getFullYear()
$('#date').html('<h4>Date: '+ today +'</h4>');
View 7 Replies
View Related
Sep 8, 2010
Does anyone happen to know how I would go about populating a text field with x value when a specific image was clicked?
Scenario:
I have a div of 3 images. Each image represents a different color.
When you click an image.. I need a text field to be populated with the color name..
So if you clicked an image that looked like ivory.. textfield would then say ivory.
View 1 Replies
View Related
Nov 15, 2011
Here is the code I have written but it is only taking one value out of the several checkbox checked
View 3 Replies
View Related
Jun 23, 2011
Using Jquery I want to populate a 2nd dropdown from the choice of the first dropdown.
View 1 Replies
View Related
Oct 14, 2010
The first dropdown has some options as :
abc(a)
bcd(a)
cde(b)
[Code]....
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.
View 4 Replies
View Related
Aug 31, 2005
I have a form with 3 textfields of max chars 1. I would like the form to be dynamic in such a way that:
a) If textfield A is empty, the User cannot input anything into textfield B and textfield C. Similarly, if A is filled in but B is not, the user cannot input anything into C before B is filled in as well.
b) Once the User key in a character into textfield A, the key cursor will automatically go to textfield B (instead of the User having to 'tab' to the next textfield). The sequence would be A to B to C.
View 2 Replies
View Related
Mar 19, 2010
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
Code:
<script type="text/javascript">
function showname(what)
{
what.form.textfield.value=what.options[what.selectedIndex].title
}
window.onload=function() {
showname(document.form1.number)
}
[Code]...
View 3 Replies
View Related
Jul 20, 2005
I have a registration form for classes. Each class has a fee. I have a
drop down box whereby the user chooses his class. There is a textbox with
the associated fee. I would like to auto populate the fee textbox depending
on what class the user chooses. In the email, the value of the drop down
box has to be the name of the class and the value of the fee text box has to
be the fee. Can someone please help me in accomplishing this?
View 2 Replies
View Related
Nov 1, 2011
I'm trying to populate the city based on the country selection. Unfortunately my script is not working.Can anyone show me the way to fix my script?
[Code]...
View 1 Replies
View Related
Nov 2, 2006
There is a text field in a form that I would like to auto populate radio options.
Image 3 Text Fields one for first name, middle name and Last name.
There are also 3 radio group options for the person on how their name displayed
First Middle Last
First M. Last
First L.
I would like these three radio option labels to be populated as the user types in the form fields. Is this possible? If so can you point me in the right direction?
View 8 Replies
View Related
Mar 16, 2005
I am currently using "chained select menu" for drop down lists. I also have 2 popups of pictures and descriptions for items in my shopping cart. The chained select menu drop downs are linked to items in my shopping cart. What I would like to do is this...
I want there to be links (or Buttons) in the popup that when clicked will auto populate the drop downs and then then user will only have to click go to be taken to the url already specified in the chained slect menu script.
Basically, link the existing popups to auto populate the existing drop down menu..
Is there an existing javascript for this function or existing dhtml? If so, would anyone be so kind to direct me to it?
View 1 Replies
View Related
Nov 3, 2009
i'm currently designing a dropdown menu that can create a textfield or another dropdown menu based on the option from the first menu. is it possible to create this out of javascript?
Code:
<select name="dropdownMenu" id="dropdownMenu">
<option value="textfield">Show Textfield</option>
<option value="dropdown">Show Dropdown</option>
</select>
View 3 Replies
View Related
Oct 14, 2010
i am trying to populate a drop down menu from a pop up page. what i have its working on chrome but it does not work on IE and i was wondering if you may be able to know why. Here is my code:
[Code]...
View 2 Replies
View Related
Jul 9, 2009
I can't figure out why it dosen't work. I'd like to show/hide a <p> block depending on the value selected in the dropdown list:
$(document).ready(function(){
$('#report_rep_type').change(function(){
$('#report_rep_type').change(function(){
if($(this).text()!= 'Contigency Liabilities/Others')
$('#someElement').hide();
else
$('#someElement').show();
});
});
});
HTML code:
<form action="my action>
<fieldset>
<legend>Report details</legend>
<p>
<label for="report_rep_type">Report type</label><br />
<select id="report_rep_type" name="report[rep_type]"><option value="">Please select</option>
<option value="Scientific & Technical">Scientific & Technical</option>
<option value="Financial">Financial</option> .....
<p>
<button class="button " type="submit"><img alt="Tick" src="/images/silk/icons/tick.png?1245400388" /> Create</button>
</p>
</form>
View 7 Replies
View Related
Feb 8, 2011
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.
Code:
$(function() {
$('#DropDownList1').click(function() {
$("input#TextBox1").val(
(
[Code]....
View 4 Replies
View Related
Apr 10, 2006
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:
View 3 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
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
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
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.
[Code]...
View 2 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