[Help]Form Updates Between Users

[lahonda_99]

I have a large form that I would like multiple users to be able to edit at the same time.

Does anyone have any tips on how I can make one users' edit immediately be reflected in the form of another user in a separate browser?

I was thinking about onBlur actions to update a MySQL database. A second onBlur on each form field to call a separate PHP script which would check that MySQL database for changes.

This would be a LOT of talk between users and the MySQL database. In addition I'd probably have to add a second database check on a timer.

Any tips?

[Philip M]

Post this in the PHP forum. Javascript cannot communicate with the server.

All advice is supplied packaged by intellectual weight, and not by volume. Contents may settle slightly in transit.

[VIPStephan]

Well, to me that rather sounds like an AJAX issue. That’s basically a webchat kind of functionality or something what modern webmail or collaboration web applications do.

[XCalibre]

I would think it would be ajax myself. I'm not that experience, but I believe you could create the forms and then linking the forms submit to the database and calling it from the database to post the information that was in your form. Kind of like a chat that refreshes itself. A user posts, and it shows up. A user enters something in the form; it shows up. Ajax would be needed for that type of feature I believe.

This way, it wouldn't matter who updated what...it would automatically update as the user entered the information into the form; no matter where they are located at.

Like I said, I'm VERY new to a lot of this scripting, but I'm learning and hoping i"m correct here. I'm sure if I'm not, someone will come around and correct me Just trying to be helpful. Good luck

[lahonda_99]

Thanks for the thread move and for your ideas regarding AJAX. I'll start reading the AJAX forum for tips

Once I get the data array from my MySQL database how do I use javascript to populate my fields from the array?