From: | reiner peterke <zedaardv(at)drizzle(dot)com> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | getting transactions to work |
Date: | 2004-07-30 14:53:01 |
Message-ID: | 27ABA345-E238-11D8-8EE0-000A95984CA6@drizzle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Rod K | 2004-07-30 14:57:47 | Re: [0.2] getting transactions to work |
Previous Message | Daniel Struck | 2004-07-30 09:43:31 | Re: [ADMIN] Secure DB Systems - How to |