ID: 16855
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Bogus
Bug Type: PostgreSQL related
Operating System: Slackware 8.0 Kerel 2.4.19.7
PHP Version: 4.2.0
New Comment:
If you need sample scirpts, it's under ext/pgsql/test/.
Previous Comments:
------------------------------------------------------------------------
[2002-04-28 13:34:02] [EMAIL PROTECTED]
I think you dont understand my problem.
I wanna make a simple select but PHP 4.2 do not returns the lines of
the select after the $fetch = pg_fetch_row($result, 0); WHY? The php
4.2 changes the method of making a select ?!? is not more like
$result=pg_exec($connection, "SELECT pass FROM adm WHERE login =
'$inLOGIN'")
or die ("Somethig wrong at the Query");
Could you sent me a sample of select ?!?
Thanks in addvance
Helio Ferenhof
------------------------------------------------------------------------
[2002-04-26 19:19:45] [EMAIL PROTECTED]
I meant
(or use 4.2.0's pgsql module with 4.1.2)
It should work.
------------------------------------------------------------------------
[2002-04-26 18:59:14] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
