I have a table in a database that gets populated by a client application. Whenever an entry is written to the table I want to fetch the data (which contains the longitude and latitude) and display a marker on Google Maps. I am using the Google Maps Javascript V3 API. Reading the tuples from the database is currently done through a PHP script. How can I update the map each time a tuple is written to the database?
View 1 RepliesI am trying to create a web page in which the contents of one selection list
depends upon which element in another selection list is chosen, but where
the information to populate the first selection list comves from an SQL
database on the web server.
There are a couple of these situations in my application but, for example,
the first list might be a list of counties, and the second list a list of
states/provinces. Obviously the names of counties depend upon which
state/province is chosen, but there are too many possibilities to be able to
embed them within the web page itself. So when the user selects a
state/province I need to go to the server to ask for the list of counties.
I have seen a number of posts that sort of address this issue. For example
it is suggested to use <script src="a URL"/> to ask the server side code to
send up data of type "text/javascript". However the examples do not seem to
address how the server side code would know which state/province the user
had selected.
If there is a web site that addresses this sort of thing, I would appreciate
any pointers.
I have a textbox on one of my forms that is used to accept a time from the
user. I need to write this value to a database to trigger an event later on.
What I'd like to know is...
Are there any functions in javascript that can convert different time
formats to a known format (24 hour clock)... 5pm -> 17:00 or 5:00 to 05:00,
etc. ???
Assuming that I get the input into a 24 hour format, how can I create a full
time/date variable with todays date and the users entered time?
Finally, if the entered time is earlier than the current time, how can I
create the above date/time combination using tomorrows date?
I put together this quick form that allows a user to sign up - the data.php just basically checks a mysql db if the username exists, and either-if it doesn't exist - create an entry in the database with the username, pw, and email and echo "Congratulations, you are added";-if it does exist - it echo "Sorry but 'xxx' is already taken, try again!";his is the weird part though. This works perfect in FF, but IE6 has a weird issue (I only have IE6 here can't test anything else) - With IE6, if the page is freshly loaded, it gives me the correct message - that is, if i put a non-existent name in, it does the echo"Congratulations, you are added"; but if I click on submit again - it doesn't echo "Sorry but 'xxx' is already taken, try again!"; (it does on FF) -If I start a fresh page and input a name that's already in the database it does echo "Sorry but 'xxx' is already taken, try again!"; -- but if i change the username to something that doesn't exist - it doesn't change the echo (i.e. it still says "Sorry but 'xxx' is already taken, try again!"; - but the record is created in mysql! code:
Code:
<html>
<body>
[code].....
I have an options list that is generated from a database. It currently has ~125 options in it. I've received the request that the user be able to either enter the corresponding number or select the option from the list. How can I update the "selected" attribute in the options list based on a number that may be entered in another text entry box?
View 4 Replies View RelatedI'm writing a program that would automate data entry (from an excel spreadsheet) into an online database. I've been doing them one by one for the past couple of weeks...only have about 10,000 left.
View 4 Replies View RelatedI'm trying to populate a form with information from a database based on a textbox entry. However, when I begin to key in the textbox I receive "undefined" in each textbox throughout the form.
Take a look at my code for any errors? It also appears that my $_GET['jobid'] is not working properly.
And here is my php:
I am working on a chat program. When a user logs in, a value in the database is set to 1 (online), and when he/she logs out it is set to 0 (offline). The problem is, when the user exits the browser, naturally the value is still set to 1.
I was wondering if it is possible using AJAX or otherwise to update the database on the event of browser close? I have tried onbodyunload in the body tags pointing to a file with a JavaScript function containing the PHP code (query to update the field) but cant get it to work.
I'm trying to update a sql table from mi php Ajax web page, which stores dynamically a table into the page by table.appendChild(row) , so that the user can verify the information he is inserting before the actual database update.
How do I do this with ajax?
we are developing an web application. In this user has an option to comment or mark a video. After user commented or marked it has to shown automatically on the page with out refreshing the page.
View 1 Replies View RelatedI am a newbie in web development. I need to create a function that works whenever user print a web page, I would like to get the date and record that date into database. Additionally, the function must work on IE & Firefox. There is onbeforeprint() event in JavaScript, but that only works in IE.
View 2 Replies View RelatedI have a been developing an Online auction website using PHP and Mysql for the last few weeks. I have implemented everything including the 'bidding', 'buy it now' options of the auction etc.
I don't know much about AJAX to be honest, but I think it is the technology I need for this... My requirement is to devise a way of updating (in real-time) the current price of a particular auction product as more and more users bid on the item. Once a user bids on the item, the bid table of the database is updated with the highest bidders price. So once this value changes in the database, would it be possible to update the price on the webpage? Obviously, it is important for this update to be as accurate as possible to maintain the integrity of the auction.
I was wondering if someone could help me out with the following.I'm developing a webshop CMS in which you can create categories. By using jquery's ajax method I'm making a POST request to a PHP script which then handles all the data supplied to it. This works good and all except for the fact that after the query is being executed my HTML doesn't get updated, at least not as well as I want it to.I understand that the common way of working here is to update HTML in the success callback of the ajax method. But the thing is that every category is being displayed as a list item with an id attribute, this id corresponds to the id the category has in the database.If$.ajax tells me that everything went down smoothly and my query has been executed then there's still no way for me to know which id this new category has been given so that I can update the HTML accordingly.
What would be a "smart" way to tackle this? The first thing that comes to my mind is simply calling another script which figures out the last inserted id on the db but that would mean doing an ajax request in the callback of another ajax request? That doesn't sound right to me..
im trying to add a star rating system to a website. id like to do something elegant graphically instead of just using a drop down... the javascript framework im using is mootools and i found a great rating system here, but have no idea how to adjust it so that it updates the database with the new rating vote from the user and it calculates the new average rating.
the way i have the database set up for this is with the following fields: id (the rating's unique id) listingid (the listing that the rating corresponds to) userid (the user that entered the rating) rating (the rating itself)
i use php to communicate with a mysql database. the file im going to write will check to see if there is already a rating entered in from the logged in user. if there is, it will update it. if not, it will insert it, then it will calculate the average of all votes for that listing (rounded up) and return the new rating to the page and set the stars to reflect that rating... ive tweaked the code a bit to represent a 5 star system instead of a 10 star system and also so it can be used multiple times on a page.
heres what ive been playing with:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
[Code].....
I have a problem, I am by no means new to PHP/Javascript but am finding an error that I cannot ridicule how to stop.Ok Ill try and explain it in simple terms:I have two divs, div1 and div2,In div1 there are links whitch are fetched from the databaseIn div2, content from links href ? in div1 is collected through AJAX.No I have a php preg_replace function that replaces it to look like <a href='#' onclick=\"showTopic(0,$char,'$1');\">$1</a> Now when you click this, it inserts into the "tpm" table in the database,(this table holds the links for div1) But it will not update the links unless i refresh the page? I would like to knoe how to update the links in div1 without refreshing, because refreshing = going back to the start of the code i am working on.
View 3 Replies View RelatedThis jquery code pulls in an XML file, then passes the contents down to the nested POST call to add all of the records from the XML into a database table (which is handled by the saveSenatorRecord.asp file). This all works fine.. except that when the POST is called for "EACH" of the member nodes I expected the success: function to be called once after each of the records are added to the table. But what appears to be happening is that when function is called in the EACH property... it adds all of the records to the database table at one time, THEN it calls the success function once for each individual record.. but AFTER they have all been added.
View 1 Replies View Relatedi want to add a part of the website that will be generated from mysql database from an external file just like php include just that i want these parts to update realtime without refreshing the browser. i also want it to have pagination.
View 6 Replies View RelatedThere is a missing part on my program, it is when you input less than or equal to 65 and greater than 100, a prompt will appear and say "Invalid Entry" and ask you to Input again an entry until you enter a valid entry. For example on Prelim Grade, I input 50, a prompt must appear to say "Invalid Entry" and ask me to input again another entry. Another is how will I terminate the program? When I input an invalid or a valid entry, it is continuing to ask me to input again an entry.Here is my code
Code:
<html>
<head>[code]......
Can i use single jquery and html to do some database manipulation i.e. database transaction.
View 1 Replies View RelatedI want to be able to grab words from a database with javascript. How do I do that?
View 2 Replies View RelatedI 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.
Here is my form fields:
Here is my java script:
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?
I have a value, j[i] , which Ineed to do the following with:1) split with / to make an array2) Return the last valueFor example:Continent/country/State/City..and it would return "City", and with:Continent/country/State..it would return "State"Can anyone point me in the right direction?In Perl, I would just do:
my @tmp = split ///, $val;
my $last_val = $tmp[$#tmp];
var variable = parseFloat(document.getElementById('name').value);
alert (variable);
how do I get the alert to say 0 instead of the pesky NaN? I want failure (deliberate or not) to enter anything in a form input field to count as zero.
I'm refering to an entry in an array by it's string key, as in
foo["bar"]. Is there a way to get the numeric index of that array
without iterating through the entire array?
What I need to do is find the "next" or "previous" entry in the array,
but the keys are strings, instead of numerical indeces.