MySQL Transaction across Multiple PHP Script Executions

[objnoob]

I need some advice on how to implement, if possible, the following scenario:

 

I would like start a MySQL transaction to process database changes through Ajax requests and commit the changes on request of the user.

 

The web application needs to allow multiple users, but can be limited.

If persistent connections must be used, any persistent connections must be terminated after a length of time, or on session time to avoid hogging the limited number of persistent users available.

 

Is there any good way of doing this? And were should I begin my research.

 

Much thanks!

[postonoh]

Here are two location that may help you.

 

http://www.w3schools.com/php/php_ajax_database.asp

http://www.w3schools.com/ajax/ajax_database.asp

 

let me know if this helps.

If not give me a design layout for your form.

[objnoob]

I'm well aware of how to create Ajax requests using the XMLHttpRequest object, however I do appreciate your response.

 

The goal is to combine the power of Transactional Database data manipulation through intermittent Ajax Requests handled by multiple PHP script executions.

 

It may be more a hassle than it's worth.