Take a look at ezSQL class for PHP. Then you can implement a call for your script handling function which opens a new connection on the server side.
I think your query would look like this $mydb->get_row($mydb->prepare($query)); Although I haven't dealt with the default ezSQL in years I have a modified version. MySQL will handle the simultaneous writing automatically. Matt -----Original Message----- From: Raymond Rösch [mailto:[email protected]] Sent: Thursday, March 15, 2012 3:48 PM To: qooxdoo-devel Subject: [qooxdoo-devel] qx.io.remote.Request and database record locking Dear qooxdoo community I am developping qooxdoo applications using remote requests to read and write data by php from or to a mysql database. I would like to lock database records on a row basis prior to update. The idea is to prevent from data loss when two persons update the same record at the same time. Has somebody implemented such a scenario? How could one release the lock automatically when the browsers session expires? Any hints are much appreciated. Raymond ---------------------------------------------------------------------------- -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ qooxdoo-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ qooxdoo-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
