|
View a test page with only this function
within:
<?php
phpinfo();
?>
Cheers
----- Original Message -----
Sent: Tuesday, April 20, 2004 11:20
AM
Subject: Re: [PHP] UPDATE - Changing
Password
Hey.
I'd like to thank everyone who helped me. I was
able to fix the code by
printing the query to c wat was wrong, and also,
pg_cmdtuples( ) was very
useful :-).
Does anybody know how to find
out what version of PHP i may be running?
Thanx
Again
Yasmine
>From: "Peter Bayley" <pbay6343@xxxxxxxxxxxxxx>
>To:
"Yasmine Kedoo" <yazkedoo@xxxxxxxxxxx>
>Subject:
Re: [PHP] UPDATE - Changing Password
>Date: Tue, 20 Apr 2004 13:27:01
+1000
>
>Hi Yasmine
>
>As someone else has already
noted, you must be running an early version of
>PHP which doesn't have
the pg_affected_rows function.
>
>The older equivalent function is
pg_cmdtuples() so you should change your
>code to use the older
function
>
>ie:
>
>$result=pg_exec($database, "update
gpinfo set password='$newpw' where
>gpid='$gpidno'");
>if
(!$result) {
> print "There was a problem accessing the
database
>[".pg_errormessage($database)."]\n";
>
exit;
>}
>if(pg_cmdtuples($result) !=1 ) {
>
print "Update Failed: (".pg_cmdtuples($result)." rows were
affected)\n";
> exit;
>}
>print "Update
Successful\n<br>";
>
>Regards
>
>Peter
>
>-----
Original Message -----
>From: "Yasmine Kedoo" <yazkedoo@xxxxxxxxxxx>
>To:
<pgsql-php@xxxxxxxxxxxxxx>
>Sent:
Sunday, April 18, 2004 7:23 PM
>Subject: Re: [PHP] UPDATE - Changing
Password
>
>
> > Hi.
> >
> > I have
changed the code as suggested, but still no luck, and a new
>error.
> > The error is:
> >
> > Fatal
error: Call to undefined function: pg_affected_rows() in
> >
/home/webpages/yamkedoo/Tests/chpw1.php on line 55
> >
> > I
used the following code:
> >
> > if(!$database)
>
> {
>
> echo "Connection
Failed<BR>";
> > exit;
>
> }
> >
> > else
>
> {
> > $gdidno = addslashes(trim($formgpid));
> > $newpw
= addslashes(trim($formnewpw));
> > $newpw1 =
addslashes(trim($formnewpw1));
> >
> > $query = "UPDATE
gpinfo SET password='$newpw' WHERE gpid='$gpidno'";
> > $result =
pg_exec($database, $query);
> >
> > if(!$result)
>
> {
> > print "There was a problem accessing the
database";
> > exit;
> > }
> > else
if(pg_affected_rows($result)!=1)
> > {
> > print "Update
Failed\n";
> > exit;
> > }
> > else
if($result)
> > {
> >
> > print "Update
Successful\n<BR>";
> >
> > }
> > }
>
>
> >
> > I tried removing this section of the
code: else
> > if(pg_affected_rows($result)!=1)
>
>
{
>
> print
"Update Failed\n";
>
>
exit;
>
>
}
> >
> > as this is where the error is, then got "Update
Successful", but the
> > password had not been updated.
>
>
> > Any ideas?
> >
> > Yasmine
>
>
> >
> >
> >
> >
> >
>
>
> > >From: "Peter Bayley" <pbay6343@xxxxxxxxxxxxxx>
>
> >To: "Yasmine Kedoo" <yazkedoo@xxxxxxxxxxx>
> >
>Subject: Re: [PHP] UPDATE - Changing Password
> > >Date: Sun,
18 Apr 2004 17:28:18 +1000
> > >
> > >Hi
Yasmine,
> > >
> > >An update will not return rows
from the query so pg_num_rows will be 0.
> > >You
> >
>should use pg_affected_rows as in..
> > >
> >
> if (pg_affected_rows($result) != 1) {
>
> > ...
> >
>
> > >Regards
> > >
> > >Peter
>
> >
> > >----- Original Message -----
> > >From:
"Yasmine Kedoo" <yazkedoo@xxxxxxxxxxx>
> >
>To: <pgsql-php@xxxxxxxxxxxxxx>
>
> >Sent: Sunday, April 18, 2004 8:18 AM
> > >Subject: Re:
[PHP] UPDATE - Changing Password
> > >
> > >
>
> > > Hi.
> > > >
> > > > I think i've
sorted the previous problem now, it was a stupid error
>on
> >
>my
> > > > part. But the update is still not
working.
> > > >
> > > > I'm using the following
script:
> > > >
> > > > else
> > >
> {
> > > > $gdidno = addslashes(trim($formgpid));
>
> > > $newpw = addslashes(trim($formnewpw));
> > > >
/*$newpw1 = addslashes(trim($formnewpw1));*/
> > > >
>
> > > $query = "UPDATE gpinfo SET password='$newpw' WHERE
gpid='$gpidno'";
> > > > $result = pg_exec($database,
$query);
> > > >
> > > >
> > > >
if(!$result)
> > > > {
> > > > print "There was
a problem accessing the database";
> > > > exit;
> >
> > }
> > > > else if(pg_numrows($result)!=1)
>
> > > {
> > > > print "Update Failed\n";
> >
> > exit;
> > > > }
> > > > else
>
> > > {
> > > >
> > > > print "Update
Successful\n<BR>";
> > > >
> > > >
}
> > > > }
> > > >
> > > > It is
just printing Update Failed now. Can u see where i'm going
>wrong?
> > > >
> > > > Visit the
following link:
>www.cyber.brad.ac.uk/~yamkedoo/Tests/chpw.html
>
> > >
> > > > Username: jjsanderson
> > >
> Password: sanderso
> > > >
> > > > Then on
the next page, GP ID: GP000001
> > >
>
New Password: hello
> > > >
> > > > and ignore
retype password for now. As u can see, it is printing
>update
>
> > > failed. Can u see the prob?
> > > >
> >
> > Cheers
> > > >
> > > > >From: Robby
Russell <rrussell@xxxxxxxxxxxxxxxxx>
>
> > > >To: Yasmine Kedoo <yazkedoo@xxxxxxxxxxx>, pgsql-php@xxxxxxxxxxxxxx
>
> > > >Subject: Re: [PHP] UPDATE - Changing Password
> >
> > >Date: Sat, 17 Apr 2004 14:57:43 -0700
> > > >
>
> > > > >Yasmine Kedoo typed this on 04/17/2004 02:48
PM:
> > > > >>Hi Robby.
> > > >
>>
> > > > >>That was recommended to me by someone
else :)
> > > > >>
> > > > >>When i
remove the trim, i still get the same problem.
> > > >
>>
> > > > >>Any other ideas?
> > >
> >>
> > > > >
> > > > >Are you
getting the same exact error at the same exact character in
> >
>your
> > > > >query? Send me your error and I'll help
you more.
> > > > >
> > > > >Robby
>
> > > >
> > > > >--
> > > >
>Robby Russell, | Sr. Administrator / Lead Programmer
>
> > > >Command Prompt, Inc. | http://www.commandprompt.com
>
> > > >rrussell@xxxxxxxxxxxxxxxxx | Telephone: (503)
667.4564
> > > > >
> > > >
>---------------------------(end of
> >
>broadcast)---------------------------
> > > > >TIP 3: if
posting/reading through Usenet, please send an
>appropriate
>
> > > > subscribe-nomail command to
majordomo@xxxxxxxxxxxxxx so that
>your
> > > > > message
can get through to the mailing list cleanly
> > > >
>
> > >
_________________________________________________________________
> >
> > Express yourself with cool new emoticons
> >
>http://www.msn.co.uk/specials/myemo
> > > >
> >
> >
> > > > ---------------------------(end of
>broadcast)---------------------------
> > > > TIP 6:
Have you searched our list archives?
> > > >
> > >
>
http://archives.postgresql.org
>
> > >
> > >
> >
> >
_________________________________________________________________
> >
It's fast, it's easy and it's free. Get MSN Messenger today!
> > http://www.msn.co.uk/messenger
>
>
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the
postmaster
>
>
_________________________________________________________________
Use
MSN Messenger to send music and pics to your friends
http://www.msn.co.uk/messenger
---------------------------(end
of broadcast)---------------------------
TIP 3: if posting/reading through
Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that
your
message can get through to the mailing
list cleanly
|
