How would I make my page I have connect to a database using javascript dependent dropdowns? I have all the things I need to get the database working where it displays all the info in the database but I only want it to display based on what they select not all of it.
I have a calculate.js javascript file where all the function that execute the calculation is consist in this file. Now, I want to retrieve a data from the database for javascript calculation and be done in this calculate.js file. I have search a lot of methods to do this but most said cannot do this from a client-side.
Does anyone know if this is possible to have a online database? Or can I use access to make a database and then post it online and have it work on the internet?
i'm having the user input their state (from a drop down list) and type in a zipcode (there are 1,143 zip codes in the database to match to)..
what i want to happen is once the user selects the state they live in, and type in a zip code, i need the page to query the database if the user selected Ohio, and match the counties in the database with the zip code they entered, and then create a drop down list of the counties for them to select the one they live in Code:
im trying to get values from a database and assign them to icons which display on my page. The icons that are generated on the page are generated in javascript- and they do work. Howver i want icons to hold the names that are in the database/table.
how would i do this? would this be using a query result in asp to get the values from the database?? how would i do this? please provide code or guide.
then, how would i assign the database value with the icons???? ive heard javascript arrays??? how would i assign the values??
we had someone write this script for us a few years ago and we thought it was working fine until this week. It uses javascript to generate a dependant drop down menu eg. Depending on what the user chooses in the first drop down menu, (in this case a manual/book title) the second drop down displays the chapter/category headings that are available within that manual and then the users uploads a file that appears under that heading.
If our user adds a chapter/category heading with an apostrophe in it the script quits and the second drop down does not display the corresponding chapter headings. We are storing the info in a mysql database and use php and javascript to extract the data/build the drop down menus. Code:
Not sure if this is the correct forum as it covers data retrieved from mysql in a .js file...
I need to grab the last 5 rows from my database (2 fields per row) and list all 5 in a table but from within a .js file that I can externally link to.
I can manage the php / mysql and the output to a .php page but how can this be contained within a .js file?
I believe it is possible but after 2 days of searching on google I'm appealing for assistance.
I realise this could be done with a php include or iframe but that isn't an option and the only way available to import this data is via an external javascript script.
I have this PHP page that has the following functions...Insert Form into Table in MySQL DatabaseDelete Entry from Table in MySQL DatabaseA Link to a separate page where I Edit entries I have coded a PHP function for Delete. Looks like this:
// delete if provided if (isset($_GET['id'])) { // query to delete $query = "delete from student where STUDENT_ID =".$_GET['id']; //execute query if ($db->query($query)) {
Somewhere else I query the results and print them into a table. I added a column to this table with a Delete link for each row. Clicking on delete will execute the PHP function to delete.
From here however I need to change those links to Buttons. One for Delete and another for Edit and use JavaScript functions to make them work as they originally did. So this is what I've done...
Next I need to write functions...this is where I am lost. Usually I'd know what to do when referencing elements in forms, i'd do something like document.formname.inputname, but my problem is those links or should I call them actions are replaced by those new buttons.
Should I put them into a form, or make them hidden, and then name the element? Or should my function look something like this...all I really want to do is to call the function, and have the function just do the action of loading the link (don't know if that sounds clear). I've tried to do this but it does not work.
<script> function Delete() { document.myform2.action="href='$_SERVER['PHP_SELF']."?id=".$row[0]'"; document.myform2.submit(); } </script>
Can anyone tell me what i am doing wrong, and could you please point me in the right direction?
IE 6.0 (not interested in other browsers at the moment)
I have looked everywhere I can find to look and googled until I am cross-eyed and am hoping somebody knows what I'm doing wrong.
I have an HTML application (.hta) working fine, except one thing. I'm trying to write to a local database from a .htm window (opened from the main .hta window) and it doesn't work with any of the combinations I've tried (and I admit to having tried a lot).
Here is one method I've tried:
strSQL = "Update myTable SET myField = 'myValue' WHERE myID = 12;" var db = new ActiveXObject("ADODB.Connection"); db.Provider = "Microsoft.Jet.OLEDB.4.0";0 db.ConnectionString = "Data Source='c:myDirectorymyDatabase.mdb'"; db.Open; db.execute(strSQL);
I can easily access the information in the myDatabase.mdb and display it on the screen.
I can ask for updated information to be input on the screen.
But stuffing that updated information back into the database is the problem.
Since I'm stuck in an .htm window, I don't have VBScript available, do I? If VBScript isn't available and it isn't physically possible with Javascript, then I'll have to revert to .hta windows, where I know I have VBScript available. But I'd rather do it all in Javascript within the .htm so as to avoid the security message that pops up when the .hta opens a new .hta. For various reasons I don't think it is possible for me to do this whole project within a single .hta.
I am making a webpage that can query a database table of employees and return them in a html table. Currently I have submit buttons beside each employee to open the page to edit their details. I have been using php/HTML to do this, but wondered if it is safe to use javascript to just click on the name of the employee to jump to the edit page. I've been looking on the web for sometime about how to do this without any luck. Any thoughts?
I have 41 <select> fields in a form. When a user makes any selection or change to any dropdown I want to do ajax and send the values of 41 dropdown's to a php page which will compute the values and return a single value which should be displayed in a div.
I have been using PHP for a little while but just getting into JavaScript and really need to dynamically update dropdown boxes read from a mySQL database. There are three dropdown boxes, the first reads in fine. The second dropdown box then gets populated using the selection from the first as the condition in mySQL and the same again for the third.The page refreshes itself after the selection from the first box using JavaScript and populates the second using the PHP _GET method (this works fine). The issue is when I need to do this again for the second time because my JS is only set up to do it once and I don't no how to amend it. Also it will have to do it a third time because I need that info to complete the form and update the DB.
<SCRIPT language=JavaScript> function reload(form){ var val=form.cat.options[form.cat.options.selectedIndex].value; self.location='bookf.php?cat='+val ; } </script>
echo "<form method=post name=f1 action=''>"; ////////// Starting of first drop downlist ///////// echo "<select name='cat' onchange="reload(this.form)"><option value=''>Select a Film</option>"; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['FilmID']==@$cat){echo "<option selected value='$noticia2[FilmID]'>$noticia2[FilmTitle]</option>"."<BR>";} else{echo "<option value='$noticia2[FilmID]'>$noticia2[FilmTitle]</option>";} }
echo "</select><br />"; ////////////////// This will end the first drop down list /////////// ////////// Starting of second drop downlist ///////// echo "<select name='subcat' onchange="reload(this.form)"><option value=''>Select a Date</option>"; while($noticia = mysql_fetch_array($quer)) { if($noticia2['FilmID']==@$cat){echo "<option selected value='$noticia2[FilmID]'>$noticia2[Date]</option>"."<BR>";} else{echo "<option value='$noticia[FilmID]'>$noticia[Date]</option>";} } echo "</select><br />"; ////////////////// This will end the second drop down list ///////////
////////// Starting of third drop downlist ///////// echo "<select name='subcat2' onchange="reload(this.form)"><option value=''>Select a Time</option>"; while($noticia = mysql_fetch_array($quer3)) { if($noticia2['FilmID']==@$cat){echo "<option selected value='$noticia2[FilmID]'>$noticia2[Time]</option>"."<BR>";} else{echo "<option value='$noticia[FilmID]'>$noticia[Time]</option>";} } echo "</select><br />"; ////////////////// This will end the third drop down list ///////////
I have a form with two single-choice dropdowns. Upon doing an onChange event on either one of them, I want to check to see if the other dropdown has also been selected. How would I do that, considering that this.parent causes an error "null or not an object"?
Does anyone know how to event capture on an autocomplete dropdown - this would not be the underlying html element but only on the autocomplete dropdown itself.
I've never come across trying to capture autocompletes before (in fact, ideally i'm trying to ignore keypresses on the autocomplete and only capture those for the underlying input).
I'm trying to get a pair of drop down menus to appear on the screen, one containing months, and one containing years. I know the one containing years works, since it hasn't been changed at all since it was working, but the month box used to be a textbox. I tried to convert it over to drop down box using the same code as the year box, but it hasn't seemed to work.
<script language="Javascript"> var m1 = January; var m2 = February; var m3 = March; var m4 = April; var m5 = May; var m6 = June; var m7 = July; var m8 = August; var m9 = September; var m10 = October; var m11 = November; var m12 = December; .....
document.write('<select name="selYear">'); for (var x=0; x <= 10; x++ ) { if(x != 5){ document.write('<option value="' + x + '">' + yearArray[x] + '</option>'); }else{ document.write('<option value="' + x + '" selected>' + yearArray[x] + '</option>'); }} document.write('</select>'); </SCRIPT>
I am in a problems here trying to generate link by two dropdown boxes. So, I wanted it to be like when user selects some option from dropdown one the href attribute changes, index.php?staticvar=something&dynvar1=something, that is something I have already managed to do:
function change_href(id) { if (id != '') { var dynvar1 = document.getElementById("s"+id).value; document.getElementById(id).href = "index.php?staticvar="+id+"&dynvar1="+dynvar1; return; } else { return false; } } This works perfectly for me, but now I need to modify the href with another variable, so it would be needed to be like: index.php?staticvar=something&dynvar1=something&dynvar2=something2
The problem is that I don't know how to make it the way that user can change their selections, for example if user first selects (from dropdown) dynvar1 to be "test" and dynvar2 to be "test3", but then changes hes mind and decides to re-select dynvar2 to be "test4". It would be needed to be like only the dynvar2 part of the href changes with proper value (not changing the dynvar1 or staticvar).
I managed to make it changeable but it was like this: index.php?staticvar=something&dynvar1=something&dynvar2=123&dynvar2=123
So, it didn't update the dynvar2 part, but instead just added another dynvar2 variable.
I have 2 different dropdowns lists. One for the month and another for the days (shows the date)
by default when the page is loaded, I am showing January in the first dropdown and 1 in the second dropdown (date).
But if a user selects February from the month dropdown list, I just dont want to show 29th, 30th, 31st etc. Same applicable for say april, june, sept etc where I dont want to show 31st so the user will not be able to select wrong date for a month. How can I do this?
The datepicker is connected to three fields (drop downs for..) [Month]/[Day]/[Year]-[Datepicker(Calendar)] now I just wanted to get the dropdowns' values and pass it on a textbox (namely: selectedDate - you can see below) having a format of [mm/dd/yyy]
Code from [url]
Update three select controls to match a datepicker selection
I am using the following code to show / hide form elements within a div based upon the drop down choice. How this code can be amended to use multiple drop downs within one form?
HTML Code: <html><head> <title>Show and Hide</title> <script> // Function that Shows an HTML element function showDiv(divID){ var div = document.getElementById(divID); div.style.display = ""; //display div }
// Function that Hides an HTML element function hideDiv(divID){ var div = document.getElementById(divID); div.style.display = "none"; // hide } .....
I'm looking for a jQuery AJAX plugin that allows me to do the following. I have three dropdowns ( Make, Model, Year), the values of the second and third dropdowns need to dynamically changed based on the selection of the previous dropdown. Example: Dropdown 1 Dropdown 2 ( would change depending on selection in dropdown 1 ) Dropdown 3 ( would change depending on selection in dropdown 2 ) Is there an existing plugin that works?
I've got a form which I want to validate using jQuery to ensure that the same value for a dropdown has not been entered more than once. The form consists of the following:
