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:
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?
If I want to show the result of a database query, every second or so, is the best method using javascript/ajax with a set interval of a second to call a PHP script and update the DOM, or is there some other method better suited to this that would not have the cpu overhead if there were many users on the site.
i having problem on passing the database query result to the javascritpt for calculation.i doing a program that need to calculate the total_price for the purchase items. i use getString to get the foodID, f_item and the unit_price from database, then i need to use the unit_price for doing the calculation in javascript. after get the data from database, the unit_price is used to multiple with the qty that user input to calculate the total_price.since there are several row of data get from database, so user need to enter the qty for each item and then press [Calculate_db] button to perform the calculated result. hence, the total_price for each item is calculated and the sum of all the total_price also being calculated and display in the page.now, i having problem on pass the unit_price to the javascript for calculation.
I'm making a little CMS, and I need to use AJAX to query the DB to see if an email is already registered. Here's my code so far:
The javascript: Code: <script> function getEmail(){ var ajaxRequest; try{ ajaxRequest = new XMLHttpRequest(); } .....
I'll test it by entering javascript:alert(getEmail()) in my browser, and it returns undefined. When I replace return 'valid/taken' to alert valid/taken, it will alert the values correctly, but for some reason it has to be entered twice (I have to hit enter twice in javascript:getEmail() for it to be correctly outputted). I'm relatively new to ajax and I think it might have something to do with the readyState not being correct.
I am starting to find more web pages that are using a query parameters after the JavaScript file.
Example can be found at www.opensourcefood.com. Within the source you'll see: <script src="/shared/scripts/common.js?revision=1.6" type="text/javascript">.
I am trying to see if there is any big deal to this or a best practice that is starting to creep up in the JavaScript community. If this is used only as a way to distinguish what file of JavaScript being used why not append something inside the file? Has anyone else seen this or know of more reasons to do this?
I have used the code from Sitepoint Javascript anthology (page 130) to create a popup on my pages, however I have a list of pdfs each of which needs to open in a popup and the code only works with the very first in the list. the rest of the pdfs open up in the window as normal. How can I adapt this and would I have to separatly number each id: ?
On some sites I have worked on, users can delete content from their site. When they go to delete an item, I take them to a page where I pull the item details of the item they are about to delete from the dbase, and say "Are you sure you want to delete so and so". They can choose Yes / No. Yes takes them to action that runs the SQL to delete the item from the dbase. No takes them to the previous page.
I have seen some sites that have managed this process differently, where, instead of being taken to another page, a little pop up box opens saying "Are you sure", with a Yes / No option on it. Yes takes you to delete the item, No leaves them on the page they are on.
Am I right that this method uses Javascript? I know that it won't work if javascript is turned off, but - most people don't turn it off...
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?
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??
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.
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 have been searching how to connect to a database and execute some queries, and then use the data that I get to populate some tables in a web page, all this using javascript.
I am confused because I have seen in some webpages that javascript is not designed to connect with databases, and also I have see other pages where they say that it is possible.
Does anyone know if it is possible to use javascript to connect to a database (informix), and execute some procedures or queries?
I am having no luck with my post form to mysql. It is only posting the first letter of the word/phrase for the text input fields to the mysql database. It is a photo and text post form. The photo and only first letter of text are posting to database. I am using Jqtouch, jquery, and phonegap.
I am attempting to create an Access database connection from within an HTML page. I am using Javascript to make the connection and then test a basic UPDATE statement.
The following code is throwing back an error 'UPDATE statment syntax incorrect'
Code:
I thought the syntax was correct, but maybe it is something else?
