--On March 24, 2008 9:03:35 AM +1000 Da Rock <[EMAIL PROTECTED]> wrote:

I know this is not quite the list for these things, but I tried the PHP
list and got no reply whatsoever. In fact, I don't think anyone's home
cause the entire list is silent...

I'm trying to setup a system using web apps in PHP using MySQL as the
backend database, only this time I need transaction services. According
to the PHP manual if a transaction is served for MySQL it can come back
as committed even though it may not. So what I'm trying to accomplish is
develop some row level locking with the PHP script.

I enquired about setting up a servlet (for want of a better term) with
PHP, something that will serve the requests of the rest of the app. To
be honest though, I'm not entirely sure how to approach this.

Any ideas would be very welcome.


Following list etiquette, I'm replying to you and the list.

I believe that postgresql has transaction locking. You might consider using it instead. Mysql is supposed to have transaction locking in version 5.1, but I haven't tested it and don't know how robust it is.

Paul Schmehl ([EMAIL PROTECTED])
Senior Information Security Analyst
The University of Texas at Dallas
http://www.utdallas.edu/ir/security/

_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to