From: Rod K <rod@23net.net>
To: reiner peterke <zedaardv@drizzle.com>
Cc: pgsql-php@postgresql.org
Subject: Re: [0.2] getting transactions to work
Date: Fri, 30 Jul 2004 10:57:47 -0400
Message-ID: <410A61EB.6070008@23net.net> (raw)
In-Reply-To: <27ABA345-E238-11D8-8EE0-000A95984CA6@drizzle.com>
References: <27ABA345-E238-11D8-8EE0-000A95984CA6@drizzle.com>
You are correct. You cannot have a transaction span multiple pages/scripts.
reiner peterke wrote:
> there seems to be very little info around on actually using
> transactions with postgres. i've tried to create a page that will
> take input from a form and insert it into my database. it works if i
> just do it without transactions but when i try to use with the begin
> and commit sections of code, it doesn't update the data base. i'm
> guessing it is doing a rollback when my page loads itself again. can
> anyone help me out here ?
>
> thanks
>
> r
>
> code below
>
> <html>
> <head>
> <submitle>those eyes</submitle>
> </head>
> <body>
> <?
> $conn = pg_connect("dbname=entish user=postgres");
> if(!$conn)
> {
> print "not for the chocolate";
> exit;
> }
> if ($_POST[submit]) {
>
> $begin = pg_query("begin");
> $isql = "insert into diety(diety,culture,gender)
> values
> ('$_POST[diety]','$_POST[culture]','$_POST[gender]')";
> printf("-- %s --\n",$isql);
> $results = pg_query($isql);
> ?>
> <form method="post" action="<? echo $PHP_SELF?>">
> <input type="Submit" name="action" value="commit">
> <input type="Submit" name="action" value="rollback">
> </form>
> <?
> }
> else if(!$_POST[action]) {
> ?>
> <form method="post" action="<? echo $PHP_SELF?>">
> Diety:<input type="text" name="diety"><br>
> Culture:<input type="text" name="culture"><br>
> Gender:<input type="text" name="gender"><br>
> <input type="Submit" name="submit" value="enter">
> </form>
> <?
> }
> else {
> if($_POST[action] == 'commit') {
> echo "let me see";
> $act = pg_query("commit");
> }
> else {
> $act = pg_query("rollback");
> }
> } //end if $_POST[submit]
> ?>
> </body>
> </html>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: rod@23net.net, zedaardv@drizzle.com
Subject: Re: [0.2] getting transactions to work
In-Reply-To: <410A61EB.6070008@23net.net>
References: <27ABA345-E238-11D8-8EE0-000A95984CA6@drizzle.com> <410A61EB.6070008@23net.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox