Perform mySQL update after onChange

sanzalure

I have a form with various fields to manage data in a mySQL database.

Data consists mostly of paragraphs of text and I'm trying to make the form behave somewhat like a text editor.

When the user makes a change in the TEXTAREA and gets out of the field, an 'onChange' event is triggered.

I would like at that point to grab the new contents of the field and send it as a parameter along with the id of the record to a php script that would update the corresponding mySQL record on the server, all without having to submit the whole form and redisplay the screen.

Also this way, the data would be saved even if the user forgets to click on the SAVE button before leaving the page.

Thank you for your help!

Serge

bastien

i would put a hidden field on the page holding the rowID or whatever unique id you use for the record.

the onchange should fire a form submit...though I think it should fire in an onBlur event or every keystroke will cause the event to fire. You may want to even cause the submit to come from a few events in case the user closes the browser (onUnload event) as well (this goes inthe <Body> tag)

hth

bastien