Bug #16855: PHP ignores the pg_query.
| From: | d-m at eudoramail dot com | Date: | Fri, 26 Apr 2002 15:49:45 +0000 |
| Subject: | Bug #16855: PHP ignores the pg_query. | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-6135@lists.php.net to get a copy of this message | ||
From: d-m@eudoramail.com
Operating system: Slackware 8.0 Kerel 2.4.19.7
PHP version: 4.2.0
PHP Bug Type: PostgreSQL related
Bug description: PHP ignores the pg_query.
In php 4.2.0 the same php that I run at 4.1.2 do not return the values of
the select.
Anyone know why do not work at 4.2.0 ? Its a bug or something changes a
lot??!
SAMPLE (This code run at 4.1.2 and dono at 4.2.0)
VALIDADE LOGIN.php
$connection = pg_connect("host=localhost port=5432 dbname=admins
user=myuser password=PASSWORD")
or die ("I Could not connect to PostGres --> " .
pg_errormessage($conn));
$result=pg_exec($connection, "SELECT pass FROM adm WHERE login =
'$inLOGIN'")
or die ("Somethig wrong at the Query");
$num = pg_numrows($result);
if ($num != 0)
$fetch = pg_fetch_row($result, 0);
$TiTuLo = "DB Varilux Admin";
$BaCk = "index.html";
if ($inPASS == "") {
include('header.inc');
echo "<font color=#FF9000> Oooooops!</font> User name or password no
valid<BR> Try
agin";
include('footer.inc');
pg_close ($connection);
exit;
}
if ($inPASS == base64_decode($fetch[0])) {
$to_cookie = base64_encode("OK");
setcookie("admins",$to_cookie,NULL,NULL,NULL,0);
$to_cookie2 = base64_encode($inLOGIN);
setcookie("admin_login",$to_cookie2,NULL,NULL,NULL,0);
include('menu.html');
}
else {
include('header.inc');
echo "<font color=#FF9000> Oooooops!</font>Username or password
invalid<BR>try agin";
include('footer.inc');
}
pg_close ($connection);
--
Edit bug report at http://bugs.php.net/?id=16855&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=16855&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=16855&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=16855&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=16855&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16855&r=support
Expected behavior: http://bugs.php.net/fix.php?id=16855&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=16855&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=16855&r=submittedtwice