Re: PostgreSQL locking from PHP scripts - Mailing list pgsql-php

From Herbie McDuck
Subject Re: PostgreSQL locking from PHP scripts
Date
Msg-id 454FD71E.6070807@faams.net
Whole thread Raw
In response to Re: PostgreSQL locking from PHP scripts  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: PostgreSQL locking from PHP scripts
Re: PostgreSQL locking from PHP scripts
List pgsql-php
Alan Hodgson wrote:
> On Thursday 26 October 2006 11:11, Amal burman <amalburman@yahoo.com> wrote:
>
>> postgresql database for this project. Here script one
>> (booking.php) tries to setup a lock for update and ask
>> user to fill-up the form. Now when the user fill-up
>> the form and submit it for update, second script
>> (update.php) update the database and releasing the
>> locks.
>>
>
> You can't do this kind of thing in PHP.  PHP resets the database connection
> between scripts.   The script is finished as soon as the page is delivered
> to the client.
>
> Also, web connections are stateless and there is no way to even know what
> web server process or database connection you'll be getting on subsequent
> page views.
>
>
So is PHP and 'ANY' database a useless adventure when it goes to
developing a robust business and accounting package?

--Hal.


pgsql-php by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: PostgreSQL locking from PHP scripts
Next
From: Chris
Date:
Subject: Re: PostgreSQL locking from PHP scripts