X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D8AD9D1B18A for ; Sat, 31 Jul 2004 06:15:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40362-10 for ; Sat, 31 Jul 2004 09:15:33 +0000 (GMT) Received: from ariel.globecom.net (ariel.globecom.net [212.116.67.15]) by svr1.postgresql.org (Postfix) with ESMTP id E25F2D1B1CD for ; Sat, 31 Jul 2004 06:15:29 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ariel.globecom.net (Postfix) with ESMTP id A89656548F0; Sat, 31 Jul 2004 11:15:45 +0200 (CEST) Received: from ariel.globecom.net ([127.0.0.1]) by localhost (ariel.bahnhof.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 05594-01-10; Sat, 31 Jul 2004 11:15:45 +0200 (CEST) Received: from mail-gw.globecom.net (mail-gw.globecom.net [212.116.65.149]) by ariel.globecom.net (Postfix) with ESMTP id 2E0786548EC; Sat, 31 Jul 2004 11:15:45 +0200 (CEST) Received: from [10.0.8.131] (STH-10-NAT-212.116.78.2-CUST-BRFFARMEN-CPE.globecom.net [212.116.78.2]) by mail-gw.globecom.net (Postfix) with ESMTP id 14367BC71; Sat, 31 Jul 2004 11:15:28 +0200 (CEST) In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v618) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <2809A35D-E2D2-11D8-ACD4-000A95984CA6@drizzle.com> Content-Transfer-Encoding: 7bit Cc: pgsql-php@postgresql.org From: reiner peterke Subject: Re: [0.0] Re: [0.2] getting transactions to work Date: Sat, 31 Jul 2004 11:15:25 +0200 To: Thom Dyson X-Mailer: Apple Mail (2.618) X-Virus-Scanned: by amavisd-new at globecom.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/63 X-Sequence-Number: 2888 thanks for all the feed back at least now i have a better idea on how to proceede. r On 30 jul 2004, at 20.48, Thom Dyson wrote: > > > > > Under PHP (or any cgi type of process), postgres sessions cannot cross > multiple html pages. This is neither a flaw in PHP nor postgres; it > is a > fact that is database and language independent. > > Each page submission, that is each php invocation, starts a session > that is > closed when the php script is done. the stateless nature of HTTP is at > the > heart of this. A web server sees each page request as a stand alone > event, > with no relationship to any other request. The ability to do > "sessions" is > the work around to this. > > So, if you need to carry information from one web page to another , you > either have to write hidden values to the html page (a bad idea on > sorts of > levels) or use session variables to that PHP/postgres can retain > information. > > Thom Dyson > Director of Information Services > Sybex, Inc. > > > > pgsql-php-owner@postgresql.org wrote on 07/30/2004 09:57:53 AM: > >> i never said oracle did do that. >> i don 't have so much experience working with databases and web pages >> i do not have any understanding or misunderstanding. i am trying to >> learn how it does work here. to my mind it should be able to work >> within a web page. maybe you could be so kind as to explain to me why >> it does not work. > >> r > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org >