| From: | reiner peterke <zedaardv(at)drizzle(dot)com> |
|---|---|
| To: | <bedouglas(at)earthlink(dot)net> |
| Cc: | <pgsql-php(at)postgresql(dot)org>, "'Rod K'" <rod(at)23net(dot)net> |
| Subject: | Re: [0.2] getting transactions to work |
| Date: | 2004-07-30 16:08:25 |
| Message-ID: | AFAD701E-E242-11D8-8EE0-000A95984CA6@drizzle.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
well i've read about this thing called persistent connection,
i think it is supposed to exist in mysql also. the idea sound like
what i want. i've tried it but i didn't get any different results. but
then i'm not convinced i did it right either.
r
On 30 jul 2004, at 17.21, bruce wrote:
> if psgres works as mysql.... you should be able to do it...
>
> but the issue appears to be that the connection you establish with the
> db in
> one page, is not available once you shut the page down.
>
> within mysql, there appears to be a mysqli group of functions that are
> setup
> to accommodate transactions across multiple pages... i would
> imagine/hope
> that the same sort of functionality is available for posgres....
>
> i'm getting close to needing the same functionality with mysql, and i'm
> betting/hoping like hell that what i've just described is how mysql/php
> works...
>
> -bruce
>
>
> -----Original Message-----
> From: pgsql-php-owner(at)postgresql(dot)org
> [mailto:pgsql-php-owner(at)postgresql(dot)org]On Behalf Of reiner peterke
> Sent: Friday, July 30, 2004 8:04 AM
> To: Rod K
> Cc: pgsql-php(at)postgresql(dot)org
> Subject: Re: [0.2] [PHP] getting transactions to work
>
>
> this is meant in all honesty,
>
> then whats the point?!
>
> ok, let me put it this way. is there no way to implement pages using
> transactions?
> otherwise it seems to kind of defeat the purpose of them.
>
> r
> On 30 jul 2004, at 16.57, Rod K wrote:
>
>> 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
>>
>>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
> joining column's datatypes do not match
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod K | 2004-07-30 16:13:35 | Re: [0.0] Re: [0.2] getting transactions to work |
| Previous Message | reiner peterke | 2004-07-30 16:05:06 | Re: [0.0] Re: [0.2] getting transactions to work |