Re: PostgreSQL locking from PHP scripts

[Herbie McDuck <herbie(at)faams(dot)net>]

Alan Hodgson wrote:
> On Thursday 26 October 2006 11:11, Amal burman <amalburman(at)yahoo(dot)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.