Bug #16855 Updated: PHP ignores the pg_query.
| From: | yohgaki@php.net | Date: | Fri, 26 Apr 2002 23:19:45 +0000 |
| Subject: | Bug #16855 Updated: PHP ignores the pg_query. | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-6180@lists.php.net to get a copy of this message | ||
ID: 16855
Updated by: yohgaki@php.net
Reported By: d-m@eudoramail.com
Status: Bogus
Bug Type: PostgreSQL related
Operating System: Slackware 8.0 Kerel 2.4.19.7
PHP Version: 4.2.0
New Comment:
I meant
(or use 4.2.0's pgsql module with 4.1.2)
It should work.
Previous Comments:
------------------------------------------------------------------------
[2002-04-26 18:59:14] yohgaki@php.net
If you need portablility, please used old names mentioned in manual
pages. (use 4.2.0 pgsql module with 4.1.2)
------------------------------------------------------------------------
[2002-04-26 11:49:44] d-m@eudoramail.com
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 this bug report at http://bugs.php.net/?id=16855&edit=1